The key is the ability to recover to a specific point in time (mentioned above), and not just they time they took the 'SAN backup' (only relevant if you are...

This info rocks! Awesome!

The link I provided explains type 8 and 11 as follows:

Type 8: password mismatch (you typed the wrong password)

Type 11: Valid login but server access failure

- This one is...

If you're getting error 18456, then you're successfully connecting to the server, but the login is being denied.

To find details, view the SQL Server logs (I'm guessing SQL Server is...

Clustered indexes and Primary Keys are two independant entities. It just turns out that most people build their primary keys also as clustered indexes, even when their queries would...

I use the following script to pull a list of tables and space used. Add a HAVING clause to only return those tables with > 0 rows, and it...

SET NOEXEC ON

That will compile but not execute.

1. SET NOEXEC ON

2. Execute the code

3. SET NOEXEC OFF

...and react to any errors.

-Eddie

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