Nice article, but I would have mentioned somewhere the COST of using the ORDER BY clause, perhaps demonstrating how SQL Server won't return any rows at all until the worktables...

A job is executing on the Server.  I want to find out what statement is executing, knowing the spd for the job.

DBCC INPUTBUFFER(<spid&gt will...

Eddie:

Thank you.  I will create clustered indices on the tables in the new filegroup.

Thanks!

Allen

Randy:

Thanks for the suggestion and it works fine; for a few tables.  I am trying to clean up and need to move > 50 tables from one filegroup to another. ...

Some of these tables are merely "dumps" to be moved out, via DTS Packages, to flat files.  These final tables are never used in the true sense of an RDMS,...

Eddie:

Thanks for the quick response.  Several of the tables do not have a clustered index, only the heap (indid = 0) is on dbo.sysindexes.  For these, what's the most efficent...

Sounds like that ought to work.  I will give that a shot.

Thanks, Jim!

Sincerely,

Allen

The compatibility level is reported in Enterprise Manager as "Database compatibility level 80."  What happened was, back in January, the previous DBA did not install SQL Server 2000 over top...

Sorry for the panic and the too quick posting looking for help.  I did a little digging and I saved each of the packages as structered files and then I...

No bit columns present in the table.  Indices are all non-compound, built on basic datatype columns; i.e. INT, CHAR(1) and a couple of VARCHARs.

Anyone had experience contacting PSS and requesting...

Here is the last line that caused that error (I had to remove specific names, but I assure you I can take the code and paste it into an isql...

Chris:

What are you going to be looping on?  Do you have tables that mimic the sys tables that contain table defs, owners, constraints, etc.?  If you loop on the sys...

Lars:

Why not use the built-in SPs to do this?  We do this sort of thing all the time, but always use the system SPs.

 

DECLARE @vchSQLString VARCHAR(1000)

DECLARE @vchDBName SYSNAME

DECLARE @vchOption VARCHAR(100)

DECLARE...