Lynn Pettis (10/27/2016)

---

Gary Varga (10/27/2016)

---

I have found that telecommuting is never the problem. The individual, the company, the management and the infrastructure can all be problems. The right person with...

Please note that this is a 4 year old topic, and the issue of IT employees wasting time at work has since been determined to be no longer an issue.

🙂

You'll want to clear out the page buffer cache before each test.

DBCC...

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