Generate script to rebuild indexes in a database
Generate script for reconstgruir ena database indexes
2016-05-23 (first published: 2014-03-20)
2,584 reads
simpledba
2014-10-29
1,173 reads
Size of database files for an instance of SQL Server
Size of database files for an instance of SQL Server
2014-05-07 (first published: 2014-04-10)
1,301 reads
2014-05-02 (first published: 2014-04-09)
1,773 reads
2014-05-01 (first published: 2014-04-09)
1,498 reads
2014-04-24 (first published: 2014-04-05)
1,988 reads
backup, differental and transactions
Backup all databases for an instance (complete, Differential or log of transactions)
2014-04-21 (first published: 2014-04-05)
1,064 reads
Blogs
Visualising SQL Server in Kubernetes
The other day I came across an interesting repo on github, KubeDiagrams. What this...
Picking a Starting Table in Test Data Manager
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
SQL Server Migration Using a Distributed Availability Group
SQL Server migrations are a headache, ask anyone who’s been through the pain of...
Forums
Prepare Sum of Bill Amount Having two different status with fast performance
1, Customer table [TBLMEMBER] 's structure CREATE TABLE [dbo].[TBLMEMBER]( [TRANNO] [int] IDENTITY(1,1) NOT NULL,...
Counting Bits II
Comments posted to this topic are about the item Counting Bits II
Question of the Day
Counting Bits II
What is the result of this query in SQL Server 2022+?
select bit_count('7') See possible answers