Viewing 15 posts - 2,776 through 2,790 (of 22,202 total)
Not sure the hospital would approve and he hasn't had alcohol in a...
January 16, 2019 at 6:44 am
I'd need to experiment to be sure, but I suspect that the account that SQL Server is running under can't access the blob storage. Focus on security.
January 16, 2019 at 6:17 am
In addition to moving the databases (backup and restore, unless you want to talk third party tooling) and configuring security (which you've received a lot of good advice around), one...
January 14, 2019 at 7:54 am
Yikes. Just glanced back through and spotted this:isnull(c.DBAction, '') != ''
That's another performance killer. You have a ton of tuning opportunities here without even looking...
January 11, 2019 at 8:01 am
January 11, 2019 at 7:56 am
It doesn't matter that you're not an MVP or whatever. You can teach beginners sessions in tech. Do one on backups. WAY too many people are still getting that wrong....
January 11, 2019 at 6:37 am
January 11, 2019 at 6:34 am
Stuff like this is going to kill performance:
convert(int, sessionUpdate.OBJECT_ID / @idRange) = 6
I didn't read every line or go through it all, but...
January 11, 2019 at 6:32 am
You can look to the Extended Events system_health session for some information. There is an event on long running queries that will be in there and might supply you with...
January 11, 2019 at 6:28 am
Except for materialized views (more on that in a moment), a view is just a query. Yes, it looks and acts like it's a table. It's not. It's just a...
January 11, 2019 at 6:22 am
Let anyone do anything in any way that they want to with backups... right after they prove that they can do a point in time restore as easily and quickly...
January 11, 2019 at 6:15 am
Yeah, and you're in "all" and "auto" for the capture... Maybe change the capture mode. Auto only captures queries that are called more than three times or run longer than......
January 10, 2019 at 11:00 am
If you really want to automate this and run it all the time across multiple environments and multiple databases, I'd strongly suggest getting a copy of Redgate SQL...
January 10, 2019 at 7:16 am
I have not seen this behavior. Is the size allocated smaller than the actual size? I've seen that cause problems. Try flushing it to see if that clears the collection....
January 10, 2019 at 7:01 am
January 9, 2019 at 5:30 am
Viewing 15 posts - 2,776 through 2,790 (of 22,202 total)