Viewing 15 posts - 17,281 through 17,295 (of 22,219 total)
I'm just a bit confused by the situation. Did you have the database in full recovery but you were NOT running log backups? That could explain the excessive size 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
June 8, 2009 at 7:47 am
3 copies of the db on the same server just doesn't make any sense. If they're worried about corruption or loss, then all three on the server are exposed 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
June 8, 2009 at 7:40 am
If it can't access the folder, it's because of security. SQL Server runs under a different context than when you connect to it. Just because you can access the share...
"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
June 8, 2009 at 7:37 am
What about using Performance Monitor to capture user connections all day long? It's the very best way I know to do this.
"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
June 8, 2009 at 7:34 am
Good article.
You could have carried it a bit further. Including RESTORE VERIFYONLY as a part and parcel of your backup routines adds to the overall confidence you have in your...
"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
June 8, 2009 at 5:36 am
I agree with Clive and Lynn, especially Lynn. If you're really planning on making a career out of SQL Server, $50 for the developer's edition, which has everything, is 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
June 7, 2009 at 5:13 am
Lynn Pettis (6/6/2009)
Anyone with more knowledge or information in this area, please hop in and add your 2 cents worth.
Gail & Paul got on the Algebrizer before I could.
"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
June 7, 2009 at 4:36 am
PaulB (6/5/2009)
Grant Fritchey (6/4/2009)A little more flexibility than bit, but then it has a little more flexibility than bit.
not sure if this is a circular reference or quantum-logic 😀
Yes.
"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
June 5, 2009 at 2:53 pm
Lynn Pettis (6/5/2009)
Here is another OMG moment.
Oh wow. That's a first for me. He is right though. Almost any question can be answered by the suggestion to go and read...
"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
June 5, 2009 at 2:52 pm
It's like said before. It could be so many things. Especially with the indexes you have. I suspect page splits are going to be pretty expensive. So some inserts will...
"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
June 5, 2009 at 2:50 pm
Oh, and the ID column doesn't need to be included with the covering index since it's the clustered key. The key values in a clustered index are always available within...
"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
June 5, 2009 at 1:14 pm
This index, IX_StudentServices_StID_R_DU_PID_SeID_L_GS_FD_D_SC, and this index, Indx_StudentID, are basically the same because the leading edge, the first column is the same. You really don't need the second index.
That's not getting...
"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
June 5, 2009 at 1:12 pm
Bob Hovious (6/5/2009)
A bit of humor for those of you who own dice with more than six sides.
Excellent. When they're funny, they're really funny.
"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
June 5, 2009 at 8:55 am
If it's just time, it could be contention, blocking, that made it run longer the second time than the third. It could be that the second time required a page...
"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
June 5, 2009 at 7:54 am
Adding an index will allow the COUNT process to find something with fewer pages than the entire table. Otherwise, you have to do a table scan, every time, no options.
"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
June 5, 2009 at 7:44 am
Viewing 15 posts - 17,281 through 17,295 (of 22,219 total)