Viewing 15 posts - 12,211 through 12,225 (of 22,219 total)
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
It could be resource contention, blocking, statistics... hard to know without more information. First, check for blocking. Run a quick query against sys.dm_exec_requests. That will tell you if your process...
"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:22 am
Without more information, it's hard to know. OK, the database was in recovering mode. Fine. Were there transactions being run against it when it shut down? What was the status...
"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 5:28 am
Koen Verbeeck (6/28/2011)
Grant Fritchey (6/28/2011)
First person I know to get one. Well done!
Thanks!
I started at a new client today, and when I first logged into my new development station, I...
"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 28, 2011 at 2:06 pm
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 session last...
"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 28, 2011 at 1:40 pm
Chad Crawford (6/28/2011)
Wahoo! My users group just scheduled me to speak in August. Let the stress begin.... 😀
Congrats. Have fun. Don't get stressed. If you're not having...
"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 28, 2011 at 11:17 am
Viewing 15 posts - 12,211 through 12,225 (of 22,219 total)