An Alternative Way To Get the Table's Rowcount
This article examines an alternative method for finding the rowcount of a table besides using a select count(*)
2001-10-05
4,812 reads
Alexander Chigrik
Some Undocumented Stored Procedures
This article examines some of the undocumented stored procedures that exist in SQL Server 7.0
2001-09-28
7,805 reads
Optimizing SQL Server Performance by using File and Filegroups
A look at files and filegroups in SQL Server 7.0, including some optimization tips.
2001-09-27
9,141 reads
Undocumented Stored Procedures in SQL Server 6.5
This article examines some useful undocumented stored procedures in SQL Server 6.5
2001-09-21
3,326 reads
2001-09-03
4,734 reads
Installation Problems in SQL Server 7.0
This article examines some of the common issues that may occur when installing SQL Server 7.0
2001-08-23
3,378 reads
Index Statistics in SQL Server 7.0
A look at Index Statistics in SQL Server 7.0 and how to maintain them.
2001-08-02
3,286 reads
SQL Server 6.5 Data Page Structure
This article presents the technical details of the page layout for data in SQL Server 6.5
2001-07-30
2,776 reads
2001-07-24
7,875 reads
2001-07-19
2,647 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers