Ed Wagner (10/26/2016)

---

Eric M Russell (10/26/2016)

---

Where I've worked in the past, SSIS/SSAS/SSRS is typically installed on a separate box or VM, and sometimes each component warrants it's own dedicated instance....

Where I've worked in the past, SSIS/SSAS/SSRS is typically installed on a separate box or VM, and sometimes each component warrants it's own dedicated instance. You for sure don't want...

SQL Server's buffer cache holds pages in their original compressed format.

You can query the space allocated in the page buffer cache for individual objects using the following script.

SELECT TOP 10...

It would probably be best to first approach this issue by confirming that statistics on tables and indexes are up to date and also by simplifying the JOIN and WHERE...

Just like a non-clustered covering index can eliminate reads from the base table, an indexed view can be thought us as a covering index for eliminating multiple joined tables.

Jeff Moden (10/25/2016)

---

Eric M Russell (10/25/2016)

---

Marcia J (10/25/2016)

---

I remember in the late 80's saying that the 2-digit year would be a problem and getting the message from other programmers, "So...

So who or what can change your server configuration settings?

You probably don't want your development environment to have features that are not expected to be deployed in production, unless the feature is being used to facilitate the development process....

If you have a monitoring tool like Redgate or SQLSentry, then go back and check for any extended periods of blocking on the backup process that may have occurred during...

What is the difference between a CHECK CONSTRAINT and error handling?

A CHECK CONSTRAINT will automatically throw an error in response to the insertion of invalid data.

TRY + CATCH...

A .dtsx file contains the source code for the SSIS package (in XML format), while .ispac is a ZIP formatted file containing .dtsx files, .params file, .manifest file, and other...

Marcia J (10/25/2016)

---

I remember in the late 80's saying that the 2-digit year would be a problem and getting the message from other programmers, "So what? I'll be at...

Kazmerelda (10/25/2016)

---

Now they want to offer me RAID5 instead of RAID10 *weep*.

Eric, I think you could be right here I am a belt and braces person and I don't overspec...

A disgruntled DBA is the equivalent of a zombie clown with...

Gary Varga (10/25/2016)

---

Geoff.Sturdy (10/25/2016)

---

Gary - the two digit year was born out if the need to conserve memory in early systems - back in the late 70s /early 80s...