Search Results

Post by: Akonicov, Dec 15, 2010 in forum: SQL Server 2005 General DBA Questions

Can I zip (and not shrink) table by table?

Post by: Akonicov, Dec 15, 2010 in forum: SQL Server 2005 General DBA Questions

Good suggestion Luis, but I dont think it will help in this case. I'm dealing with the size limitation by deleting tables in their entirety....

Thread by: Akonicov, Dec 15, 2010, 5 replies, in forum: SQL Server 2005 General DBA Questions

I'm getting some conflicting answers from my IT and I need help. Is it true that I need 450 free gigs to shrik a 450 gig database. Because Im down...

Post by: Akonicov, Dec 15, 2010 in forum: SQL Server 2005 General DBA Questions

Thanks Adrian ....Very useful. My databases usually contain between 2,000,000 and 40,000,000 rows, depending on the size of my client. And about...

Thread by: Akonicov, Dec 14, 2010, 4 replies, in forum: SQL Server 2005 General DBA Questions

Is it me or do query speeds tend to slow wayyyy down when there is casting and concatenating involved? In my job (I'm a data analyst not a...