Use datepart to get the day of year:

SELECT datepart(dy, getdate())

If you wish to use snapshots, but be able to change the data displayed in the report, then use Filters.

Parameters are applied before the data is stored in...

Databases upgraded from SQL Server 2000 to SQL Server 2005 will remain in SQL 2000 compatibility mode (mode 80). To switch the compatibility mode to SQL 2005 (level 90),...

Contradicting an earlier post, PolyServe has nothing to do with load balancing. It's just a different kind of clustering (shared everything vs. shared nothing).

This sort of situation is where the windowed functions get really handy.  In this case, I'm referring to the RANK() function.  Rank calculates a 1..N value for sets of rows...

A good technical interviewer (who's doing more than simply validating you told the truth on your resume) will *always* go over your head, in several directions outside of the job...

try this instead:  ...values (19,'2005/12/05')  (note the single-quotes around the date)

Without quotes, SQL Server sees 2005/12/05 as 2005 ÷ 12 ÷ 5, which rounds to the...

Our application does over 200 million inserts a day, and we use a 15-minute log backup frequency.  Your thoughts - better recoverability and quicker backups vs. taking fewer log backups...

I have heard a number of (non-American) folks who refer to taking an exam as 'writing' the exam.  The OP was merely asking about getting started.

Karthikeyan: you can get started...

Add a HOLDLOCK hint to retain the read locks through the transaction:

BEGIN TRANSACTION

  SELECT ...

     FROM t1 WITH(TABLOCKX, HOLDLOCK)

-Eddie

> I believe the "!=" operator has been deprecated and will fail to work in either 2005 or 2008, whereas ANSI standards generally will work as documented.

> Besides...

Vista is a desktop OS.  SQL 2005 Enterprise Edition performs an installation check to prevent installation on desktops and only install on servers.  While I personally have not tried to...

SELECT

Type, AAA, A, BBB, OTHER, (AAA...

Your first question should have been answered by your restore testing.  You are restore-testing your backups, right?

Restore a snapshot, and start applying logs through an NTBACKUP time. 

The quality of...

Did you try creating an http endpoint?  (a.k.a. 'web service')

CREATE ENDPOINT [name] AS HTTP(PATH = 'virtual directory name',    ....

This is monumentally easier than doing it in SQL 2000, can be...