jim.drewe (12/4/2013)

---

The problem for most (if not all) bigger shops is offshore outsourcing. I had talks with my management (CTO level) concerning the risk of having non-employees, non-citizen offshore residents...

Gary Varga (12/2/2013)

---

Lynn Pettis (12/2/2013)

---

When I first started working with SQL Server I was also heavily involved with the hardware and OS (NT 4.0). I was the backup for...

In a large organization, database administrator (DBO) should be a different role from system administrator (SYSADMIN). There are plenty of roles where a DBA basically just needs to be the...

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