I am still not sure. But anyway, the only correct thing to do is to try a few different alternatives and choose the one that performs the best.

I do not...

Do you have anything specific to back that up with? For instance, take a look at this old thread where the same thing was discussed:

Minus in SQL Server

This is easily done with a numbers table. The following query should work, it creates a virtual numbers table and uses it to find missing ids. Just make sure enough...

Ok, let me see if I understand correctly what you want.

SELECT ID, CONVERT(varchar(8), Date, 114) AS Date

FROM Session

WHERE SquadId = 5

AND Date BETWEEN '2006-01-10 00:00:00' AND '2006-01-10 23:59:59'

Does that give...

Just to make the answer complete here, in case anyone looks for this kind of question. The reason the counts in EM can differ is that it just shows the...

Why not set up a test database that he can do as he wish with. Make him dbo of that database, then when he needs something changed in the production...

Database Mirroring is available in Standard Edition. However, currently Database Mirroring is not supported in any edition of SQL Server 2005. The feature was 'pulled' late in the process, so...

SELECT foo.Field1, foo.Field2, foo.Field3

FROM thetable foo

INNER JOIN (

SELECT Field1, MAX(Field2) AS Field2

FROM thetable

GROUP BY Field1

) bar

ON foo.field1 = bar.field1 AND foo.field2 = bar.field2

My guess is that the code that performs the update does not update the entire set of rows at once, instead it loops through it and updates row-by-row.

I would guess that you have a job scheduled that truncates the log.

Can you ping the server? Have you tried specifying IP-address instead of server name? Can you connect using TCP/IP? Is the server installed as default instance?

Asaf, if you are looking for a way to specify a contract, such as in Design-by-Contract supportive languages, for the parameters of the procedure then there is no such support...

Split the values using a function such as the following:

CREATE FUNCTION dbo.fnListToSet (@list VARCHAR(8000), @delimiter VARCHAR(3))

RETURNS TABLE

AS

RETURN

SELECT s.tuple

FROM (

SELECT SUBSTRING(

@delimiter + @list + @delimiter

, numbers.n + LEN(@delimiter)

, CHARINDEX(@delimiter, @delimiter +...

Please, let us know in which way DRI degrades performance? Simply stating that "it bog things down unbelievably" is ridiculous.

CREATE TABLE dbo.foo (a INT NOT NULL, b INT NOT NULL)

CREATE...

Hm, now I do not have the experience from learning the hard way about this (not that I can recall at least). However, you did not copy-paste all what BOL...