2010-12-08 (first published: 2010-12-03)
1,977 reads
Scripts
2010-12-07 (first published: 2010-11-30)
2,182 reads
2010-12-06 (first published: 2010-11-22)
2,603 reads
2010-12-03 (first published: 2010-11-22)
1,698 reads
Average Page Life Expectancy
A useful script that I wrote that will sample the DMV sys.dm_os_performance_counters table to provide an average PLE captured in (1) minute intervals.
2010-12-01 (first published: 2010-11-16)
1,670 reads
SQL Function to Split Comma Separated Values and Insert into Table
SQL Function to Split Comma Separated Values and Insert into Table
2010-11-30 (first published: 2010-11-07)
4,208 reads
2010-11-26 (first published: 2010-11-04)
580 reads
2010-11-18 (first published: 2009-07-20)
2,939 reads
Get SQLServer Name and Uptime SPROC
Stored procedure to provide clean output of system name and uptime since last restart
2010-11-16 (first published: 2010-11-08)
1,249 reads
SQL Server Service Check Utility
Script will display current status of SQL server services and even show if not installed. Works on SQL 2005,2008 2008R2. Both 32 and 64 bit servers.
2010-11-15 (first published: 2010-11-09)
3,530 reads
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Forums
How do I choose a reliable Non Woven Bags Manufacturer in India?
Reliable manufacturers can be identified by consistent product quality, strong stitching, and the ability...
Where can I find reliable fissure treatment in Delhi?
Finding reliable care starts with choosing a clinic that focuses specifically on anorectal conditions...
Is online Partnership Firm Registration Service in Delhi reliable?
Yes, the online Partnership Firm Registration Service in Delhi is reliable when handled by...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers