What's wrong with msforeachdb?

I'd keep digging iiwy 😉

As I said, the inner CTE is fine. It's just the forcast that are wrong.

Play with it and use what makes sense.

Yes it works with temp table.

spaceused returns 2 datasets for the DB so you can't use that trick on that sp.

I personally use the backup history for this (estimates doesn't...

IIRC the correct drop sequence is FK, then index, defaults, checks, schemabound objects and then the column.

If other fks use that column as PK in the relation those will need...

Nope.

Never seen this other than something manually coded in the application.

Something overly complicated that shows how to use both foreach db & tables...

SET STATISTICS IO, TIME OFF

SET NOCOUNT ON

SET IMPLICIT_TRANSACTIONS ON

GO

USE [master]

GO

IF OBJECT_ID('dbo.spaceused', 'U') IS NULL

BEGIN

CREATE TABLE dbo.spaceused (

DbName sysname...

Never seen this in any standard installs.

The only remotely possible explaination I can find is this => http://office.microsoft.com/en-us/sharepoint-foundation-help/manage-lists-and-libraries-with-many-items-HA010377496.aspx#_Toc264017709

My way's funnier :-D.

Perry Whittle (10/24/2011)

---

Rod at work (10/24/2011)

---

OK, simple question here, but I need to ask it. I was under what must be a mistaken thought that traces could run only...

Stefan Krzywicki (10/24/2011)

---

There is a way to get rid of the file, but it is a lot of work and I don't know if it is worth it. Create a...

When we tune we only care about the statements. Unless the index creation will always be part of the process (like for a temp table).

Any reason you don't have an identity column in the Users' table and use that instead in that table?

Ok, I just got to ask.

Why are you doing this 3 times in a row?

SELECT @ordernumber = ordernumber

Either we are missing part of the code or the logic or...

Is lock pages in memory on? That will use everything available right on startup (up to the limit you set for the server).