Viewing 15 posts - 4,711 through 4,725 (of 22,227 total)
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
I'm with Kevin. You'd be better off looking at the vendor site for whatever drive system you have. I know, for example, that PurStorage has a lot of guidance 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
May 31, 2016 at 4:48 am
Copyright on it would be 2014 I think. Mine says " - Second Edition" on the spine.
"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 27, 2016 at 8:35 am
Oh, and head over to Redgate Software. We offer a ton of free e-books. There are a couple that are worth reading. Gail was an author (or tester, I forget)...
"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 26, 2016 at 3:41 pm
If it makes you feel better, I don't set the price.
"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 26, 2016 at 3:38 pm
The error has to say something beyond invalid. Maybe it's a backup from a newer version of SQL Server than where you're trying to restore it? There could be any...
"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 26, 2016 at 10:36 am
If you hit specific questions, you can always post them here on SQL Server Central and you'll get help.
If you have specific questions about the book, don't hesitate to get...
"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 26, 2016 at 8:08 am
Brandie Tarvin (5/26/2016)
"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 26, 2016 at 6:38 am
Viewing 15 posts - 4,711 through 4,725 (of 22,227 total)