I Googled this a few years back and came up with an easy shotgun technique.

Download the script for [sp_force_shrink_log] and install it in [master]

Then use the following TQL wrapper for...

Usually, the power users that have MS Access link to SS tables do so for reporting reasons only.  Unfortunately, they don't always set their app to use snapshots because read-write access...

Nah, nothing that you haven't already heard.  The information that I gave above is a general statement from when I paid attention to such things as RAID5 read/write speed comparisons. ...

That sounds highly suspicious.  It's always fun to play Sherlock Holms.  I wish it paid good money.

BTW, you followed a really nice trail.

...Mel

I have had skilled IT managers tell me that a properly configured RAID will give you the needed efficiency since multiple disks are used.  My argument is from a hardware...

This sounds very similar to issues observed on one of our production servers.  After several weeks of logically sequenced troubleshooting to no avail with red faced managers, Intuition screamed at...

I am concerned about the Access connections.  I assume you mean MS Access connecting via ODBC linked tables.  If this is the case, much of the ad-hoc indexing may be...

There are no settings for SQL Server to blacklist or whitelist applications.  This field in sysprocesses is actually free text generated by the calling program through DBLib or ODBC connections. ...

Since your request begins with "Got it" I fear this post may be an orphaned thread, so I appologize ahead of time if I make a statement that has already...

The big difference between @table and #table is not just indexing. 

@tables cannot be referenced in embedded SQL scripts used by sp_executesql.

@tables cannot be rolled back.

Other than these issues, performance...

Can't you just sort the object listing by creation date in SQL EM?  All of the user created procs will bubble to one end of the list because they were...

Actually, from Dave McKinney's example from above, I have used it many times...

IF object_id('tempdb..#tmp') IS NOT NULL

drop table #tmp

This works just fine in all cases, even when there are multiple...

Hah!  This forum is wonderful!  I had hoped to meet others of my ilk.  I love SS trivia.  I guess I'll have to create a profile now.

You are right.  The...

Thanks, Old Hand, you are right as usual.  The true definition of memory tables (if my old memory serves me correctly) are tables that are preloaded when SQL...

I have seen the main difference in temp tables when using DTS Packages.  Since DTS tends to split processes into multiple threads, table scope and persistence are both...