2011-04-26 (first published: 2011-04-20)
2,652 reads
Scripts
Collect SQL Server/Process Information - Quickly
Execute this script to get information on SQL server, databases, processes, memory, buffer, locks, etc.
2011-04-21 (first published: 2009-09-03)
5,612 reads
Automate drive space monitoring for all production servers
Monitoring space in production server is one of the top priority tasks for a DBA. This script will automate it
2011-04-19 (first published: 2009-05-28)
6,083 reads
Reindex all indexes online or offline depending on day of week.
This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.
2011-04-18 (first published: 2008-10-01)
4,681 reads
Security Audit Db_DataReader
Uses sp_MsForEachDb, locates members in db_datareader with permissions other than Select and Connect.
2011-04-14 (first published: 2011-03-29)
1,074 reads
Extend CHARINDEX with occurance matching
Retrieve the charindex of matching string for the desired occurrence
2011-04-13 (first published: 2011-04-06)
1,488 reads
date convertion to different time zone covering multiple location
converting a date from existing timezone to some different time zone covering multiple location
2011-04-05 (first published: 2011-03-24)
1,167 reads
2011-04-01 (first published: 2008-02-23)
3,724 reads
Comparing Stored Procedures, Part 3
Third in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2011-03-30 (first published: 2009-02-16)
2,412 reads
Comparing Stored Procedures, Part 2
Second in a series of scripts demonstrating a quantitative comparison between the text of two stored procedures
2011-03-29 (first published: 2009-02-09)
2,474 reads
Blogs
Finding fields used in a Power BI report in PBIR format with Semantic Link Labs
Have you ever wondered where a certain field is used in a report? Or...
Adding Test data to msdb.sysjobhistory
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Forums
Import data from json file with special characters
I am using the following script to import data from a json file. This...
% processor Time in Activity monitor is greyed out
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...
Tools for MySQL memory estimations and optimization?
Hi all! I’ve been using MySQLCalculator.com for memory calculations, but I’m looking for alternatives...
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers