-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: March 2017

Automating DBCC DBTABLE – obtaining the disk Sector Size

I was recently reading this msdn article on Ghost Records, and it mentioned that you could get the number of ghost records on a page with DBCC DBTABLE… and it also mentioned that you need to be sure that you enable Trace Flag 3604 in order to see the results.… Read more

0 comments, 7,807 reads

Posted in A Discussion of SQL Server-Related Topics on 22 March 2017

Working with SQLSaturday SpeedPASSes

SQLSaturday SpeedPASSes

I’ve been working with running SQLSaturdays in the Richmond, VA area for several years now. It seems that every year, I end up blogging something new. Frequently, this ends up being a script of some kind to help me out. This post follows this theme by introducing a… Read more

2 comments, 286 reads

Posted in A Discussion of SQL Server-Related Topics on 9 March 2017

Identifying a row’s physical location

While you may not need to worry about the physical location of a row very often, every so often the need comes up. In a few of my earlier posts (here), I have needed this information to prove a point. This post shows how to identify a row’s… Read more

1 comments, 293 reads

Posted in A Discussion of SQL Server-Related Topics on 8 March 2017