Viewing 15 posts - 526 through 540 (of 22,224 total)
Sounds a lot like you might be interested in building out a DevOps pipeline. You'll want to pick a flow control tool like AWS Developer Tools, Azure DevOps, Jenkins, Octopus,...
"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
March 14, 2023 at 12:11 pm
It's basically the fact that the query is running longer, it has additional duration. It's explained in the documentation right here.
"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
March 13, 2023 at 2:12 pm
Thanks for the feedback everyone. Great stuff. And there should be a title now. I spotted that on Saturday and added it.
"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
March 13, 2023 at 12:50 pm
I had a personally rolled one for statistics I used to use. Then I used, oh gosh, what's her name, used to work for GoDaddy... well anyway, she stopped maintaining...
"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
March 10, 2023 at 5:44 pm
I find that the reason why most people poo-poo xp_CmdShell is because they don't actually know how to use it correctly and safely and they also forget that only...
"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
March 10, 2023 at 5:39 pm
Well, I moved half way across the continent on top of everything else, so, no, things are not what I would call normal, but they're pretty darned close. The one...
"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
March 10, 2023 at 4:25 pm
Thanks....the 2 tables in question are pretty small and have same amount of rows in both UAT & PROD
I've updated the STATISTICS on both tables and waiting for...
"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
March 10, 2023 at 2:42 pm
When it comes to index maintenance, I defer to Jeff.
The only I want to add here is that, as he stated, columnstore is a different ball of wax. Here's...
"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
March 10, 2023 at 2:38 pm
I'd suggest taking a look at sqlcmd instead of bcp. There's a ton more functionality there. While you can run sqlcmd, or bcp, from xp_cmdshell, it's not considered...
"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
March 10, 2023 at 2:34 pm
Think of it this way, you're looking for the second space ' '. That's how you solve this.
"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
March 10, 2023 at 2:29 pm
If you use the command line with SqlPackage.exe - one of the options available is a log file. Instead of importing using SSMS - use the command line with...
"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
March 8, 2023 at 8:57 pm
I know of no way to do that beyond simple testing. Sorry.
"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
March 8, 2023 at 4:23 pm
I don't think that runing the import process of a dacpac is logged individually anywhere. The statements that create the database, tables, etc., are certainly logged (and maybe just getting...
"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
March 8, 2023 at 1:24 pm
I'm perfectly happy to help with homework.
Help.
So, where are you stuck? What have you tried that didn't work? Show me your work, and I'll be happy to toss in some...
"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
March 8, 2023 at 12:46 pm
Hey Brandie,
Honestly not sure on this one. I just wanted to let you know that someone at least looked at the question.
"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
March 7, 2023 at 1:09 pm
Viewing 15 posts - 526 through 540 (of 22,224 total)