table performance

Question

table performance

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004307 More actions · Answer 1

I don't see any huge problems with that DDL that may cause INSERTs or SELECTs to be so slow. That pretty much isolates things to the code doing the INSERTs/SELECTs. Any chance of you posting the INSERT code so we can try to help there first? If it's more than 30 or 40 lines of code, I'd recommend attaching it as a txt file. It would also be helpful if you could save and attach an actual execution plan according to the 2nd link in my signature line below.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004307 More actions · Answer 2

Agh... almost forgot to ask... are there any triggers on this table?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 3

How many times do we need to ask you for the code that does the insert and select???

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

TheSQLGuru (11/29/2011)
How many times do we need to ask you for the code that does the insert and select???

1.876 LACK. :hehe:

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 5

Ninja's_RGR'us (11/29/2011)
TheSQLGuru (11/29/2011)
How many times do we need to ask you for the code that does the insert and select???
1.876 LACK. :hehe:

Hmm, I think we have a few more requests to make then! 😀

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service