Viewing 15 posts - 1,996 through 2,010 (of 22,224 total)
Slightly-OT: I think the discussion link for the 2020-02-11 QotD ("Execution Plan Types") is wrong, it currently points to this editorial. Could someone please fix that?
I didn't "fix...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 12:10 pm
Shocklingly enough, I got this one right.
Yeah, I know, I know. But I'm helping to keep an eye on the site with Steve on sabbatical. Part of this means I'm...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 12:09 pm
I'm currently doing the last bits & pieces of a DWH Upgrade / Replacement to 2017 and I already am screaming for SQL Server 2019 (MDS learns how to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 11:58 am
I know of a company that paid an astronomic sum to keep a warehouse distribution system supported on obsolete hardware and a long obsolete version of the software.
They had...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 11:57 am
I agree with everything you said but, with all the really cool stuff that's been built into SQL Server in the last 8 years, couldn't you have cited a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 11:54 am
Happy to help. Good luck on the test.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 11, 2020 at 12:24 am
I've never taken a single certification from Microsoft. Sorry.
The problem I have with the certs is that there is literally no way for them to know whether or not you...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 5:52 pm
Have you tried Azure Data Studio? I use that with containers all the time. It should work. You may have to use the IP address instead of just relying on...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 3:11 pm
You can get information of the DBCC executions by querying the default trace file for the Audit DBCC Event. It will have login, host name, application name, etc.
Sue
Just...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 1:54 pm
Grant Fritchey wrote:Well nuts. Missed that one too. I stink.
Look at it this way, you're helping the rest of us deal with our imposter syndrome.
HA!
Yep. Just one of the many...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 1:53 pm
If you want to capture the commands without having to run sp_who2 (and oh boy, a ton of ways to get information out of the database better than that), just...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 1:28 pm
I'm not aware of any way of doing this.
Strong suggestion, have a copy of your database in source control so that you can easily restore columns after you find out...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 1:24 pm
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 1:22 pm
Looks like the connection string isn't complete. Here's a blog post that might help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 1:19 pm
Well nuts. Missed that one too. I stink.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 10, 2020 at 1:15 pm
Viewing 15 posts - 1,996 through 2,010 (of 22,224 total)