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,783 reads
This article examines an alternative method for finding the rowcount of a table besides using a select count(*)
2001-10-05
4,783 reads
This article examines some of the undocumented stored procedures that exist in SQL Server 7.0
2001-09-28
7,709 reads
A look at files and filegroups in SQL Server 7.0, including some optimization tips.
2001-09-27
8,980 reads
This article examines some useful undocumented stored procedures in SQL Server 6.5
2001-09-21
3,290 reads
2001-09-03
4,298 reads
This article examines some of the common issues that may occur when installing SQL Server 7.0
2001-08-23
3,346 reads
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,638 reads
A look at Index Statistics in SQL Server 7.0 and how to maintain them.
2001-08-02
3,251 reads
This article presents the technical details of the page layout for data in SQL Server 6.5
2001-07-30
2,731 reads
2001-07-24
7,773 reads
By Steve Jones
redesis – n. a feeling of queasiness while offering someone advice, knowing they might...
By Steve Jones
The Solutions Engineers at Redgate recently released an Introduction to Redgate Flyway Autopilot course...
The other day I came across an interesting repo on github, KubeDiagrams. What this...
Hi there to all SQL gurus So, here is the scenario. I have a...
Guys, I am facing problems when running a backup routine JOB in SQL Server,...
1, Customer table [TBLMEMBER] 's structure CREATE TABLE [dbo].[TBLMEMBER]( [TRANNO] [int] IDENTITY(1,1) NOT NULL,...
What is the result of this query in SQL Server 2022+?
select bit_count('7')See possible answers