They probably asked around and realized that a lot of folks, like me, never used the object search. I played with it a few times back in 2001, then...

I recently lead the movement of the databases for our 10TB application from one datacenter to another, and we used the same process mentioned above:

- Ship backup tapes to...

Replied too quick 😛

Ouch! Sorry to hear it. We've had that happen twice with LiteSpeed x64 edition on SQL 2005 enterprise.

The only solution was to restart the instance. The hung...

First, partitions are open-ended. When using RANGE RIGHT, the first partition holds all data less than the first value listed. In this case, the first partition is for...

Check BOL for the STATS_DATE ( table_id , index_id ) function.

-Eddie

What that often means coming out of the mouths of developers is that they want to use some code-generators and write zero T-SQL.

Data access will be either all...

You have a couple options to take an existing non-partitioned table and convert it to an partitioned table.

Hint: see BOL, Look for: "partitioned tables [SQL Server], modifying" in the index....

Re: not getting 2005 certs waiting for 2008 certs.

From what I've seen on SQL 2008 so far, it's basically SQL 2005 plus more new stuff. (I'm just...

Tools -> Options... -> Click 'Query Results' -> in the right pane, check 'Play the Windows default beep when a query batch completes'

SELECT OBJECT_NAME(object_id) AS TableName, name AS ColumnName

FROM sys.columns

WHERE object_id = OBJECT_ID('YourTableNameGoesHere') AND is_identity = 1

PINTABLE is ignored in SQL Server...

Central Indiana (I live and work in Indy) is actually pretty fertile ground for SQL Server DBAs. Many places don't post ads on Monster because (and I've been through...

Tracing should be used to identify specific reasons for specific problems. It comes later in the tuning process. You first need to answer the questions "Is there a...

SELECT login_name FROM sys.dm_exec_sessions WHERE session_id = @@spid

Check BOL for both sys.dm_exec_sessions and sys.dm_exec_requests to see what other useful info is available. (host_name, etc.)

-Eddie