Viewing 15 posts - 19,036 through 19,050 (of 19,560 total)
It could very well be a large project. However, it could prove very useful. If it could ensure accurate testing, reduce development time due to an environment more...
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, 2009 at 10:40 am
Nice Article
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, 2009 at 10:37 am
Lowell (11/24/2009)
I simply...
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, 2009 at 10:30 am
What version of BackupExec? Is BE updated to the latest patch?
Those pieces of information are also necessary to try to find a matching resolution 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
November 24, 2009 at 10:26 am
Thanks for the update. Glad I could be of some help.
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, 2009 at 10:06 am
Definitely agree with the others - thanks Bob for taking that initiative.
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, 2009 at 10:01 am
Lemon
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, 2009 at 9:57 am
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
The site has a script and a discussion about it.
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 23, 2009 at 4:50 pm
I setup some tables with test data based on your query
minor change
, ROW_NUMBER() OVER (Partition by e.emp_code ORDER BY SUM(are2.balance) DESC ) AS [Rank]
This might be a little closer to...
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 23, 2009 at 3:42 pm
Bob,
Why not make it 3? I can review it too if you want a 3rd set of eyes.
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 23, 2009 at 3:39 pm
You should be able to manipulate the query to be able to get your desired results.
The idea of the CTE is to make the code more readable and less complex....
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 23, 2009 at 12:04 pm
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 23, 2009 at 11:59 am
Grant Fritchey (11/23/2009)
john.arnott (11/23/2009)
I'd always heard that Irish Coffee was the perfect food as it comprises all of the major food groups:Alcohol
Sugar
Caffeine
I can't help myself
Where's the beef?
It's what's for...
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 23, 2009 at 11:38 am
sorry about that
missed one line
LEFT JOIN employees e ON are2.emp_code = e.emp_code
WHERE are2.client_code = core.client_code
should be
LEFT JOIN employees e ON...
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 23, 2009 at 11:34 am
have you verified that gzip is installed on his computer with the same path that is showing in the package?
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 23, 2009 at 11:26 am
Viewing 15 posts - 19,036 through 19,050 (of 19,560 total)