The thing I love about T-SQL is that it actually doesn't change that frequently, and ANSI SQL changes even less often. Once you get past the two year mark, it's...

As a database developer, if 2 + 2 -1 = 3 and the result is returned from the databse faster than the web browser can render the HTML, then my...

Over the past few months, I've been prepping for SQL Server 2012 Administration exam 70-462. I have experience performing admin tasks in the development and QA environment, and even a...

Steve Jones - SSC Editor (11/13/2013)

---

I have seen quite a few DVD/BluRay players in the last decade like that. I've returned some and gotten others, quality has not improved. At...

LutzM (11/12/2013)

---

@eric:

From my point of view, every approach will lead to the same execution plan including the table/index scan (including the MERGE approach).

A rather dirty approach would be a separate...

Dale Turley (11/13/2013)

---

I strongly disagree with the idea of just pushing something out to fit a time frame, and this kind of mentality is the reason for IT having such...

Jonathan Marshall (11/12/2013)

---

The queries are updating lookup tables that do not have a value by using a subquery to the lookup table.

I like that idea of using a computed...

Jonathan Marshall (11/12/2013)

---

The queries are updating lookup tables that do not have a value by using a subquery to the lookup table.

I like that idea of using a computed...

Tom Bakerman (11/12/2013)

---

Jeff Moden (11/12/2013)

---

Oddly enough, I believe that's part of the problem with delivered software, today. There's nothing like...

I'll typically place a few unit test examples in the comment block of each stored procedure I write. Sometimes I'll use SQLProfiler to cature sample procedure calls while the QA...

If linked server doesnt work, then try pass through batch via EXEC() AT <SERVER>.

A large scale website is like an interstate highway, especially when it's being construted at tax payer expense. Cool features are nice to have (just like rest stops and trees...

Ask 100 people how they would envision a "perfect" solution, and you'll get 100 different answers, only 10 of which are even remotely feasible. Implementing and deploying IT projects is...

tdietrich (11/4/2013)

---

At our company, we have thousands of SQL instances (with more databases than I can think about without some Advil). We have some core/centralized DBA groups, but...

I believe that the client or customer should own their data and the basic means to access the data. They should have a sysadmin account. If your application has some...