Thanks to Vasc!

The performance of the second one is much faster than the first one.

It is under a minute in a huge table. Many thanks.

Thank you exactly what I was looking for.

I am trying to convince a cheap client on not installing SQL Server on a Domain Controller. I am trying to construct...

Any input greatly appreciated, except for that one.

You cannot have nulls in the column. If you are receiving an error there are probably nulls.

Scripting from enterprise manager changing a column to Identity, it creates a table...

Data Transformation Services will accomidate. You can create a DTS package and save it then run it within SQL.

For a one time import just right mouse on the table...

This query does as you as. Difference between two most recent. Dont you want the difference between the start and end of each query though? I inserted you data into...

nothing like using a sledgehammer to kill a flea, but how this function which you pass the begin date, end date and what date part you want using 1 or...

The uniqueidentifier is the primary key. I used the newid() in the procedure and it worked (you had it noeld).

There is no issue like with auto assigned integers that...

And thats Conundrum not Conondrum. Sorry.

Works if your pointing to PUBS. So I would have to say, really, really bad question.

I have found that defraging a drive is always a good idea. Keep in mind that SQL Databases are always open and are almost always written to in some way...

I would do:

1) Events over a specific serverity instead of each error. You can specify a severity level instead of an error. So put all the show stoppers in. It...

TCP/IP should be setup in the client network utility under sql server group. Just having TCP/IP present (loaded on the workstation) is not enough.

Create an entry in the network...

Just standing on the sholders of great minds like Itzik Ben-Gan.

Or using my same table above and same concept this just lists the lower missing number and upper missing number for each range missing:

SELECT (tableid + 1) LowerMissing, (SELECT...