Viewing 15 posts - 13,786 through 13,800 (of 22,219 total)
You shouldn't be getting divide by zero errors when estimating the size of a row. If you are it's down in the estimating how much data per page calculations, which...
"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
December 22, 2010 at 6:58 am
If you're just trying to execute the create statements as a batch, SQLCMD is the tool.
You could, with only a little bit more work, take advantage of PowerShell 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
December 20, 2010 at 1:30 pm
But understand, you're holding open the transaction, locking resources, possibly blocking other users while that wait is in place. It could be a very dangerous thing to do.
What exactly 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
December 20, 2010 at 1:27 pm
You can also get into more arcane, and expensive, approaches that will solve the problem. Are you on a SAN? Most SAN systems these days can do a transactionally aware...
"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
December 20, 2010 at 1:18 pm
ALZDBA (12/20/2010)
With regards to a log shipped db, connections will have to be modified at switch time !
With regards to a mirrored db solution, you prepare 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
December 20, 2010 at 11:44 am
Elliott Whitlow (12/20/2010)
"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
December 20, 2010 at 11:13 am
Gianluca Sartori (12/20/2010)
I couldn't load Grant's blog today, it seemed to be down, but now it loads and also I got a mail from him.
I can't believe...
"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
December 20, 2010 at 9:24 am
So you want move the data between servers without downtime? That's harder than a simple backup & restore.
While you can backup your database in 32bit and restore it in 64bit,...
"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
December 20, 2010 at 6:27 am
Check the execution plans on both queries. I'm pretty sure you'll see that they're different. You're hitting a bad parameter sniffing problem. I'd also suggest trying the query within 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
December 20, 2010 at 6:23 am
Paul White NZ (12/16/2010)
WayneS (12/16/2010)
Here's just two of the reasons why I've turned it off:
I just typed this successfully in 2008 SSMS with Intellisense on (which it always is):
SELECT ...
"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
December 17, 2010 at 5:48 am
GilaMonster (12/16/2010)
Grant Fritchey (12/16/2010)
I know I'm biased, but I really do like SQL Prompt and the way it works. I think SSMS intelisence is a good idea, poorly executed.
Likewise....
"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
December 16, 2010 at 1:13 pm
I know I'm biased, but I really do like SQL Prompt and the way it works. I think SSMS intelisence is a good idea, poorly executed. Red Gate's product on...
"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
December 16, 2010 at 11:51 am
SwayneBell (12/15/2010)
Grant Fritchey (12/8/2010)
"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
December 16, 2010 at 5:54 am
Jeff Moden (12/15/2010)Having some jitters is not a bad thing. Shaking uncontrolably is a bad thing... especially if you've had lots of water to drink.
I was 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
December 16, 2010 at 5:30 am
It's going to sound funny when I say this, but the sore throat must have something to do with how you speak. I really don't do anything in particular to...
"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
December 16, 2010 at 5:26 am
Viewing 15 posts - 13,786 through 13,800 (of 22,219 total)