Viewing 15 posts - 6,211 through 6,225 (of 22,219 total)
Tom_Sacramento (4/29/2015)
I appreciate your response, and all your knowledge and experience. Maybe I'm short-cutting or lazy here but I was hoping for a shorter solution/crash course(!:w00t:) than...
"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
April 29, 2015 at 4:04 pm
SQLRNNR (4/29/2015)
Steve Vassallo (4/29/2015)
"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
April 29, 2015 at 3:54 pm
Steve Vassallo (4/29/2015)
"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
April 29, 2015 at 3:43 pm
Sure thing. Best of luck. Report back what you get for a grade. I'm curious.
"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
April 29, 2015 at 11:33 am
For a 42gb database, 8gb of memory is not that low really. But, it does depend on the types of queries and everything else.
I put nearly zero faith in 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
April 29, 2015 at 9:54 am
The Powershell solution is the way to go. It's using SMO calls in the same way as the GUI. That will generate the code the way you're expecting 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
April 29, 2015 at 9:45 am
While I agree with everyone that these tables are not properly normalized, in an effort to help, can you tell me which tables you're trying to understand the relationships between?
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
April 29, 2015 at 9:43 am
spaghettidba (4/29/2015)
Grant Fritchey (4/29/2015)
"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
April 29, 2015 at 9:34 am
It's an emergency traceflag for restarting the server when you've got a failed install going on. It's not something used regularly.
"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
April 29, 2015 at 8:16 am
No. MSDN has one key word in it. Developer. Your SQL Server licenses and your development licenses are different. You can set up Enterprise instances for testing and development and...
"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
April 29, 2015 at 8:13 am
The real question though is, why are you going for a certification. They're only helpful as study guides and possibly when working for a company that wants to maintain Microsoft...
"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
April 29, 2015 at 8:10 am
The trace is going to run on the server, not on your local machine. The output can be from the server to your local machine if you've set up 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
April 29, 2015 at 8:07 am
Sorry. Hope it's not production.
"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
April 28, 2015 at 6:37 pm
Steve Jones - SSC Editor (4/28/2015)
"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
April 28, 2015 at 6:37 pm
Lynn Pettis (4/28/2015)
SQLRNNR (4/28/2015)
Lynn Pettis (4/28/2015)
Lynn Pettis (4/28/2015)
Wow, what some people expect us volunteers.
The OP just PMed me with all the info that had been posted on the forum thread....
"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
April 28, 2015 at 6:35 pm
Viewing 15 posts - 6,211 through 6,225 (of 22,219 total)