Checking fragmented indexes
A quick script to check for fragmentation in a database and generate a list of defrag statments you can run.
2008-09-24
2,460 reads
Monitor database growth - a better way for sp_spaceused
A better way to use sp_spaceused, returning values on one row for the database instead of two.
2008-09-04
4,044 reads
Quick and dirty way to make a very large table
A script that can generate a massive amount of data relatively quickly
2008-09-04 (first published: 2008-07-11)
1,320 reads
Blogs
T-SQL Tuesday #185: Video
This month’s invite is from Erik Darling, who invites you to make a video...
T-SQL Tuesday #185–Being a Video Star
By Steve Jones
This month we have an interesting invite. Erik Darling is the host, and since...
Building Resilience: Leadership Insights from Sports
By Chris Yates
In the bustling world of sports, leadership appears as a beacon of hope and...
Forums
Replace calculation in cursor with set based logic
Hello and thanks if you can help. The calculation in the cursor is correct....
Snapshot Replication: Pre-application script to check prerequisites
Is it possible to write a script that checks a subscriber's environment for prerequisites...
t-SQL help..
I have the following...anyone can point me the right direction to rewrite this code?...
Question of the Day
The User Login
When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?
See possible answers