Configuring Service Account Privileges for SQL Server
How to grant Windows privileges to the SQL Server's service account.
2012-02-28
7,734 reads
Lock Pages in Memory
Great SQL Server Debates: Lock Pages in Memory
There has been much debate over the need for the Lock Pages in Memory privilege, on 64-bit versions of SQL Server. Jonathan Kehayias presents a "warts and all" account of its history, the confusions surrounding its use, and why he believes it's still a good default configuration for 64-bit SQL Server instances, even when running Windows Server 2008 and Windows Server 2008R2.
2011-12-29
2,878 reads
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.
2009-10-15
8,639 reads
RE: Troubleshooting DTS errors
Thank you for the insight. I forgot all about the right click/package log function! Please read my reply to phillcart about what I came up with as to the possible problem if you are interested. Thanks again! quote: I do this a couple of ways. 1. Open the DTS package, right click for properties and […]
2003-11-17
2 reads
RE: How should boot.ini look w/ 4GB
So if we do use the /PAE and only have 4GB, is that ignored or should we remove it? Darren
2003-11-14
2 reads
RE: implement parent and child in build of materials “
Hi folks, I’m working away at this end and would like to ask if I’ve followed you correctly regarding: 1) the number of primary keys for each table 2) the relationships between them. So, I’ve listed the tables, with my interpretation of them. tblProduct (single primary key) productId INT NOT NULL IDENTITY(1,1), productDesc VARCHAR(150) NOT […]
2003-06-27
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers