Viewing 15 posts - 3,616 through 3,630 (of 5,841 total)
TRY/CATCH is not a trustworthy construct. All kinds of limitations, gotchas, provisos, etc.
February 11, 2011 at 7:40 am
if it REALLY is the insert that is taking so long then either a) you are doing large scans in that SELECT that drives the INSERT or b) your insert...
February 11, 2011 at 7:37 am
sqldba_icon (2/9/2011)
February 11, 2011 at 7:35 am
1) ORMs are getting better but can still be DEVASTATINGLY BAD for database application performance.
2) one word: SSMSToolsPack!!!! FREE SSMS addin with an incredible array of useful features,...
February 10, 2011 at 10:30 am
I am sorry, but I really don't understand what you are looking for here.
February 9, 2011 at 12:01 pm
Dave Ballantyne (2/9/2011)
TheSQLGuru (2/9/2011)
February 9, 2011 at 9:39 am
sqldba_icon (2/9/2011)
TheSQLGuru (2/9/2011)
1) run your query on both servers with HARD-CODED input values instead of parameters.
2) run query on both...
February 9, 2011 at 9:32 am
Dynamic sql is almost always the most performant way to deal with this type of scenario. Beware SQL Injection as someone else stated and also watch out for procedure...
February 9, 2011 at 5:39 am
lovelanjunping (2/8/2011)
there are some performance issue.
i monitor it by sqlserver profile, i found some system procedure cost much time.
i don't konw...
February 9, 2011 at 5:36 am
It should be EASIER to control what goes on with FEWER people stirring the pot! 🙂
February 9, 2011 at 5:32 am
That book will definitely help you long-term (good one Grant!). However, if you want to get things running better NOW, hire a performance tuning professional and have them monitor/fix...
February 9, 2011 at 5:30 am
a) parameter sniffing as cause:
1) run your query on both servers with HARD-CODED input values instead of parameters.
2) run query on both servers using...
February 9, 2011 at 5:28 am
if you make your update stats a sql agent job, no one will have to remote in and even if they did they certainly wouldn't (SHOULDN'T) leave SSMS running! ...
February 8, 2011 at 1:06 pm
Oh look, another entity out there who threw a workload (or multiple workloads) at the Database Tuning Advisor and accepted everything!! Outside of using Scalar UDFs that is just...
February 7, 2011 at 8:32 am
Better yet, stop using UDFs so you don't get hurt by the MANY ways they can harm you!! 😀
February 4, 2011 at 3:07 pm
Viewing 15 posts - 3,616 through 3,630 (of 5,841 total)