Viewing 15 posts - 1,096 through 1,110 (of 22,184 total)
Whatever you choose, please, please, OH PLEASE, focus first on clarity and communication. Any other kind of rigid enforcement of some particular little persnickety rule must come second. The purpose...
October 11, 2021 at 4:53 am
Are you initializing the backup file each time, or is the backup file stacking? Try running RESTORE HEADERONLY to see if you're putting multiple backups into a single file....
October 11, 2021 at 4:49 am
Both have a future. Further, "cloud computing" is an insanely vague term, like, "I work with computers". Cloud computing encompasses stuff like cloud-hosted virtual machines, services, up to and including...
October 11, 2021 at 4:45 am
I tried it for a time to see if there was more or better engagement versus Youtube. Kind of sucked actually.
In other news "Oh no, my moribund Twitch account (which...
October 8, 2021 at 1:49 pm
That's a measure you have to do from the client. Azure SQL Database isn't going to see latency on it's end. It's going to get a connection request (however long...
October 8, 2021 at 1:45 pm
Another vote for Extended Events. Safe, as light weight as you can get while still monitoring behaviors on the system.
However, yes, you'll have to set something up in order to...
October 7, 2021 at 11:45 am
Without an error message of any kind, it could be sunspots, extra solar radiation or the vast conspiracy of the Bohemian Grove. We simply don't have enough information to say...
October 7, 2021 at 11:43 am
It's hard to say without a lot more data. Capture query metrics using extended events. Capture wait statistics (you can combine these with the query metrics using extended events so...
October 7, 2021 at 11:42 am
ALWAYS, go to Microsoft for accurate licensing information. They're just going to know better than some knucklehead on the internet, like me.
However, this one I think I can answer accurately...
October 7, 2021 at 11:39 am
I'd argue you'll some some general performance enhancements, but it won't be night & day.
October 5, 2021 at 4:29 pm
Grant,
Got it. Good advice about testing from all.
And it looks like I can us ALTER to create a non-clustered index after the table was created.
Oh yeah. Adding them is...
October 5, 2021 at 2:56 pm
Grant,
I think that is what I am doing. The primary path AFTER sign in is by UserId - the identify column. However, at sign in it looks for the...
October 5, 2021 at 1:35 pm
But, in this case, having the Clustered Index on the UserID is probably perfect.
You also won't need a non-clustered index on UserID then, either.
Jeff's not wrong (I say that...
October 5, 2021 at 12:29 pm
This.
Just that. Everything else is nice to have. But that, that's a flipping miracle. And yes, I mean the word other than flipping.
October 5, 2021 at 12:24 pm
You have to monitor the system in order to understand how it is behaving. Capturing wait statistics and queues can tell you where slow downs are occurring. Capturing performance metrics...
October 5, 2021 at 12:20 pm
Viewing 15 posts - 1,096 through 1,110 (of 22,184 total)