Viewing 15 posts - 2,521 through 2,535 (of 22,202 total)
I'm somewhat aware of this, but I don't have the precise answer. It's some kind of bug or glitch in the optimizer that gets a difference in row counts. I...
May 29, 2019 at 11:48 am
Good advice from "the warm-and-fuzzy DBA"
Ha! From the "I've burned way too many bridges and finally realize that throwing torches is a bad idea" DBA. I may learn slowly,...
May 28, 2019 at 2:39 pm
I just can't believe some people. I requested our DBA to gather statistics from sys.dm_exec_procedure_stats in production and store them in a non-production database for analysis without compromising permissions....
May 28, 2019 at 1:15 pm
The single best way to do this is through waits. What your server is waiting on is where your bottlenecks lie. Here is an excellent article showing how to...
May 28, 2019 at 11:30 am
A health check is generally not done very often. A server health check is looking at the server configuration, settings, etc., to determine whether or not they are appropriate for...
May 28, 2019 at 11:19 am
With such a tiny table, the engine thought that just locking the entire table would be easier than locking individual rows. Or, possibly, you're updating a significant number of those...
May 28, 2019 at 11:14 am
Have you guys looked at the "SQL Injection Hall of Shame"? http://codecurmudgeon.com/wp/sql-injection-hall-of-shame/
Oh yeah. It's part of my presentation.
May 28, 2019 at 11:03 am
Yes, it's insane that it isn't taken more seriously. People will say that they take it seriously, but then not give the people what they need to...
May 24, 2019 at 2:14 pm
I just presented a new session on SQL Injection at Techorama in Belgium and before that at SQLDay in Poland. As part of the prep, I did searches on recent...
May 24, 2019 at 1:08 pm
I started watching a YouTube video on Azure DevOps. I can't have the sound turned up where I am, so I turned on subtitles. This is as far as...
May 24, 2019 at 1:04 pm
Ha! Yeah, that kind of thing happens to all of us. Random mouse click, sunspots, it happens.
May 22, 2019 at 8:58 am
Oh, and here's another video on waits and queries.
May 21, 2019 at 3:14 pm
Honestly, the best resource is the query performance tuning book in my signature. It's completely focused on what you need.
However, to get started with extended events, start with Microsoft.
May 21, 2019 at 3:12 pm
Well, then it won't matter. If the data will ALWAYS be less than 50 characters then indexing a VARCHAR(50) or a VARCHAR(500) will be the same. It's completely dependent on...
May 21, 2019 at 3:03 pm
Killing SPIDs just puts them into rollback, same as this. I'd be more concerned about what's happening, what has changed, what's new that something that has ran for years without...
May 21, 2019 at 2:59 pm
Viewing 15 posts - 2,521 through 2,535 (of 22,202 total)