Beyond Books Online, I'm not aware of any offhand. Google may be able to find tou some.

...

Not quite what I meant. No one's going to hire me to fix...

Which? That there's too much to learn and not enough weekends? That I don't...

Ok, some answers.

SP3 CU1 is a rollup of all the hotfixes that are in SP2 CU 10 and CU 11. They didn't make it into the service pack because they...

If you create the temp table in dynamic SQL, the temp table will go out of scope and be dropped as soon as the dynamic SQL ends. There's no way...

Fraggle (12/16/2008)

---

Now, my questions:

1) why is it the trace caused the timeout issues on both the 32 and 64 bit servers. I know that a profiler trace can cause...

I don't pay...

SELECT SUM(SomeColumn) FROM (

SELECT SomeColumn FROM TableA

UNION ALL

SELECT SomeColumn FROM TableB

UNION ALL

SELECT SomeColumn FROM TableC) sub

Don't do that. Logs are not optional components of the DB and that's a really fast way to...

These days around here that mostly seems to be BI and ScarePoint. Did I mention I'm...

I'm a consultant these days, so I have to know whatever the client wants.

Right now I'm trying to get by BI skills up to a level where I can...

May I suggest you start by reading the section on clusters and clustering in SQL 2008's Books Online?

extremenovice (12/16/2008)

---

OK i understand you, but can you answer this for me please. If when you do a restore like in my situation are the mdf & ldf files overwritten...

extremenovice (12/16/2008)

---

The last backup of the server was last night so if the mdf & ldf files were backed up for that db, then i would want to use those....

Well, if...