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,586 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)
185 reads
Blogs
How Many Bytes Per Character in SQL Server: a Completely Complete Guide
A Completely Complete Guide to how many bytes are used to represent characters in...
Power BI Monthly Digest – November 2019
By Devin-Knight
In this month’s Power BI Digest Manuel Quintana [Blog | Twitter] and Mitchell Pearson...
Data Masker Reads Column Classificiations
By Steve Jones
One of the newer features in Data Masker for SQL Server is the ability...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Logins while migration.
Hi This is when you are migrating from old server to new server. Is...
VM and SQL core license
I am using SQL server 2017 standand edition. We installed on a virtual machine....
Ask SSC