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

Just script your backup with T-SQL and set up an agent job on each server to execute that script. The first step in the script can check if the...

We use the PolyServe Matrix Server Database Utility for SQL Server to run 2 distinct 5+1 'clusters'.

http://www.polyserve.com/sql_server_consolidation.php

They push it as useful for consolidation, we went with it to get rid...

The virtual SQL Server has a different IP address from the cluster itself. Network names, such as SQLET01, are resolved into IP addresses through DNS. A single network...

Using windowed aggregates (using the OVER clause) avoid the messy join-back stuff:

SELECT n.caption, AVG(b.availability) AS Availability, AVG(AVG(b.availability)) OVER () AS 'Average of Availability'

FROM nodes n INNER JOIN

...

DevTeamLead (10/5/2007)

---

Hoping this trickles back to the lair of the Architect...

One of the most disparaging things I run across in SQL code is the use of;

SELECT *

[...]

-Microsoft promises to deprecate...

There's a lot of info in that book that is related to tuning hardware and windows server monitoring, which is valid info regardless of the version of SQL Server. ...