Viewing 15 posts - 2,761 through 2,775 (of 39,818 total)
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...
May 29, 2020 at 5:45 pm
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...
May 29, 2020 at 5:14 pm
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.
May 29, 2020 at 5:13 pm
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...
May 29, 2020 at 4:26 pm
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...
May 28, 2020 at 7:04 pm
right click where? If you mean can you hide things in SSMS, then no.
May 28, 2020 at 4:18 pm
What object in msdb is he accessing?
May 28, 2020 at 3:45 pm
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,...
May 28, 2020 at 3:23 pm
Did you read it here?
AFAIK, this isn't an OS setting, but something you'd set disk by disk.
May 28, 2020 at 3:18 pm
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...
May 28, 2020 at 3:16 pm
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,...
May 28, 2020 at 3:05 pm
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...
May 28, 2020 at 3:01 pm
Put the code inline. We have a button (Insert/edit code) above in the toolbar for formatting.
For the Access file, you can zip it, but not many people want to download...
May 28, 2020 at 2:59 pm
True. In most places I've worked, we move tapes offsite, in case of an environmental issue. There's a rotation involved. If you keep all the tapes online, you're defeating a...
May 27, 2020 at 9:10 pm
There were a lot of columns in there, and I grabbed the first bit on the screen. I added Unit_Cost to the display in the question.
May 27, 2020 at 3:33 pm
Viewing 15 posts - 2,761 through 2,775 (of 39,818 total)