I have recently learned that our organization is getting an IBM Netezza data warehousing appliance for use as a replacement for one of our large SQL Server reporting servers. Executive...

scott.fountain (11/25/2013)

---

Applying indentation so scripts are readable

Nothing spells a good day at work like reviewing a query containing multiple nested table expressions; all the while, no indentations - everything is...

Yes, I'm when searching a sqlserver topic and want to whittle down the result to only the good stuff,...

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