Gary Varga (10/31/2016)

---

I could...

In most shops, trying to argue with application developers on the issue of proper database modeling and SQL coding is a lost cause. You'll just end up earning a reputation...

OLAP tools like SSAS are excellent for specific types of data access patterns and are an order of magnitude better at solving these problems than relational and no-sql database platforms....

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