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,612 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
T-SQL Tuesday Retrospective #006: What about blob?
I am revisiting old T-SQL Tuesday invitations from the very beginning of the project....
Daily Coping 2 Dec 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Database Corruption, how to investigate root cause?
By nelsonaloor
Introduction: In this article, we will discuss the MS SQL Server database corruption. So, first, we...
Forums
vbs failing
This vbscript for Excel that opens a pipe delimited file is failing srccsvfile =...
SQL Server Load
Hi, The application team is pushing more than 7 lakhs records per day to...
Converting minutes to hh:mm:ss
I'm trying to develop a formula to convert minutes (my raw data) to hh:mm:ss...
Ask SSC