DENSE_RANK(), without a PARTITION BY clause will get you the grouping you're looking for, but how to pull off the order of the ranking in your limited sample will require...

The FILEPROPERTY function provides the count of pages used in a file, which can be compared to the total number of pages in the file, available in sys.database_files. All...

Also note that if you are using Enterprise Edition in a non-virtual instance, you must license the number of CPUs in the server available to the operating system, whether you...

The high CXPACKET waits, combined with the PAGEIOLATCH_SH and PAGEIOLATCH_EX waits, likely indicate table scanning. Including the PAGEIOLATCH waits shows that you're scanning from disk and incurring additional cost...

I agree with a lot of what's been said in this thread, especially that networking is still the best way to go. I heard about my current position at...

It's a configuration setting, which can viewed and changed using sp_configure.

See "max text repl size option" in BOL.

-- View your current settings

exec sp_configure

-- Change the max text/image size for replication

exec...

Another way to test the SAN: SQLIOSim (http://support.microsoft.com/default.aspx?scid=kb;en-us;231619)

The first step is to ensure your test server can fully saturate the SAN during the test - meaning you've...

Currently, the Charter Member designation is for passing the exam within 90 days of official release.

Check BOL for sys.dm_db_task_space_usage. It displays tempdb usage by spid (session_id).

Once you get the session_id of some of the worst offenders, you can join up to sys.dm_exec_sessions, sys.dm_exec_requests, and/or...

Why bother with CR+LF at all? This isn't VB. Just leave them in the string an be done with it. This works with many targets:

SELECT @body =...

http://www.microsoft.com/sql/howtobuy/licensing.mspx

If a physical processor is available to the OS on which SQL Server is installed, then you must license that processor, regardless of any SQL Server service-specific affinity...

You're mixing the two styles of CASE:

CASE column|@val|const

WHEN column|@val|const THEN column|@val|const

WHEN column|@val|const THEN column|@val|const

ELSE column|@val|const

...

Additional ammo for those still deciding if they can/will go is the early-bird discount for the following year: Once you attend a summit, you can register for the next...

The SQL 2005 service pack installs are cluster-aware, just like the base installations. Run the SP on the active node, and it will detect everything. If you supply...

I think the only thing you can do is to add [font="Courier New"]AND Status <> 1[/font] to the WHERE clause, so you don't re-update rows that already have the value...