Viewing 15 posts - 6,451 through 6,465 (of 39,877 total)
I saw a post today from Brent Ozar on this. They recommend doing index rebuilds as a way of testing the network load.
If you're in simple mode, maybe...
September 21, 2017 at 2:32 pm
Must be some artifact of dealing with various numeric notations. Still, strange.
September 21, 2017 at 10:09 am
September 21, 2017 at 9:20 am
September 21, 2017 at 9:13 am
September 21, 2017 at 9:08 am
September 21, 2017 at 9:06 am
I have no idea. Precedence means that '1,,,,,' is converted to money, but I don't understand why the multiple separators don't cause an error.
September 21, 2017 at 9:03 am
September 21, 2017 at 9:01 am
If you click, it pops a JS box that asks if you'd like to edit. If you click it, you can edit your post.
If this doesn't work, send a...
September 20, 2017 at 3:31 pm
Keep in mind if you shrink the MDF, you can cause index fragmentation. You may need to rebuild indexes, which means space is needed in the files.
SQL Server...
September 20, 2017 at 12:21 pm
I'll try to blog or write a better article(s) on this stuff as well. I demo it, but don't have great pieces on it. I'll rectify. If you have questions,...
September 20, 2017 at 12:17 pm
Ah, you are correct. I think this didn't work at some point. You needed a login for this.
Containment is potentially a choice here, but connection strings need to...
September 20, 2017 at 11:03 am
If they did, that's fine. I'd be sure, since if there is an issue, they may hold you liable. Double check.
If you do this in the db, you...
September 20, 2017 at 10:58 am
One thing to be aware of is the log transfer load. If you look at the log backup sizes over time, in aggregate, you'll get an idea of the network...
September 20, 2017 at 10:26 am
September 20, 2017 at 10:24 am
Viewing 15 posts - 6,451 through 6,465 (of 39,877 total)