Steve Jones - SSC Editor (3/27/2015)

---

Eric JOATMON (3/27/2015)

---

Steve,

You mention "extra columns in a result set" as being a downside to deploying database changes prior to application code changes. That...

You can use the following to identify what procedures or queries are using "SELECT *".

SELECT DISTINCT objtype, db_name(dbid)dbname

, object_name(objectid,dbid)objname, usecounts, [text]

FROM sys.dm_exec_cached_plans P

CROSS APPLY sys.dm_exec_sql_text (plan_handle)

WHERE [text]...

When clustering on a composite natural key, perhaps something like OrderDate + StoreID + SKU, then place the most sequential column in the left most position. Not only does this...

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...