RonKyle (3/27/2015)

---

btw. natural keys will make the index wider than an integer. I would prefer to see a database properly normalised and applications properly thought through, but then again the...

Installing SQL Server in a production environment is one area that few of us will ever master. Even in a large organization, there just enough enough opportunity for an in-house...

The debate about Integer versus GUID really hinges around whether we're talking about the clustering key. For obvious reasons, whether your table is clustered on a sequential versus random key...

Please provide a description of what this query is attempting to accomplish. For example, if all you're trying to do is return the most recent row for each BL_ID, then...

SharePoint has a Wiki feature, if you want to create something that visible within your team or organization.

If you've already granted access to other accounts, and the issue is that you can't remember your own the SA login password, then you can can login under a different...

The worst comments are where someone has /* commented */ out blocks of code, sometimes pages and pages, with no explanation for when or why.

RonKyle (3/24/2015)

---

Why did you qualify this? Wouldn't this always be true? That doesn't mean that...

GUID versus Integer, in terms of how efficiently the CPU can process them, is practically irrelevent in the databse realm. The vast majority of database are page crunchers, not number...

Chris Harshman (3/24/2015)

---

Eric M Russell (3/20/2015)

Yes, I do that sometimes, but the catch is that it has to be a 'persisted' computed column. Adding these persisted columns to an existing...

Chris Harshman (3/24/2015)

---

Iwas Bornready (3/24/2015)

---

What I often see is this. A programmer goes in to fix a problem, finds the source of the problem and fixes it. Done. But wait,...

Jeff Moden (3/22/2015)

---

Eric M Russell (3/20/2015)

---

Chris Harshman (3/20/2015)

---

Eric M Russell (3/20/2015)

---

One thing that SQL Server could use is function based indexes, so we can index on something like CAST(SALESDATE AS...

Rename the table and see how many users complain. 🙂

Or use an extended event trace. Either way, it's not something you want to be counting 24x7. I assume you just...

Toby Harman (3/23/2015)

---

...

One area which no-one has mentioned (that I saw) was that using GUIDs as the clustered key can avoid hot-spots when adding a lot of data. The random...

below86 (3/23/2015)

---

Eric M Russell (3/23/2015)

---

below86 (3/23/2015)

---

I loved that show.

I ran into this same issue...