Depends on how you are comparing the rows if you need to compare the row items only to those in the same row you can use a case statement to...

No GetDate() is a funtion that returns the server time at the time it is run. So you run it say at 11:15 am exactly today you get

2002-11-06 11:15:00.000

but if...

When doing an Update, you do have to do a set value for each column

SET col1 = i.col1, col2 = i.col2

The i is the alias name Steve associated with the...

Duplicate post, please lock thread or delete, see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=7971&FORUM_ID=5&CAT_ID=1&Topic_Title=Cache+miss&Forum_Title=Administration

It is always better for performance to use the 3 part name (fully qualified name) even when not prefixed with sp... . Better to not use sp unless you have...

Most of the files will be more current than any that may be layed down by the OS and should not be overwritten without at least asking. Settings in the...

Yes, it is unusually and it should fail. Usually this happens when a piece is in use and the resource locked. I would cancel it if possible or wait until...

That also depends on your infrastructure and network topology. If you have to cros a number of router segments and have other traffic on the line it will take longer....

Other than that you could use a subquery comparison but they are extremly slow.

Perfectly legitimate.

Here is another example

SELECT CASE WHEN CONVERT(CHAR,GETDATE(),101) = '11/06/2002' OR DATEPART(dw,GETDATE()) = 3 THEN 'YES' ELSE 'NOPE' END

Even with Auto Create statistics on you have to use that column for multiple query runs. If this is the first time you used that column or is infrequently used...

Then only yhing with that is you should have failed even after the move. As well, the I am pretty sure that is the article I read awhile back where...

This will return the size of the Trans Log

select cast((size / 128.00) as decimal(10,2)) as tl_size from dbname.dbo.sysfiles where status & 66 = 66

Works with SQL 7 and 2K.

I do believe thou it has to be within the same domain (you will have to make sure the account peforming the backup has proper rights to the share) or...

Try this

SELECT CONVERT(char,DATEADD(mi, mindatafld, '1/1/1970'),108)

unless goes over 12 hours.

Also you might need to do something like this

SELECT CAST(mindatafld / 60 as varchar(5)) + ':' + CAST(mindatafld % 60 as varchar(5))...