Set up a Memory Quota for SQL Server Memory Optimized Databases

You successfully entered into the In-Memory OLTP world by the hand of SQL Server 2014. After a while you notice that the In-Memory objects are using more memory than you estimated. In this tip you will learn how to proceed.

An Overview of Memory Architecture - Oracle for the SQL Server Guy

A look at the memory architecture of SQL Server and Oracle, for those of you that may need to provide support for Oracle databases.

Server Administration

TechNet Magazine - Oct Q&A

Unexpected Consistency Checks, Troubleshooting Memory Usage, More from Paul Randal.

Poor Man's Enterprise Feature - Lock Pages in Memory

Enable Lock Pages in memory on Standard edition was ONLY an Enterprise feature until now. Read this article to see how you enable this setting in SQL Server.

Alert if the job runs for more than 30 minutes

I have a couple of SP running every 5 minutes and onces every two month they hung and I don't get alerted because is still running. My question is probably really simple for any of you.How can I get alerted if a job runs for more and 30 minutes?Thanks for your help

RE: SP_UPDATESTATS

Hi,you could also try UPDATE STATISTICS 'tablename' with FULLSCAN, ALL go Roy

RE: QA and ASCII 1

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

RE: Rights for public role

If you're thinking about retaining the PUBLIC privileges then I hope you don't still have a guest user defined in those databases. Cheers, - Mark

RE: QOD june 27 select * from

I thought it was common knowledge/best practice to always put text columns last. No one is saying we should rearrange the table design at all, just explicitly select like this select SalesID, SalesDesc, SalesAmmount, SalesComments from... Also I would rename the SalesAmmount column to the correctly spelled SalesAmount