Viewing 15 posts - 18,856 through 18,870 (of 19,560 total)
As an extra piece of reading before proceeding down the path to locking pages in memory, read the following:
http://blogs.technet.com/askperf/archive/2008/03/25/lock-pages-in-memory-do-you-really-need-it.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 8, 2009 at 9:39 pm
What is the fragmentation level of the indexes involved in this query (for the tables listed)?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 8, 2009 at 9:21 pm
Jeff Moden (12/8/2009)
JRoughgarden (12/8/2009)
All DBMS's are fairly similar; you do the same things with all of them. It's just the syntax that differs some.
When it comes to the differences between...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 8, 2009 at 9:15 pm
Bru Medishetty (12/8/2009)
GilaMonster (12/8/2009)
You couldn't pay me enough to put up with that.
Gail, I just saw that you edited it by the time I replied last time.
The OP...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 8, 2009 at 4:46 pm
Steve Jones - Editor (12/8/2009)
Every time I do Yoda it comes out Scooby-Doo.
Hey Scoobie...err Steve, where are you?
Your Scoobie now whenever I read something from you.
As for Alvin, well his...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 8, 2009 at 2:15 pm
Please post sample data and your table schema. This will aid in troubleshooting your scenario.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 8, 2009 at 12:52 pm
When I test these two queries, I get the same execution statistics, logical reads, scan count etc. Those results are with and without forced parameterization set.
In the plan, the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 8, 2009 at 12:50 pm
That seems to be scaling about the same as my tests.
I do like the performance gains when a specific ID can be passed though. This script could prove very...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 8, 2009 at 9:39 am
The wording in the explanation don't seem to match the documentation.
http://msdn.microsoft.com/en-us/library/ms191432(SQL.90).aspx
Explanation said that the view must not contain any deterministic functions. The referenced article states that functions must be...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 11:40 pm
I would avoid the shrink of the database. And certainly would not shrink the database to a point that releases all whitespace. By keeping adequate whitespace in the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 11:22 pm
As an alternative, in order to prevent log growth, it may be worthwhile to grow the logfile substantially prior to the data load. Grow the log file to something...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 11:15 pm
As a matter of preference as well as having seen substantial performance gains, I avoid the use of subqueries and use Join statements as well as CTE's. Moving subqueries...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 11:08 pm
The provided script will get you to the point of being able to merge the data. You will need to decide which record in the database to update with...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 10:46 pm
Nice, I like it better than some of the comma split functions I have seen.
What have you seen this scale out to?
For curiosity sake, I decided to see what kind...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 10:36 pm
bpowers (12/7/2009)
UPDATE CUST_LINE_DEL SET USER_ORDER_QTY = '9'
FROM CUST_LINE_DEL
JOIN CUST_ORDER_LINE ON CUST_LINE_DEL.CUST_ORDER_ID = CUST_ORDER_LINE.CUST_ORDER_ID
JOIN CUSTOMER_ORDER ON CUST_ORDER_LINE.CUST_ORDER_ID...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 7, 2009 at 10:01 pm
Viewing 15 posts - 18,856 through 18,870 (of 19,560 total)