Date range queries should always be in the form of:

Where MyDate >= StartofRange and MyDate < EndOfRange

Using a function call against a datetime column uses more resources because it has...

Sometimes you just have to do the work. You can write a script against information_schema.columns to generate the code you need.

The following is the general logic you need to...

No, but it should be easy enough for you to...

You can use the sp_rename stored procedure.

You can use the script on the link below to shrink your database data file in small increments. It will take a while to shrink it, but it will...

The software version is recorded in the database backup file.

You can display it with this command. Look for the following columns:

SoftwareVersionMajor

SoftwareVersionMinor

SoftwareVersionBuild

restore HeaderOnly

from disk = 'X:\MSSQL\backup\msdb_db_200804061122.BAK'

The issue of scaling out was solved years ago by DEC with VMS clusters and the RDB database (RDB is now owned by Oracle and VMS is owned by HP)....

This is a much simpler way to get everyone out of the database:

-- Get rid of all DB users

use master

alter database MyDatabase set offline with rollback immediate

-- Bring DB...

You can use this utility.

DTSBackup 2000

http://www.sqldts.com/242.aspx

Not with the information you provided.

In practice, it is quite rare for even the most incompetent doctor, lawyer, or engineer to lose their license, unless they commit a crime. Their professional standards serve chiefly...

Use an actual join condition in your join:

select

b.emp_nbr,

a.begin_rng,

a.end_rng

from

range a

join

emp b

on b.emp_nbr between a.begin_rng and a.end_rng

How many would you estimate meet both conditions?

You heard it first here: Intel's next generation processor will have SQL Server 2008 on the chip.

I have also heard rumors of a port of SQL Server to the Sony...

How many rows in your table would you estimate meet the following condition?

where ID = 1 and ID != 1