Viewing 15 posts - 11,611 through 11,625 (of 19,560 total)
Greg Edwards-268690 (11/24/2010)
Alvin -
I seem to also recall some steakhouse where you could get an insanely large piece of meat.
Like 60...
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
November 24, 2010 at 3:07 pm
I'm in favor of seeing the DDL prior to making suggestions. Test data would help significantly.
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
November 24, 2010 at 2:38 pm
Can you provide the info requested in my last post?
You are possibly experiencing a lot of paging due to lack of memory.
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
November 24, 2010 at 2:13 pm
What kind of connection are you using to connect to the Oracle instance?
Have you installed any Oracle drivers?
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
November 24, 2010 at 1:46 pm
Some essentials to know:
What is the size of the database in question?
What is the growth set for the log and data files?
How many transactions/sec do you see?
What is the fragmentation...
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
November 24, 2010 at 1:42 pm
WayneS (11/24/2010)
CirquedeSQLeil (11/24/2010)
WayneS (11/24/2010)
Speaking of Joe... he's asking for help at http://www.sqlservercentral.com/Forums/Topic1026157-391-1.aspx
Don't have a good answer for that. My initial response would be go take some math classes at...
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
November 24, 2010 at 1:35 pm
WayneS (11/24/2010)
CirquedeSQLeil (11/24/2010)
WayneS (11/24/2010)
Speaking of Joe... he's asking for help at http://www.sqlservercentral.com/Forums/Topic1026157-391-1.aspx
Don't have a good answer for that. My initial response would be go take some math classes at...
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
November 24, 2010 at 1:34 pm
If it works as well as they hope, then congrats. For now, I'll stick with what I have.
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
November 24, 2010 at 1:29 pm
WayneS (11/24/2010)
Speaking of Joe... he's asking for help at http://www.sqlservercentral.com/Forums/Topic1026157-391-1.aspx
Don't have a good answer for that. My initial response would be go take some math classes at the local...
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
November 24, 2010 at 1:26 pm
chrisn-585491 (11/23/2010)
We focus on the hardware and the software and the data, but we tend to forget about the people, the most important, most expensive, most fragile part of 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
November 24, 2010 at 12:50 pm
WayneS (11/24/2010)
CirquedeSQLeil (11/24/2010)
Craig Farrell (11/24/2010)
CirquedeSQLeil (11/24/2010)
jcrawf02 (11/24/2010)
Should we point out that his view solution doesn't *just* give you the duplicates? 😉Yes - fire away!!!!!!!!!
I just ended up having to thump...
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
November 24, 2010 at 12:24 pm
Craig Farrell (11/24/2010)
CirquedeSQLeil (11/24/2010)
jcrawf02 (11/24/2010)
Should we point out that his view solution doesn't *just* give you the duplicates? 😉Yes - fire away!!!!!!!!!
I just ended up having to thump Joe over...
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
November 24, 2010 at 11:58 am
Start with the answers to Ninja's last questions.
I am curious to know how well it performs without your query hints?
Have you constructed out the entire Insert / Select statement using...
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
November 24, 2010 at 11:57 am
I have been bitten numerous times by installers expecting default locations. Just a simple change can help improve security. Although it may be a subtle change or a...
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
November 24, 2010 at 11:48 am
jcrawf02 (11/24/2010)
Should we point out that his view solution doesn't *just* give you the duplicates? 😉
Yes - fire away!!!!!!!!!
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
November 24, 2010 at 11:47 am
Viewing 15 posts - 11,611 through 11,625 (of 19,560 total)