There isn't. In general, you might keep 100 for those that are mostly read only. For those that have lots of updates, you might try something in the 85-90 range....

Thanks, I try to do 2-4 on a subject when I can. It's good and I'm hoping it builds knowledge across time, not just memorizing something across a few days.

Welcome...

Labor Day probably makes sense. Easier to put this out there and then change later, than keep extending it.

No update from RG, but quite a few people are thinking we...

If you "report" a post now, it goes to spam. We can un-spam it as admins. With the way that spammers work, we decided to live with the few complaints...

You can calculate this easily, using the datatypes and accounting for overhead. I believe varchar is 2 bytes overhead, and nvarchar is likely 2 or 4. It's in the docs...

Time frame makes sense, though we usually clear up false positives from users. Not sure many people have many spam posts across their entire time here, but a good point.

User blocked. I don't know that there's a way now to block someone with x spam messages, but filing an issue.

Thinking that 3 spam messages is enough. The false positives...

I'm asking what object is causing the error. Most users cannot click any object in a database and get select 1000. It depends what the object is defined to be...

right click where? If you mean can you hide things in SSMS, then no.

What object in msdb is he accessing?

I think the USE statement gets us into trouble. It can be helpful to ensure you are in the right db, but I think when running scripts and making changes,...

Did you read it here?

https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices

AFAIK, this isn't an OS setting, but something you'd set disk by disk.

There isn't an Availability Group in SQL Server 2008 R2. That technology was introduced in 2012. You have a cluster, or really, a Failover Clustered Instance (FCI) with two nodes...

This is based on your language setting.

SELECT top 10
 *
 FROM sys.syslanguages

There is a datefirst column here. If you change the language, you change this.

Apart from that,...

I find myself getting annoyed or frustrated at times with other's work schedules. Either they're behind, or they are go-getters and doing more than ever. Depending on my mood and...