Viewing 15 posts - 12,211 through 12,225 (of 22,224 total)
TST1 (7/1/2011)
Thanks Gail, but the guy closed his session so I guess he'll have to re-write!
I did the same thing myself a couple of weeks back. This little query[/url] saved...
"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
July 1, 2011 at 11:20 am
Jim Murphy (7/1/2011)
Oh, in case everyone didn't hear: Congratulations Gail for making MVP again!
DITTO!
"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
July 1, 2011 at 11:13 am
Just using a SQL Query? No.
You can program it, but you'd want to look into using something like Powershell in combination with SMO in order to do it.
"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 30, 2011 at 8:08 am
Speaking honestly, there is no best tool. There is a best tool for your situation and the amount of money you're prepared to spend and the type of monitoring you...
"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 30, 2011 at 7:15 am
sqlnaive (6/29/2011)
Here is the attachment. I've scratched my head blue and black. 🙁
The optimizer is timing out on this query, so whatever plan you have is less than optimal.
Why all...
"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 30, 2011 at 7:03 am
Just remember, those costs are just estimates, not actual measurements. This means there is no correlation between index fragmentation and what you're seeing in the execution plan and what 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
June 30, 2011 at 6:55 am
In SQL Server Management Studio, right click on the database in question and select "Tasks" - "Generate Scripts" and follow through the process there. You should be able to script...
"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 30, 2011 at 6:53 am
Add another file to the log on tempdb on a different drive. Then you should get a log truncation at the next checkpoint and then you can shrink the file...
"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 30, 2011 at 6:45 am
SQLkiwi (6/30/2011)
Trey Staker (6/29/2011)
I wish there were ratings on posts, maybe a thumbs up or down on answers like on Ask SCC.
Interesting idea. One effect might be that 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 30, 2011 at 5:25 am
I don't know licensing for crap. Because I don't know licensing, I always refer licensing questions to sales people & lawyers. Seems safer.
Regardless, can you do this thing, splitting up...
"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 29, 2011 at 12:03 pm
Friend of mine could use some product specific help that I'm no good with. I suspect if anyone knows this stuff, you guys do.
"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 29, 2011 at 11:32 am
Ninja's_RGR'us (6/29/2011)
I didn't feel like going down that rabit hole ATM... nor searching again for that link :w00t:.
More to the point...
"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 29, 2011 at 8:25 am
Ninja's_RGR'us (6/29/2011)
Satnam Singh (6/29/2011)
I will do post it. I was wondering it might be due to some constraints been missing on the tables.
That would potentially affect data quality, and very...
"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 29, 2011 at 8:09 am
Gianluca Sartori (6/29/2011)
Koen Verbeeck (6/28/2011)
Chad Crawford (6/28/2011)
Wahoo! My users group just scheduled me to speak in August. Let the stress begin.... 😀
Congratulations.
I did my very first technical...
"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 29, 2011 at 8:07 am
calvo (6/29/2011)
Ninja's_RGR'us (6/29/2011)
... or upgrade sql express to sql express R2.
^^
Doesn't matter if it is standard, enterprise, or express, it's the same version number and that's all that matters. Now,...
"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 29, 2011 at 6:25 am
Viewing 15 posts - 12,211 through 12,225 (of 22,224 total)