When I need to process many actions for many records, to avoid cursors I
load the records into temporary tables and then pick them one by one,
deleting the active key at the end of my processing loops. For example this
is what I usually do:

I'm using MSSQL2K and have troubles getting a query faster.
The table where the query is run against has 400.000 records (and grows every day further) with 70 fields. One of those
fields is a non-nullable datetime field and there is an index on that field.
The maximum number of ...

I would like to create a query that would group all records that are in 10 minutes intervals.
stamp1, 8-12-2008 8:00:00.000
stamp2, 8-12-2008 8:03:00.000
stamp3, 8-12-2008 8:13:00.000

Is it any API that uses SMO to create the database objects like
tables, triggers, sp etc ... from a snapshot??
any help will be appreciate
Thanks

[SQL2000]
CREATE TABLE [Registration] (
[FirstName] [varchar] (35) NULL ,
[LastName] [varchar] (35) NULL ,

I have a big table with all data in it (like a fact table in star schema),
No indexes yet.
What is better to fillter the data by adding a criteria to the WHERE clause OR
Joining the dimension table and filltering the records by filltering the

Let's same I'm in SQL 2005 Express and I'm currently in a database instance
XX. Now I want to do an update query that will update the contents of a
different database, residing in a different SQL instance YY.
Is this possible? How would I do this...issue 2 different login ...

I'm setting up an inventory system that needs a multilevel Bill Of
Materials, My initial take is to is have a BOM table with all the component
parts (for back flushing inventory), and a BOM_II table to set up the
linkage between the parent part and it's children.  Any comments,

I'm using a main table for Items (common information), and then associated
tables add item-type specific information (so I can get all Widgets and
associated data by INNER JOINing Items to Widgets (on ItemCode), or all
Gadgets and their (different)associated data by INNER JOINIng ...

I have a table called membership, which contains two columns, memberID and
Enrollment date.  I need to create a summary report to sum up of each month
of each year the total number of enrollment.
I am using SQL 2005

I have a job step set to send out an email on job failure and the job runs
every 15 minutes. After the first failure, I want to change the on failure
setting to “quit on failure” so that the next time the job runs, the email is
not sent out. How do I do this?

I need a solution to a problem.
We  execute a stored procedure everyday in which it performs a lot of updates in the database and the updates are within a transaction.And at the end we use to create a log file from the log table using bcp command.
The problem is, at times the ...

I tried to install SQL server, and I've got the error:
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Fatal Error
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

today i've got new error when i tried to send mail vi sql_mail:
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 1 (2008-12-07T05:15:55). Exception
Message: Cannot send mails to mail server. (Insufficient system storage. ...

All:
    Are there any T-SQL online tutorials on the following -- Triggers and Stored Procedures. Thank you.
Keith