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,623 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)
187 reads
Blogs
3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution
By kleegeek
This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity...
The PowerBI Volleyball Report – Organizing Data To Start
By Steve Jones
One of my goals this year was to build a report that I can...
Daily Coping 2 Aug 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Need counts of payment amounts per week grouped by week
Hello, I have a code that suppose to give me weekly(summed) payments, but instead,...
Import CSV Data Into Existing Tables
Hi Guys, I am having issues trying to import data from CSV files into...
Function not returning all data.
I inherited this code. Written by a 3rd party. I have 3 servers, 1...
Ask SSC