Viewing 15 posts - 541 through 555 (of 22,232 total)
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
Look at the join criteria within the details of the operator and see what the likely output from that is, based on the statistics provided. Additionally, see if there are...
"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:08 pm
Probably your best bet is to export the database to flat files. You could try reading from the tables into another database too. Otherwise, you may be down to trying...
"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 3, 2023 at 1:30 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
March 2, 2023 at 6:24 pm
Rebuilding an index does two things. First, since you're literally rebuilding the index, it reorders the pages and the rows on those pages. This has a benefit in that 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 2, 2023 at 3:05 pm
Restarting SQL Server does a whole ton of things. First, you're flushing memory. So queries coming along after the reboot have a clear memory run to load up just their...
"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 2, 2023 at 2:57 pm
Nope. If it's already running, you can't retroactively start collecting the data necessary for a plan with runtime statistics.
However, on SQL Server 2019 or greater and Azure SQL Database, 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
March 2, 2023 at 2:49 pm
Yeesh. Your team stacked up a bunch of jenga blocks awfully high. Have fun playing.
"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 1, 2023 at 7:51 pm
Viewing 15 posts - 541 through 555 (of 22,232 total)