Yeah, those are SQL Server 2000 temp table habits. There were some improvements in SQL 2000 SP4, but SQL2005 and SQL2008 introduced a variety of tempdb improvements:

- Deferred compilation...

In Windows clustering, any given instance (and the databases in it) are only live on one of the servers in the cluster at a time. No built-in load-balancing is possible.

Clustering...

Try this next time:

COUNT(*) OVER ()

The first order of business would be to add more space to tempdb, unless you truly know that this is a one-time or rare event. Given that you can't readily...

Hooray for attribute-centric XML! Makes stuff way easier.

The main trick here is to turn all of the <TargetModel> nodes into a table so we can go after each of the...

Are you attempting to connect using your Windows domain credentials (user Domain\UserName)? If so, you don't specify user name or password. You just have to set it to use Windows...

The code below works (substitute table column name for @x in the code below), but only if each element contains one or less of each child element. As in, there...

I've never seen anything like that. But it was nice of the company to show you that working there would suck before you waste time on an interview.

Weird that it's deadlocking on a page. Since you have the page address (5:1:1662692), it would be nice to see what the actual deadlocked resource is.

Print the page header with...

Looks like just a path issue. Is the account executing the script able to run sqlcmd from the context of the folder that holds the script file? (log on as...

Think of mirroring as really fast log shipping. The transaction log replay includes the target pages of the modifications. The buffer cache is not part of the transaction log.

So, to...

SELECT physical_memory_in_bytes FROM sys.dm_os_sys_info

This is pretty much what the NTILE() windowed function is for - equally dividing a results set into x number of pieces. Unlike throwing calculations at the min and max...

Using a self-join, you can establish what a daily average rate for each entry is. Once you've gotten that, each entry will have a start and an end date.

From...

First thing that comes to mind is Unicode conversion problems. That data must be stored as nvarchar() or nchar(). If any table application, column, temp table column, or variable touched...