Congrats, Gus

Good luck in the playoffs! I'll get prizes ready next week (or the next), depending on my schedule.

You want to set a specific size for your data files that allows for growth. You DO NOT want to depend on autogrowth as it creates physical fragmentation. Shrink created...

How are you logging into SQL Server (which account) and what are you running to unlock the account?

You might like to read this: http://www.mssqltips.com/tip.asp?tip=1175

Paging takes a little work in SQL Server

First, don't shrink. Not needed, reduces performance.

Second, the t-log backup schedule should be driven but your data loss/downtime SLA, and not necessarily be a once a day item in your...

Was this a PM or email from the SSC system? If so, please send me the account name.

It's junk mail, but there's nothing we can do but delete the account. If they want to keep adding them, we can only kill them when they are reported. I'll...

Joe,

enjoy the weekend.

Might be the end for me too, since a storm is forecast. Not sure we'll get it, but I'll be loading up stuff early today in case we...

If you go to your Google account, you can get an idea of what they know. Here's the "web history" link.

https://www.google.com/history/?hl=en

You can get the maximum capacities for SQL Server here: http://msdn.microsoft.com/en-us/library/ms143432.aspx

For MySQL, I assume you have some documentation somewhere that will show you.

For DTS, save as structured storage files. Use the runtime to execute them: http://msdn.microsoft.com/en-us/library/bb500440.aspx

Note that SQL 11 will not have support for DTS

I tend to agree with Toby. R5 has a write penalty, and to get large storage, you need to move to a SAN, both for IOPS performance and capacity.

Craig Farrell (12/29/2010)

---

Happy holidays all. Just got back from my Christmas vacation. I didn't bother throwing backup into that thread because... well... I didn't have anything to say...

Perhaps you want to explain what you are trying to do in the database from a logical perspective, rather than saying you want a login to own a schema. What...