Bradley B (5/16/2011)

---

Peter Trast (5/16/2011)

---

Great Question and a lucky guess so I read up on it. The strangest statement in the msdn article I read (http://msdn.microsoft.com/en-us/library/cc280464.aspx) was:

" If...

No, just a horrible song... some 70's music is best forgotten. Hey, I liked Karen...

Paul Randal (5/13/2011)

---

Steve - I got this wrong because your wording is broken. Extents can NOT be owned by multiple objects. When an extent is a mixed extent, it is...

Great Question and a lucky guess so I read up on it. The strangest statement in the msdn article I read (http://msdn.microsoft.com/en-us/library/cc280464.aspx) was:

" If the space gained by...

Tom.Thomson (5/11/2011)

---

WayneS (5/11/2011)

---

Tom.Thomson (5/11/2011)

---

Nice question.

One niggle: asking people to assume that a schema is valid when a table doesn't have a primary key may encourage a very bad habit if...

crookj (5/12/2011)

---

Peter Trast (5/12/2011)

---

Brandie Tarvin (5/12/2011)

---

SQLRNNR (5/12/2011)

---

crookj (5/12/2011)

---

WOTD - Flashback (As in the...

Brandie Tarvin (5/12/2011)

---

SQLRNNR (5/12/2011)

---

crookj (5/12/2011)

---

WOTD - Flashback (As in the earlier posts about...

sanderstad (5/12/2011)

---

I really like this feature which was introduced in SQL 2008.

For my work I created a little Excel sheet I like to use to calculate these MIN and MAX...

Thanks for an easy one, my brain is tired this morning.

Great question!

This is why I encourage so many people to take a class on SQL Server. As an instructor, I was always explaining feature sets to experienced veterans. I take my...

Almost got it wrong until I remembered that IDENTITY does not have to be UNIQUE 🙂 I just WANT it to be... made me read carefully. That's why I think...

The job I had before my current one was a training position. I had zero technical training experience, but alot of hands on work and they thought my personality would...

I have never seen or heard of a best practice for separating system and user objects, although your explanation sounds good on the first read. Is this your own best...

I noticed when I first opened the tool that the INS1 page splits ratio to batch requests was running close to 20%, pushing the limits for my preferences, although it...

sherifffruitfly (5/9/2011)

---

Koen: Thanks for the pointers to relevant certs.

I think one reason I haven't yet jumped into the cert game is that it appeared to me from the outside like...