You could make a view with all 4 queries "union all"-ed together and add a derived column for the database name, that way you can just do your query and...

Nadrek (5/6/2010)

---

This is basically a difference in terminology, and Microsoft's BOL entry is badly written.

So, we have a table, with pages, and a clustered index:

Page 1 contains a-b

Page 2 contains...

The part of me ready for trick questions missed the part about NCL having CL pointers in the IX pages. I thought "well, only the leaf level pages have...

That did it. I was assuming migration meant simply moving. As it turns out, I converted to a SSIS package. I did export/import and that took care...

Steve Jones - Editor (9/28/2008)

---

I'm not sure how well this would work. It's one thing when someone intentionally writes for a level, which is what MSDN does, but another when...

RockStar (6/10/2008)

---

Wondering if anyone has seen a significant degradation in query performance after updating stats in SQL 2005?

I recently did a reorg of indexes and update to stats...

Hey Matt,

Have you considered updating all columns at once?

[font="System"]UPDATE Vids

SET CategoryID = COALESCE(@CategoryID, CategoryID),

VidFileName = COALESCE(@VidFileName, VidFileName),

...

WHERE VidID = @VidID[/font]

Thanks,

Eric

I give...

I would like to ask Steve who made the x64 instruction set that everything is moving to in the...

Good points about the job failure logic. In general, if we ever have a job that fails and then sends a failure notification, we have that job step exit...

Hey Dave,

Grant has a good point about not guaranteeing referential integrity. The extra columns you have are purely auditing columns. If you removed them, you wouldn't know who...

Interesting solutions. For large environments, enterprise monitoring software is very useful. Our environment has 200+ SQL instances and we use NetIQ. We finished up a project that...

Hey Jeff,

Would it be possible to post the specific error as well? If there is no error, is there anything else that you find odd or notable?

Thanks,

Eric

Hey Molly,

I would use the convert function as you suggested, but you would not want to use INT. You will want to use the decimal data type. Depending...

You are very close.

[font="System"]declare @current_db sysname;

set @current_db = db_name();

select 'The current DB is ' + @current_db;[/font]

Thanks,

Eric