Viewing 15 posts - 15,586 through 15,600 (of 22,219 total)
GilaMonster (4/1/2010)
Grant Fritchey (4/1/2010)
I just have to share this one. I just got my idea for my next editorial (which, yes, I know Steve, is WAY overdue).
Editorial on free vs...
"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 1, 2010 at 6:05 am
I'm a sucker. I'm sitting here thinking about implications, wanting to take notes, getting ready to post questions to boards... I gotta remember the date when I read these things.
"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 1, 2010 at 6:04 am
I just have to share this one. I just got my idea for my next editorial (which, yes, I know Steve, is WAY overdue).
http://www.sqlservercentral.com/Forums/FindPost894601.aspx
"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 1, 2010 at 5:37 am
scziege (4/1/2010)
Hi,can you send a suggestions for a design of one table with 250 millions rows ?
Greetings
I'm sorry, but no. Not without the business requirements, what's available for the physical...
"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 1, 2010 at 5:35 am
Did I hear Steve say he thought things were too quiet around here?
I guess you guys are slacking.
"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
March 31, 2010 at 6:21 pm
CirquedeSQLeil (3/31/2010)
Jeff Moden (3/31/2010)
Grant Fritchey (3/31/2010)
dma-669038 (3/31/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
March 31, 2010 at 6:00 pm
dma-669038 (3/31/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
March 31, 2010 at 1:27 pm
I'll help. You can't do #2 because DTS doesn't run really run on 2005 servers (yes, you can run it from SSIS or you can do a custom install 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
March 31, 2010 at 1:02 pm
Jeff Moden (3/31/2010)
CirquedeSQLeil (3/30/2010)
Lynn Pettis (3/30/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
March 31, 2010 at 12:55 pm
That's the best way I know to handle it within the database. Just remember, if the error is of severity high enough to cause a disconnect, the CATCH can't catch...
"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
March 31, 2010 at 12:51 pm
Just taking a guess, there's probably something in the WHERE clause that's preventing you from getting the updates. But, as everyone else has said, without specifics, I'm just guessing.
However, 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
March 31, 2010 at 7:26 am
Part way there. That's the structure, but what do the queries look like? And what do the execution plans look like? Can you run this query against the table and...
"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
March 31, 2010 at 4:44 am
david meagor (3/30/2010)
If you pm me with your address I'll post you 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
March 31, 2010 at 12:21 am
Cause you're holding open a transaction on the client. As long as that's working that way, you'll be waiting.
BTW, you can get lots more information out of profiler besides RPC...
"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
March 30, 2010 at 1:07 pm
CirquedeSQLeil (3/30/2010)
I just realized one more complication with the review board. If the MVP were paid by Microsoft to be on this review board, then that person could no...
"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
March 30, 2010 at 10:36 am
Viewing 15 posts - 15,586 through 15,600 (of 22,219 total)