Conversion of 0 or other numbers directly to datetime is documented in SQL Server Books Online.

select

DT,

...

The performance of SAN depends on so many things that you really need to test it to make sure you have the expected performance. The 9 MB/Sec you mentioned...

Tables and indexes are assigned to filegroups, not files, so the normal assumption will be that the data is spread across all files in the filegroup.

If you run DBCC SHRINKFILE...

Let’s just say that I am jaded by years of seeing this, but my expectation would actually be to get something far worse than what you described:

A database that is...

Is is possible that the server you are having trouble with does not have the Lithuanian collations available?

You said yourself that Windows authentication cannot be used with the login you are trying to use, so I am not sure what you are asking.

Microsoft says that they do support an direct upgrade from 2005 Evaluation Edition to 2005 Enterprise Edition, but recommend uninstalling if you plan to go to Standard, Workgroup,or Developer Edition.

http://www.microsoft.com/sqlserver/2005/en/us/trial-software.aspx

"The...

SQL Server 2000 does not have any built-in ability to do decryption or encryption.

There are some third-pary add on products that might be able to do what you want, or...

Another perspective to remember is that there are other people who may read a thread looking for answers.

I think for the benefit of these people, an answer that they should...

This script gets the file information for every database on a server, and inserts it into temp table that is queried multiple ways to give various levels of analysis of...

This will work for any datetime range.

select

StartDate,

EndDate,

...

One of the causes of corruption is a hardware problem with the disk, and that can cause a problem with any database, even one in read-only mode.

As long as you...

What would you want to see if more than one item for a customer sold for the same max price?

This seems to do the job:

select

JD,

DT = dateadd(dd,(JD%1000)-1,dateadd(yy,JD/1000,0))

from

...

Ronzo (8/27/2009)

---

So, as a follow up, what about a more complex situation:

Clustered default instance of SQL Server with different virtual IP address and network name then the virtual name and...