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,790 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,763 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,044 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,302 reads
2001-09-03
4,490 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,359 reads
Generate Insert Statements Easily
This script will generate insert statements for the given tables. You can pass the tables names, separated by commas, into sp_DataAsInsCommand stored procedure as in the example below: EXEC sp_DataAsInsCommand 'employee,titleauthor,pub_info' Updated on 5/25/01 to correct an issue with columns that are short like a column defined as char(1), to correct another issue with the […]
2001-08-09
4,650 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,257 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,737 reads
2001-07-24
7,819 reads
Blogs
PASS Data Community Summit 2025 Slides and Code
By alevyinroc
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...
Tech Conferences and Expanding Your View
By Brian Kelley
Tech conferences aren't just for networking and learning how to address a problem you're...
Managing subscribers, creating newsletters
By DataOnWheels
When I created the website on WordPress, I was expecting all the features I...
Forums
Getting the Schema for Tables
Comments posted to this topic are about the item Getting the Schema for Tables
An Unexciting Exciting Release
Comments posted to this topic are about the item An Unexciting Exciting Release
UNLOGGED Tables in PostgreSQL: When Speed Matters More Than Durability
Comments posted to this topic are about the item UNLOGGED Tables in PostgreSQL: When...
Question of the Day
Getting the Schema for Tables
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers