You can use the script on this link to get information on all databases on a server at the same time.

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

If you have the time, and think you might want the job, there is no harm in taking the test.

The worst that can happened is that you don’t get a...

I use different SQL Server service accounts and passwords for each SQL Server instance. We have about 200 SQL Server instances; so it is out of the question to...

The instance name is stored in master, but changing that is well documented.

You will also need to update the originating_server in sysjobs (does not apply to SQL 2005)

There will also...

I don't really see the point in what you are doing, because you can just break out the date and time parts when you need to.

You can break them out...

The easiest way is to left join each row to the prior row for the same customer, and do a difference between the dates from the current and prior row...

What if you need to do Banker's Rounding to the nearest 5 cents? :Whistling:

I would use it to store binary data.

select

a.Date,

LastSundayOfMonth =

dateadd(dd,(datediff(dd,-53684,dateadd(mm,datediff(mm,-1,a.Date),-1))/7)*7,-53684)

from

(

--Test Data

select Date = convert(datetime,'20080101')union all

select Date = convert(datetime,'20080201')union all

select Date = convert(datetime,'20080301')union all

select Date = convert(datetime,'20080401')union all

select Date = convert(datetime,'20080501')union all

select Date = convert(datetime,'20080601')union all

select Date = convert(datetime,'20080701')union...

The sad truth is that the Excel bugs are intentional "features" that were put in to match the behavior of Lotus 123 where the bug originated.

http://support.microsoft.com/kb/214326

I do not believe that you can restore a SQL Server 2005 database backup to SQL Server 2000.

This might be close to what you want.

Defragment Indexes stored procedure - new version:

http://weblogs.sqlteam.com/tarad/archive/2007/11/27/60415.aspx

I wouldn’t say that the value of certifications has declined in my eyes, simply because I have never given them any weight at all in choosing candidates.

Companies have to to be very selective in the technologies they adopt and anticipate the available labor pool that will be able to support it.

If you decide to adopt a...

The two tables don't have the same structure. Also, you didn't post the DDL for the primary keys.