Viewing 15 posts - 2,866 through 2,880 (of 22,224 total)
I don't know how it's extracting an MDF/LDF from the .BAK file (if it is). I assume it's possible because my company does some similar magic through one of our...
"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
November 27, 2018 at 5:16 am
Tiny nit. Take away the calculation. Make it before in a local variable. It might lead to different row calculations. You are getting a VERY large disparity in estimated versus...
"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
November 27, 2018 at 5:12 am
"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
November 26, 2018 at 8:48 am
25 columns is likely to be most or all of the columns (guessing of...
"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
November 26, 2018 at 8:11 am
Sounds like you're trying to recreate the functionality from the Query Store. I'd suggest you take a look at this open source project. It may 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
November 26, 2018 at 6:53 am
"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
November 26, 2018 at 6:50 am
"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
November 26, 2018 at 6:44 am
I don't know which tool you're referring to. However, the command there is running an attach from an MDF and an LDF. You can't attach from a .BAK. You can...
"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
November 26, 2018 at 6:42 am
"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
November 26, 2018 at 6:36 am
Good morning Experts,
Does the order of columns in a table matter? Also, does the...
"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
November 26, 2018 at 6:28 am
I know what are the isolation levels, and the differences between them. I was...
"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
November 15, 2018 at 9:56 am
Yeah. You'll have to correlate in the IDs. A SPID can, and should, be reused, so without the time correlation, this spid, at this time, you can't make a direct...
"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
November 15, 2018 at 9:50 am
Let's start with this:
Both are evil!
That out of the way, you can only use NOLOCK by modifying code. You can use READ UNCOMITTED by changing...
"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
November 15, 2018 at 6:45 am
Oh. My.
I will not be participating in that conversation. Neither as Grant nor as the PASS President. Woof! Y'all have fun.
"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
November 14, 2018 at 2:14 pm
Ah, tracked down a copy of the reports possible in the HP thing:
Active Connections • Database Status • Filegroup Space Usage • Locks Wait Rate • Microsoft SQL...
"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
November 14, 2018 at 11:19 am
Viewing 15 posts - 2,866 through 2,880 (of 22,224 total)