Viewing 15 posts - 4,696 through 4,710 (of 22,219 total)
Jacob Wilkins (6/1/2016)
Starting 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
June 1, 2016 at 12:30 pm
jasona.work (6/1/2016)
When you're reading something, think of something (maybe related, maybe not) that you want to look up, and in the time it took to open 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
June 1, 2016 at 10:42 am
Jacob Wilkins (6/1/2016)
Starting 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
June 1, 2016 at 10:30 am
With one being estimated and one being actual, I'm inclined to say these plans are identical, but I'd want to be sure before I went there. Frankly, I'm not sure...
"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
June 1, 2016 at 9:07 am
yb751 (6/1/2016)
Steve Jones - SSC Editor (6/1/2016)
yb751 (6/1/2016)
The purchase of some Red Gate tools finally got approved by my boss. 😀
Feels like I've been begging forever. ...
"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
June 1, 2016 at 8:25 am
No. That's why it's telling you to install Visual Studio.
"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
June 1, 2016 at 6:00 am
You could probably treat it like versioned data and only retrieve the latest row of each type. I have example queries in this article [/url]on how to do 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
June 1, 2016 at 5:33 am
SSDT is built into Visual Studio. You're going to have to install at least the shell of Visual Studio to get SSDT. You can download it from here. The requirements...
"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
June 1, 2016 at 5:31 am
I wouldn't try doing this through T-SQL. Instead, look to Powershell. There are tons of examples of exactly this type of on demand script generation using PowerShell.
"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
June 1, 2016 at 3:22 am
Steve Jones - SSC Editor (5/31/2016)
New sample db: https://github.com/Microsoft/sql-server-samples/blob/jodebrui/samples/databases/wide-world-importers/documentation/root.md
And I intend to start messing with it as soon as I get the new bits installed tomorrow.
"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
May 31, 2016 at 8:25 pm
No. All things being equal, there would be no reason why it run faster in either location. So, the question is, what's different? Are you capturing execution plans or client...
"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
May 31, 2016 at 4:01 pm
Because SQL Fertilization needs to become something we all talk about. It's important. Don't you understand how SQL Fertilization works?
"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
May 31, 2016 at 10:45 am
That's weird. It has to be a typo or a misinterpretation. They could mean normalization or optimization or... I've never heard of SQL Fertilization, so I've got nothing. Of course,...
"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
May 31, 2016 at 10:40 am
TheSQLGuru (5/31/2016)
Igor Micev (5/31/2016)
My experience with SSDs on a write-intensive instance was very bad. The SSDs went out for 2 months.
What SSDs did you have? What was very bad about...
"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
May 31, 2016 at 8:04 am
I don't think there's a single list of just the @@ values. They're used for different things in different ways and the usage seems to determine their placement within 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
May 31, 2016 at 7:14 am
Viewing 15 posts - 4,696 through 4,710 (of 22,219 total)