Viewing 15 posts - 9,076 through 9,090 (of 22,224 total)
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
Sean Lange (1/14/2014)
Yesterday my supervisor sent me an email regarding a view that wasn't...
"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:54 am
New Born DBA (1/14/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 14, 2014 at 10:52 am
I'd probably try to isolate the big systems to a single box each and then cram all the small systems onto one box and let SQL fight it out there....
"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 4:17 am
Instead of doing the top 1000 rows gui exploration of data, what if you just write T-SQL and look at the data that way, does the same thing occur? I've...
"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 4:15 am
Generally it's not a good idea to RDP into a production server, especially to just run queries. Remote connections through SSMS on your desktop are safer.
But, that's probably not...
"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 4:13 am
If you do a search in the scripts section here on SSC I'm pretty sure there are one or two T-SQL scripts that can do some compares. But they're seriously...
"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 am
dbassassin (1/13/2014)
I read at brentozar.com:
http://www.brentozar.com/blitz/jobs-owned-by-user-accounts/
http://www.brentozar.com/blitz/database-owners/
So would you recommend striving towards not using SA (possibly even renaming/disabling it), and creating new accounts that are least privilege for specific purposes?
I've always setup...
"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:48 am
mxy (1/13/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 14, 2014 at 3:46 am
A linked server isn't direct. It's a hop away from the server. Direct would be to open a connection to the second server from the app code. But that's 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 13, 2014 at 3:20 pm
But the deadlocking must be occurring in and around that table. You need to concentrate on the queries that are accessing that table. It has to be the one associated...
"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 13, 2014 at 3:12 pm
Viewing 15 posts - 9,076 through 9,090 (of 22,224 total)