Index Seeks, Scans, and Lookups
This script may help identify tables impacted by frequently-occurring scans.
2010-11-02 (first published: 2010-02-04)
3,889 reads
Scripts
Change String to Title Case(Initcap)
This is simple script to change string to title case. It will take string in any case and convert it to initcap.
2010-10-26 (first published: 2010-10-19)
1,524 reads
Data Dictionary using sys.objects - SQL 2008
Create a data dictionary with two stored procedures using sys objects to view via SSRS (or other reporting tool) report
2010-10-21 (first published: 2010-10-16)
2,261 reads
Flexable Rate Recursion
A Recursion function that was used to apply a Rate percentage to a base amount for the reqested number of times.
2010-10-15 (first published: 2010-10-13)
581 reads
T-SQL generator for sp_configure
The purpose of this code is to create a T-SQL output that can be execute on SQL Server (2005 and higher) to recofigure the SQL server as compared to the settings on which you have executed this code from.
2010-10-14 (first published: 2010-10-05)
1,377 reads
A Flexible Day Of Week Function
A Flexible Day Of Week Function where a criteria can be passed as an integer to a stored procedure.
2010-10-13 (first published: 2010-10-06)
1,397 reads
Transcation Log space monitoring
This SP will monitor T-Log space and sends mail to DBA if log space usage is above threshold value
2010-10-05 (first published: 2010-10-03)
3,505 reads
2010-10-04 (first published: 2010-09-29)
2,923 reads
List all columns in server
I came across a project which required a list of all columns within a server and thought I would post it here in case anyone else had this requirement.
2010-09-30 (first published: 2010-09-28)
1,569 reads
2010-09-29 (first published: 2010-09-28)
1,633 reads
Blogs
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Forums
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
Comments posted to this topic are about the item Can You Really Downgrade from...
What is CPU Usage?
Comments posted to this topic are about the item What is CPU Usage?
Limiting Checkpoints
Comments posted to this topic are about the item Limiting Checkpoints
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers