Too many honestly...

Ok, found out about the garbage collector taking some time to complete the deletes, etc

Still looking for the "link" between the record and the physical file?

Im struggling with the same thing right now... any answers? Delete from table, does not delete physical file. Update of record creates an additional file........ and no clean up (as...

What I used to do, once I had worked out what I was pretty sure was unused, was renamed the object with an "_" in front of the name.

System

Centre

Operations

Manager

from Microsoft is also pretty good. The SQL management packs were quite good. The benefit is that its Microsoft, the management packs are (were) written by the SQL team and...

What about the TABLESAMPLE clause?

EG.

SELECT *

FROM tableX

TABLESAMPLE (10 percent)

More info here

Could depend on the view statement as well... You its small, but is the SQL complex??

Gail, as a matter of interest, will DBCC inputbuffer on the SPID work now to show...

Sounds like its doing a rollback...

Perhaps next time, find out what its doing and why its taking so long before you kill it off.

Well, technically, people are rewarded for there skills and merit. Just not the ones you are thinking of 😀 I have always been a firm believer in "its not what...

As above, I think its more about the queries that fetch data from these tables will work. Your solution might (20 filegroups) might be appropriate, but depends on queries accessing...

Dont do presentations :hehe:

However something like camomile tea with honey should help the throat... or just the honey 😉

Congrats, I would not have survived a 4.5 hour presentation....

If you plan on use Dynamic SQL, how are the new columns created? If the users are able to create them and name them however they want, use the SELECT...

In this case it might not be such a big deal, but surely a counter like Page Life Expectancy is a better way of monitoring Memory pressure??

BCP is an external command, xp_cmdshell is pretty much the only way to execute it. I am not sure if you could schedule a SQL job that will a CMD...