george25 (11/17/2010)

---

Another question:

If a large amount of data (over 100Gb) are removed permanently from a db then this obviously frees up a lot of space within said db. How...

I've gone Stefan's route. To me categories or tags are a way of filtering down the content to specific areas. So the T-SQL posts on my blog. However if I...

I tend to agree with Travis. The product changes so quickly, even the people that write the code might not be tens in another version because it changes regularly.

To me...

You should not have a loop here with a WHILE statement. If you run this in the database server, your update statement will update all rows, not just the ones...

I didn't mean to imply you write bug-free code the first time you sit down. I don't think I ever said it would be perfect, nor do I think Jeff...

I think the author is 100% correct and a genius 😛

I'm not sure what 2.5K will buy, depending on your class of hardware. Tearing out the MB is OK, I guess. Never done it on a server, and not sure...

We have a new saint?

Well I give up. Wide receivers that only shine when I bench them and a manager that can't always remember to move bye players to the bench.

Let me know who...

You can set the IPs in the SQL Server Configuration Manager that SQL Server listens on. In the network protocol section.

What I would do is similar to what Roy has suggested.

Use a script on the source to do an SFTP to the new location. I would have it delete old...

CAST and CONVERT http://msdn.microsoft.com/en-us/library/ms187928%28v=SQL.100%29.aspx

What's your current server hardware? Any benchmarks on memory/CPU avg and peak?

I would always use the existing system as a base benchmark to look at

A large event can be overwhelming. So the primary advice I give is what I got from Andy W.

Play your own game.

Don't try to do what Itzik or Jeff do...

2. script this with something like Powershell - http://blogs.msdn.com/b/buckwoody/archive/2010/01/05/performance-counters-there-s-a-script-for-that.aspx

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/11/30/my-first-useful-powershell-script-capturing-performance-counters.aspx

1. I think if you solve #2, #1 is easy, or you can better control where the data goes.