Many of those are braindumps. Actual questions taken from the exams in violation of the NDAs that anyone...

vbprogrammer1986 (1/28/2010)

---

If U want to work with temp table which must be placed in memory for fast access.u can use table variable instead of temp table overhead.

table variable always take...

SQL manages the buffer pool, you cannot control what's in there or on disk.

SQL will try, as far as possible, to keep temp tables and table variables in memory because...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic855810-1550-1.aspx

You've got nested transactions. With nested transactions, all a commit does is decrement @@trancount until it reaches 0, then the transaction is actually committed. A rollback however will always roll...

You're updating 50 000 rows in a single transaction? That's gonna cause the log to grow. The log will have to be big enough to store the before and after...

http://dotnetrocks.com/

http://runasradio.com/

Nothing can be denied to a sysadmin.

You need encryption here, but not using SQL Server's certificate-based encryption. The sysadmins will have full rights to the certificates and hence will be...

No, if you group by the course date, you're asking for the minimum course name PER course date.

Your requirements are not clear.

Do you want the minimum course name per date?...

It's not since the last SQL start, it's since the last database start. If the DB is closed, taken offline, detached or restored, those stats are also cleared. Watch out...

Thanks. (It's my blog in case you didn't realise)

I missed that the index was on...

Apollo74x (1/28/2010)

---

One of the fields showed a huge amount of user seeks on a column that already has an index on it. The only difference, is the missing index...

ALTER VIEW <ViewName>

AS

<Entire select statement here>

Lynn Pettis (1/28/2010)

---

GilaMonster (1/28/2010)

---

Same as Seattle? That puts you 10 hours behind me. So if you meet at 7pm,...