Technical Article

#sp_shrinkdata

Unlike shrinking transaction log, shrinking a data file seems to be tough. A lot of people complained about the "shrink database" option in EM not working, or DBCC SHRINKDATABASE not working, or DBCC SHRINKFILE not working. I have found that a data file will eventually shrink given enough try, time and patience. I've put everything […]

You rated this post out of 5. Change rating

2003-01-14

411 reads

Technical Article

sp_kill

This stored proc has helped me a lot when I needed to restore db, reconfigure replication, and do other database jobs. SQL server KILL command can only act on a single spid. This sp compiles KILL commands in a cursor to kill a group of spids based on database name, login name, host machine name […]

You rated this post out of 5. Change rating

2002-11-11

6,007 reads

Technical Article

sp_checksqlversion

How many times have you seen @@version return a number but failed to interpret what service pack it is? Although SQL 2000 gives a gift (SERVERPROPERTY) of querying a readable value, my script will remedy the puzzle and show more parameters such as CPU speed, memory, windows version, and installation date. The limitations are:1. MSDE […]

You rated this post out of 5. Change rating

2002-10-16

459 reads

Technical Article

sp_checksize

This stored procedure checks the sizes of one or all databases (including total data, total log, data used/free, data used/free percentage, log used/free, log used/free percentage). If a database name is provided, it will only check the given db. If no parameters provided, all dbs will be checked and the total size of all dbs […]

You rated this post out of 5. Change rating

2002-10-01

1,035 reads

Blogs

PASS Keynote Shots

By

Rodney Kidd took some great shots of the keynote and published an album here:...

Microsoft AI Red Teaming Course

By

here is the compiled video of the Red Teaming course Microsoft put together.

What’s New at AWS re:Invent 2025 – Day2 Highlights

By

Day 2 kicked off with Matt Garman’s keynote, and he opened with a quote...

Read the latest Blogs

Forums

Fabric Mirroring

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Fabric Mirroring

T-SQL in SQL Server 2025: The UNISTR Function

By Steve Jones - SSC Editor

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

How Important Are Real Time Decisions?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Important Are Real Time...

Visit the forum

Question of the Day

Fabric Mirroring

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?

See possible answers