EMPTYFILE

Cancelling DBCC SHRINKFILE with EMPTYFILE

A fun experiment using DBCC SHRINKFILE to rebalance data.

Partial Shrinking

Shrink Tlog Files

DBA many a times need to shrink the log files if that grows very large. Though I am not recommending to do it daily or often but if space is an issue and you want to release space to OS, you may use the script.

Execute SQL Server DBCC SHRINKFILE Without Causing Index Fragmentation

Simon Liew shows how to execute SQL Server DBCC SHRINKFILE without causing index fragmentation and example conditions that cause fragmentation.

The Real World: Implementing Data Compression in SQL Server 2008 R2

Sharing our experience using Data Compression as a space savings option in MS SQL Server 2008

Shrinking the transaction log

Re-size TempDB files

Managing TempDB can be a bit tricky at times. Most people know how to increase the size, but what about reducing it? New author Amar Pogaku brings us two techniques for shrinking tempdb.

RE: SQL Server on Linux

Well, we got the boss. "Looks like they got me (should have looked further)." My, that was fun. What I didn't know is that he was first saw http://www.sswug.org/columnists/editorial.asp?id=623, which was then posted on /. So Steve's article reinforced it. He was completely snookered, and took at least half an hour looking for any press […]

RE: Stored Proc vs Query

Here's a thought, how about you provide some more details on what you're doing. Table schemas, stored procedure code, type of hardware the server is running on.Th emore details you provide the more likely you are going to get an authoritive answer, rather than just a guess.