Viewing 15 posts - 8,506 through 8,520 (of 19,560 total)
8reat1s (9/27/2011)
Thats spot on
and very clever
should have though about that
the other thing which i noticed is
when i am trying to find the firstday of the week for 04/09/2011...
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
September 27, 2011 at 11:13 pm
What is happening when you include that where clause that is not to your expectation?
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
September 27, 2011 at 10:58 pm
Does trg have permissions into the master database?
I would get rid of the execute as 'trg' in that trigger.
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
September 27, 2011 at 10:54 pm
Definitely worth knowing
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
September 27, 2011 at 10:00 pm
isuckatsql (9/27/2011)
SQLRNNR (9/27/2011)
hmmm...Could you possibly provide DDL and some sample data?It would be handy in trying to recreate and provide a better solution.
The problem only occurs with large volumes of...
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
September 27, 2011 at 8:40 pm
You could also issue a print statement with each param you want to see.
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
September 27, 2011 at 5:49 pm
Best answer would come direct from Microsoft. Based on my dealings, the answer is you still have to buy the Enterprise license at full price.
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
September 27, 2011 at 5:48 pm
hmmm...Could you possibly provide DDL and some sample data?
It would be handy in trying to recreate and provide a better solution.
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
September 27, 2011 at 5:41 pm
GilaMonster (9/27/2011)
From permanent tables to global temporary tables. That's going to give you even more fun race-conditions and incorrect results if multiple of those queries are run concurrently.
Dang - Gail...
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
September 27, 2011 at 5:36 pm
Rather than a global temp table (e.g. ##temptable), use a single # for your temp tables.
Also, you might want to figure out a method to rank your results. 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
September 27, 2011 at 5:35 pm
Evil Kraig F (9/27/2011)
I don't.
On a side note, looks...
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
September 27, 2011 at 4:39 pm
GSquared (9/27/2011)
The Active Threads link is only showing 5 other discussions.
(Probably my fault for going political in here. ...
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
September 27, 2011 at 2:13 pm
Evil Kraig F (9/27/2011)
SQLRNNR (9/27/2011)
Evil Kraig F (9/27/2011)
Trey Staker (9/27/2011)
Did you hear that Itzik Ben-Gan is teaching an advanced t-sql class here in Phoenix the week after pass? It's...
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
September 27, 2011 at 1:37 pm
Please post the actual execution plan.
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
September 27, 2011 at 12:56 pm
Evil Kraig F (9/27/2011)
Trey Staker (9/27/2011)
Did you hear that Itzik Ben-Gan is teaching an advanced t-sql class here in Phoenix the week after pass? It's really pricey but I...
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
September 27, 2011 at 12:53 pm
Viewing 15 posts - 8,506 through 8,520 (of 19,560 total)