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,618 reads
Amit Singh
Finding All Index Info for Small Databases
This is a simple script which would list sp_helpindex information for all the tables in the database. You dont have to provide any table name or anything. Just run it on the database from which you want to retrieve the information.This is helpful when you have several servers running the same form of DB, and […]
2005-08-10 (first published: 2005-07-26)
186 reads
Blogs
Encryption in SQL Server #1 – Column Level Encryption
For one reason or another data security and encryption has been coming up quite...
Career: Talk To References
By Steve Jones
As we try to get through these strange times in the world, I am...
This Saturday: #DataWeekender, DataSaturday Southwest
By Will Assaf
Geeked to be speaking 2x on Saturday May 14, my second time speaking at...
Forums
SSIS Import only new values from a CSV without using a staging table
Hello, How can I import a CSV file in SSIS (2016) at the same...
Query store index rebuilds
Recently we experienced a sudden surge in disk I/O every twenty minutes or so....
Group Managed Service Accounts for SQL Server 2017/2019
We use group managed service accounts for running the SQL Server 2017/2019 sqlserver.exe processes...
Ask SSC