Here is a simple example of what I was attempting to explain prior:

;WITH

L0 AS (SELECT 1 AS c UNION ALL SELECT 1),

L1 AS (SELECT 1 AS c FROM L0 as...

One way would be to use a tally table. Create a (cte, inline view, table variable, or temp table) with the columns for your report, adding a row number...

We've had all kinds of trouble with text delimiters when importing to SQL2005. From our past experience if the text delimiter is in the column it just needs to...

I've used those numbers as a starting point, but you really need to identify where that seldom used index is actually being used. It could be a very...

You might want to check page life expectancy. We had a server with many of the PAGEIOLATCH_SH waits along with page life expectancy that would live at single and...

sys.dm_db_index_usage_stats does report on heaps, so it would include tables without indexes (index_id=0). But as mstjean mentions, the stats are only kept since the last server startup.

jg

Here is a stored proc I have used to collect space data on multiple db's. it might provide some ideas for you?

I collect total allocated and total used(reserved). ...

Madison, WI

Glad to provide the turkeys for the Lion's Thanksgiving day feasts...

jg

lol, I've got a database that has a few of those runaway DTA indexes (all columns included) - almost like having multiple clustered indexes <grin>

btw, you can...

In SQL Server we created an alert based on the Proccessed Blocked counter that sends an email and kicks off a job that collects the blocking info and populates a...

Can you get the format changed on that input file? That would be the easiest.

I don't believe bcp handles text delimiters, and from that example it appears to have...

George is correct...that file is going to give you trouble. It appears to be comma field delimited with text delimiters of ¬

I would recommend using ¬ as a field...

I found very little overlap between this book and the Microsoft specific one. The Microsoft specific one assumes you already understand dimensional design - it is focused on implementation...

The SQL Agent account is domain admin. I believe it is OK because every once in a while the job completes successfully. The output from dtexec on at...

no. it is directly passed on the command line.

The plot just changed - I was able to get the OS (dtexec) to fail - it ran through more child packages...