Viewing 15 posts - 9,076 through 9,090 (of 22,219 total)
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
Alan.B (1/13/2014)
I took a quick look at this and there does appear to be a lot parameter sniffing but there's a lot of other problems too.
I'm confused. Please let...
"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:10 pm
Not sure why you're getting the error without seeing more about how the code, your servers, the connections between them are all configured. But, you are using distributed transactions because...
"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 12:47 pm
Sean Lange (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 13, 2014 at 10:55 am
If you're seeing one set of behavior from SSMS and a different one from SSRS, the possibility could be bad parameter sniffing, but, the way to address that issue is...
"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 10:53 am
Deadlocks are a performance issue. It's all about the ability of transactions to clear prior to arriving at a deadlock situation. From the sounds of things, you've probably been borderline...
"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 7:28 am
Viewing 15 posts - 9,076 through 9,090 (of 22,219 total)