Viewing 15 posts - 9,061 through 9,075 (of 22,219 total)
OK. Have you checked the error logs, both SQL Server and Windows? I can't really suggest a whole lot more than that without more details than that you have an...
"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
January 16, 2014 at 5:20 am
KWymore (1/15/2014)
"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
January 15, 2014 at 4:02 pm
below86 (1/15/2014)
I agree that I've looked at what I've done 2/5/10 years ago and think "what the 'H' was I thinking". And yes you would love to go back...
"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
January 15, 2014 at 11:43 am
I agree on the number of students. Also, what's the difference between student_pk and student_id? Seems like one or the other isn't needed unless the ID is some sort 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
January 15, 2014 at 10:36 am
I'm actually a little shocked at some of the responses from the editorial. I thought the editorial was absolutely spot on.
For all those who think that you shouldn't be striving...
"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
January 15, 2014 at 10:28 am
Alan.B (1/15/2014)
"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
January 15, 2014 at 9:39 am
Very little to go on there. Usually these things are due to security settings. Does the account that you set SQL Server up to run under have the appropriate access?...
"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
January 15, 2014 at 3:58 am
One more, we recorded a two-part webinar[/url] for Red Gate (who I now work for, didn't when I wrote that book) on deployments. Part two is primarily around Red Gate...
"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
January 15, 2014 at 3:50 am
I wrote several chapters in a book called, SQL Server Team-Based Development[/url]. Now, some of the work is WAY out of date since the technology has moved on quite 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
January 15, 2014 at 3:47 am
katrina92886 (1/14/2014)
"capturing query metrics using extended...
"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
January 14, 2014 at 6:04 pm
dwain.c (1/14/2014)
Grant Fritchey (1/14/2014)
DTA!!!!!!Burn it with fire!!!
And here I thought I was the only one that felt this way. 😛
Nope. And I'm starting the rewrite on the chapter 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
January 14, 2014 at 6:02 pm
Not sure. Could be they weren't there when you created the plan? Could be you have async statistics enabled on the database which means plans can be created without statistics...
"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
January 14, 2014 at 3:52 pm
Good idea, in general, to use trace events, but Profiler the GUI is not the best thing to run against a production system. Best of all, since you're in 2008,...
"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
January 14, 2014 at 3:47 pm
I would use system administration ownership for packages and databases, yes, but not the 'sa' account. Two different critters.
"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
January 14, 2014 at 12:15 pm
Ah, a remote server is tough. You either have to have a tunnel to it through the firewall (and that's whether or not you're using SQL Compare) or, you have...
"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
January 14, 2014 at 10:55 am
Viewing 15 posts - 9,061 through 9,075 (of 22,219 total)