Add the CASE to the query before the PIVOT (the one that defines the data that is pivoted):

CASE WHEN @var = 'TBT' THEN Amt1

...

(Note: depending on the SAN vendor and implementation, "SAN Volume" may have different meanings. I am under the assumption that "SAN Volume" means "Mounted Windows disk partition/drive")

The new named...

Looks like you're getting pounded by table scans.

Do all of those foreign keys have matching nonclustered indexes? The table scripts you included have the foreign keys listed,...

Love it when folks incorrectly post about stuff that may be deprecated. After all that info is so hard to come by:

http://tinyurl.com/kr7tvb (lmgtfy link) 🙂

Two key points:

- use the .nodes() method to split the xml doc into a rowset of BATCH/ORDERREQUEST/DOCUMENT/FIELD nodes

- use ../../ to crawl up the tree from those nodes...

Check the MSDN blog entry "Understanding "login failed" (Error 18456) error messages in SQL Server 2005"

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

You'll need to look in the SQL Server error logs for the full detail of...

Yes, you use the virtual SQL servername\instance (and port if you specified it) to connect to the SQL instance.

When the instance fails over to a different node in the cluster,...

Take a look at sys.dm_db_partition_stats. It details storage consumed by each partition in the database (unpartitioned tables and indexes exist as a single partition each), with index space detailed...

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 got the...