Carlo Romagnano (6/23/2011)

---

This is true...

Steven Willis (6/22/2011)

---

Now a second question...I personally avoid using UNIQUEIDENTIFIER cols as part of a primary key. But sometimes I have no choice when I've inherited a schema from someone...

Steven Willis (6/22/2011)

---

Here's two sample queries that will run against the default DotNetNuke schema. Note the only difference is in the second query in which I've added to the where...

amenjonathan (6/22/2011)

---

I have heard from more than one person that all columns in the clustered index also show up in each non-clustered index on that same table, which is why...

I'd add another criterion I've found lacking from the search/interview process: Don't hire anyone who hasn't broken anything. Ever.

Seriously. If they haven't broken something, then they've been holding themselves back....

SQLZ (5/31/2011)

---

However, I would still give consideration to including this field in the actual table so that you wouldn't need to perform the calculation when trying to query many thousands...

I always hate it when supposedly intelligent people try to group others together by something as nebulous as a generation. They meticulously compile and analyze statistics to get to a...

Ninja's_RGR'us (5/23/2011)

---

Whenever I feel like adding and hint I ask myself something similar to this :

Am I really smarter than the best MS engineers who had years and trillions...

Very good question.

I think the reason this works is that the NULL in the CREATE TABLE is an attribute of the column (since NULL is actually just a flag...

alen teplitsky (3/9/2011)

---

sknox (3/9/2011)

---

Essentially, TRUN CATE TABLE simply...

Essentially, TRUN CATE TABLE simply invalidates all of...

dave.farmer (3/1/2011)

---

DugyC (3/1/2011)

---

Ack! Got it wrong, slightly, but enough to lose the points! :ermm:

The explanation I found in this article http://sqlserverpedia.com/wiki/Heaps under heading Forwarded Records said... Any non-clustered indexes on...

mtassin (2/28/2011)

---

I got this right but...

SELECT 0%0

gives

Msg 8134, Level 16, State 1, Line 1

Divide by zero error encountered.

So it seems you can use it to divide 0 by 0 and...

I thought this site loved all SQL database engines, but it just isn't in love with them...:-P

Mike Dougherty-384281 (2/11/2011)

---

Hugo Kornelis (2/11/2011)

The reason the resource database was introduced was to make applying service packs easier. Instead of dropping and creating system objects in the master database, the...