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,765 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,551 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
7,913 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,233 reads
2001-09-03
3,617 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,283 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,548 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,235 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,707 reads
2001-07-24
7,460 reads
Blogs
The Microsoft Power Platform
By James-Serra
The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow....
From Evangelist to Advocate
It’s time for a little bit of change to occur. I am no longer...
Database File Changes
Data professionals around the globe are frequently finding themselves occupied with figuring out why...
Forums
Building a table based on another one(s)
Hi, We have 3 people that answer the phones to help our customer with...
Best way to find if string is whitespace
I appreciate it is a trifling question and yet. One of our sites organises...
How to measure Latency between App and database server
Hi All, We have SQL Server instance running on a VM. Now we wanted...
Ask SSC