Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itnagaraj
Yak Posting Veteran
70 Posts |
 Posted - 2010-11-24 : 10:11:22
|
| Hi All, What are the ways are available in SQL Server to increase the performance in a stored Procedure?V.NAGARAJAN |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-24 : 10:33:27
|
| Redesign the system to support queries that are found to be an issue.Work on a lot of different systems and gain experience about theproblems that can occur.Get theoretical and pactical knowledge about how the optimiser works......Oh - and you can give up and buy lots of expensive hardware - that's what most companies do.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-11-24 : 10:33:43
|
That can't be answered in general.It depends on may things for example poor written query, missing indexes, slow hardware, ...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-11-24 : 11:03:30
|
quote:
Originally posted by itnagaraj
Hi All, What are the ways are available in SQL Server to increase the performance in a stored Procedure?V.NAGARAJAN
Looks like an interview question.PBUH |
|
|
|
|
|
|
increase the performance in a Stored Procedure