Viewing 15 posts - 14,071 through 14,085 (of 19,560 total)
GITCA
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
May 12, 2010 at 10:38 am
crookj (5/12/2010)
In May - WOTD - Global Warming!
Joe
Naturally - where else would the icebergs go?
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
May 12, 2010 at 10:37 am
Steve Jones - Editor (5/12/2010)
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
May 12, 2010 at 8:46 am
Nice one, keep em coming.
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
May 12, 2010 at 12:06 am
I recommend you hire a consultant to help you with it. The compensation plan, IMO, would be best done in a .Net language. The PV calculation would need...
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
May 12, 2010 at 12:04 am
In the very same document that is used as a source there is reference to using 2005 in Peer to Peer replication.
Also when searching on the topic, the MS edition...
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
May 12, 2010 at 12:00 am
The code for which one of those areas that I listed?
Can you provide samples of what you have done so far?
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
May 11, 2010 at 11:51 pm
Are you looking to build the compensation plan, just calculate PV, or build the binary tree? Or are you looking for somebody to do all of that for you?
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
May 11, 2010 at 11:39 pm
Without seeing the actual query it is still an it depends scenario for me. The word complex is a subjective one. It depends on level of experience and...
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
May 11, 2010 at 11:31 pm
NJ-DBA (5/11/2010)
nope- no where clause. Just "select top 1 * from table"... that's it.
K - thanks
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
May 11, 2010 at 5:32 pm
What account is your SQL Agent service running under? Network Service or something else?
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
May 11, 2010 at 5:26 pm
Do any of those statements use a where clause in them?
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
May 11, 2010 at 5:24 pm
I think this is a classic it depends kind of answer. A lot will depend on requirements and your environment.
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
May 11, 2010 at 4:46 pm
lmu92 (5/11/2010)
CirquedeSQLeil (5/11/2010)
...As for the select top 1 *, the application may be doing that in order to populate a data grid with the column names.
...
If that's the only purpose...
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
May 11, 2010 at 4:42 pm
What is the query you use to determine the IO of these queries. Some DMVs are cumulative in nature and thus could be skewing the numbers.
As for the select...
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
May 11, 2010 at 4:34 pm
Viewing 15 posts - 14,071 through 14,085 (of 19,560 total)