Viewing 15 posts - 12,796 through 12,810 (of 22,227 total)
Craig Purnell (4/9/2011)
I have noticed that there are not any presentations on SQL Agent at the various SQL Saturday events and thought to fill a gap:
SQL Agent for the Beginner...
"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 11, 2011 at 4:20 pm
Scalability Doug (4/5/2011)
Ever wonder what's in your SQL Plan cache? Wonder...
"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 11, 2011 at 4:17 pm
Yep, absolutely, Itzik's books are the way to go.
"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 11, 2011 at 10:01 am
CANCER (4/8/2011)
This is what i am getting when i try to collect execution plan.
The query has exceeded the maximum number of result sets that can be displayed in the Execution...
"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 11, 2011 at 4:56 am
No short answers here. Are you sure it's memory that's the issue. Have you looked at wait states on the server? What are things waiting on? Have you gathered metrics...
"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 8, 2011 at 6:10 am
Just so you know, certification is unlikely to help you get hired or get started in a DBA job. In general, you're better off working your way in to 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 8, 2011 at 6:09 am
CANCER (4/7/2011)
thanks for your reply
yes the db is in full recovery and log backups job is running succesfully for every hour.
we have clustered and non-clustered indexes on tables and 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
April 7, 2011 at 6:24 pm
Well, the optimizer isn't dumb, so it makes me wonder if something in your code is causing the problem. That's usually the issue.
"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 7, 2011 at 11:05 am
Sounds like you have a couple of separate issues.
On the log, is your database in Full recovery? If so, are you running log backups? If your database is in...
"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 7, 2011 at 11:03 am
Rather than going to dynamic SQL, have you looked into using SSIS. It's a great ETL tool and you can automate it's behavior, it'll work with referential constraints, there 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 7, 2011 at 10:59 am
It depends on the SAN and the software used there. There are transaction aware softwares used on some SAN systems that can copy the database from one location to another,...
"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 7, 2011 at 10:56 am
After the upgrade did you manually update all the statistics? If not, those are slowly being recreated and you should see better performance eventually. If you did that, then it's...
"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 7, 2011 at 10:52 am
If you have two completely different plans in cache, it's probably the connection settings, specifically the ANSI settings, that are different between Management Studio and the application. Focus 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
April 7, 2011 at 10:37 am
Brandie Tarvin (4/7/2011)
Turning attention to a different media... Anyone remember Captain Carrot and the Zoo Crew?
Nope. Never heard of that one.
"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 7, 2011 at 8:27 am
TheSQLGuru (4/7/2011)
sqldba_icon (4/6/2011)
Grant Fritchey (4/5/2011)
"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 7, 2011 at 7:28 am
Viewing 15 posts - 12,796 through 12,810 (of 22,227 total)