Forget about Zombies and Killer Clowns, it's far more likely your database server will be subjected to attacks from IoT enabled refrigerators and toilets.

Eric M Russell (10/4/2016)

---

Gary Varga (10/4/2016)

---

So now everyone and their grandma is going to ask us to secure their IoT lightbulb because it is going to be "their" responsibility. Legally,...

You plenty of reasons to be concerned at this point with this...

It seems to me that the columns [odid] needs to be indexed; otherwise it's going to do a table scan for each batch....

The buffer cache contains data and index pages. For example, logical reads are from buffer cache while physical reads are from disk.

The procedure cache contains query execution plans.

All indexes suggested by DTA are useful within the context of sample query that was supplied to DTA. The problem is that often times these index suggestions are for niche...

S_Kumar_S (10/27/2016)

---

Thanks for reply Eric but I actually wanted to know what are the tasks which can be performed by sysadmin only

like only a sysadmin can create a linked server....

Zomies?! Orcs?! Haven't you guys got better things to do with your time than sit in the server room playing Dungeons & Dragons?

By default, a user is in the PUBLIC role and cannot do anything. You then should grant them permissions piecemeal. There are probably 1,000 things a member of SYSADMIN can...

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