The other day I ran into a question on msdn:Tempdb Deallocation (dm_db_session_space_usage). A person with the pseudonym DontPageMeBro noticed an odd behavior in his SQL Server installation: The sum of the reported usage of tempdb across all sessions was often bigger than tempdb itself. Something is clearly off here, so I figured it was worth more »
![Purge Problems [TSQL Tuesday #027 - The Big Data Valentine’s Edition]](http://images.sqlity.net/SqlTuesday.png)
T-SQL Tuesday #27 is hosted by Steve Jones (blog|twitter). This month’s topic is “Big Data”. Purge Problems in Big Data – Not only a SELECT needs an index Recently I was called to an issue at a 5+ TB customer. The purge job had stopped working a while back and the disk drives started to more »
Purging old data out of the database usually is driven by a date. If the business does not need records that are older than a Year, and if your records have a date column, you can purge by deleting all records from that table that have a date that is older (“<”) than DATEADD(year,-1,GETDATE()) Sometimes more »
About two weeks ago I wrote about how to get the content of the entire database into an XML document. Today Daniel commented, that he would like the XML to be in a compacter format. In this post I am going to explain how to get there. While WordPress™ conveniently ate the example XML Daniel more »
Forwarded records are a mechanism that SQL Server employs to reduce the amount of maintenance work for indexes on a table without a clustered index. During an update of a record in a table that does not have a clustered index, an increase in size might prevent the record to fit on its current page. more »
follow: RSS