It's an interesting look from a developer point of view. Compared to the power and speed of the relational engine, I think space savings are a minimal thing to worry...

http://www.sqlservercentral.com/scripts/Miscellaneous/31793/

If you have specific issues, send them here.

There can be a cost to pulling all that data back together from multiple processors, so the optimizer tries to make an efficient...

Do you mean it displays that way when you view it in SSMS?

The date data is stored always the same way. It's an offset from a base time value,...

a local temp table is available only to the connection that creates it (that SPID).

The global temp table is for all connections.

I'd agree with Barry. My order of fixes is:

SQL

XML

plain code

VB.NET

C#

I think Mr. Reed and I might drive each other crazy, but it would probably never be boring. Actually with Mr. Ranger and his SQL Ranger credentials, I think I'd...

Do all procedures get marker or only those from the dependency tree in SQL Server get marked? I assume this is at the end of each index that is rebuilt?

The service account needs permissions to create the database, not your log in account.

you'll have to ask Red Gate, but Eugene isn't too far away. Might be a nice trip. Spent some time there in 98 and enjoyed it.

you can't drop them all at once. You can loop across the result set (while or cursor) and issue a DROP USER for each one.

The same thing occurs for the...

I don't believe so.

You have 6 filegroups, not 1. So the way it works is that your files in that filegroup take the data for the tables stored there. If they run out...

you must have an object on that particular filegroup that is growing. As mentioned, a table doesn't grow across filegroups.

Interesting you mention cooking. 37 signals talks about inspirations from chef's and recently Andy Warren started cooking a bit and said it gave him an interesting perspective. Perhaps that should...