Viewing 15 posts - 6,241 through 6,255 (of 22,226 total)
All the more reason to wall them off. Almost no real way to keep them from doing really bad stuff, but at least it will be isolated from the other...
"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 27, 2015 at 11:52 am
Hey Steve! Where did you get pictures of my cousin?
"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 27, 2015 at 11:10 am
DBA-640728 (4/27/2015)
"Drop...
"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 27, 2015 at 10:56 am
I reject your test as completely invalid and a waste of my time and superior intellect along with my ability to craft nonsensical run-on sentences for no purpose other 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 27, 2015 at 10:39 am
Pretty common request, but usually you don't need live data. Run a restore once a day.
By the way, be very, very cautious around giving full access to production data for...
"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 27, 2015 at 10:22 am
If you really need to manage stuff by domain name, I'd suggest adding a column to the table. Either load the domain from the email address, or make it 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 27, 2015 at 10:20 am
Give them a new schema that they can have full control over, but just let them have read access to the DBO schema.
"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 27, 2015 at 10:18 am
Be extremely cautious using repair_allow_data_loss. There is zero guarantee that it will fix the problem by dropping one or two pages worth of data. It can, in some cases, nuke...
"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 27, 2015 at 10:17 am
SequelDBA (4/27/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 27, 2015 at 7:32 am
It's a memory error. It could be pretty benign, just a momentary read/write error in memory that's not going to repeat. It could also be corrupt pages in one 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
April 27, 2015 at 6:50 am
If the transaction log is growing a lot, two things. One, take more frequent log backups. That will free up the committed transactions more often. Two, maybe you just need...
"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 27, 2015 at 5:09 am
I'd go with the latest service pack, yes.
I'm not sure this will address any performance issues you're hitting. This may or may not be related. I would capture wait 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
April 27, 2015 at 3:28 am
You need to look to what the execution plan is telling you for how it's going to resolve this query. Your indexes are not being used or the statistics are...
"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 27, 2015 at 3:25 am
Here's the documentation on CREATE PROCEDURE. That will get you started in putting your query into a procedure. Then, as Jeff said, it's a question of calling it using 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 27, 2015 at 3:21 am
It's most likely a data problem within the cursor itself. I'd focus on what that cursor is doing specifically within the code in order to understand where the problem might...
"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 27, 2015 at 3:17 am
Viewing 15 posts - 6,241 through 6,255 (of 22,226 total)