Viewing 15 posts - 3,016 through 3,030 (of 19,560 total)
SQLKnowItAll (5/28/2014)
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 28, 2014 at 8:56 am
crookj (5/28/2014)
Ed Wagner (5/28/2014)
BWFC (5/28/2014)
GeeseHunting
:Wabbitt!
https://www.youtube.com/watch?v=jLeOtRf6_1g&feature=kp
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 28, 2014 at 8:44 am
jcrawf02 (5/28/2014)
Sean Lange (5/28/2014)
SQLRNNR (5/28/2014)
crookj (5/28/2014)
WotD - swollen (wrist)allergic
bee sting
epinephrin
Pen
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 28, 2014 at 8:18 am
Another vote for the RedGate SQL Compare tools.
Nice license plate Jason 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
May 28, 2014 at 8:17 am
Have you tried the following?
Change the left join here
LEFT JOIN EPSTransactions t on r.OrthoID = t.PatientID
to this
RIGHT JOIN EPSTransactions t on r.OrthoID = t.PatientID
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 28, 2014 at 8:14 am
Perfect.
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 28, 2014 at 7:59 am
crookj (5/28/2014)
WotD - swollen (wrist)
allergic
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 28, 2014 at 7:38 am
Have a look at these articles and see if they will help.
http://jasonbrimhall.info/2010/02/13/payperiod-ii/
Though the schemas are different, it seems to be the same general issue.
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 27, 2014 at 7:56 pm
MMartin1 (5/27/2014)
Keep a watch on the distributor's transaction log, make sure it doesn't fill to capacity or that will halt things.
That remark seemed to come from left field.
As per 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
May 27, 2014 at 7:53 pm
Here's an article from CSS on how to do that.
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 27, 2014 at 7:02 pm
Here's a quick and dirty script that seems to get what you want.
SET DATEFORMAT DMY
DECLARE @MarketShare TABLE (startdate DATE, rate INT)
INSERT INTO @MarketShare
...
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 27, 2014 at 1:25 pm
Please post your query with sample data and we can assist.
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 27, 2014 at 12:23 pm
Ed Wagner (5/27/2014)
crookj (5/27/2014)
BWFC (5/27/2014)
TomThomson (5/24/2014)
SQLRNNR (5/23/2014)
whereisSQL? (5/23/2014)
TomThomson (5/23/2014)
Revenant (5/23/2014)
Ed Wagner (5/23/2014)
SQLRNNR (5/23/2014)
Ed Wagner (5/23/2014)
crookj (5/23/2014)
Ed Wagner (5/23/2014)
BWFC (5/23/2014)
RingRule
Decree
Dictate
PotatoHead
Toy
Story
Board
Chalk
ongle
scratch
Fever
stranglehold
Tango
&Cash
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 27, 2014 at 10:55 am
sql-lover (5/27/2014)
GilaMonster (5/27/2014)
sql-lover (5/26/2014)
SQL Server does not hold statistics for table variables so row count is always 1.
Not actually true.
A good rule of thumb is picking table variables for small...
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 27, 2014 at 10:50 am
I too am curious why you are trying to eliminate the left joins.
I am also curious to see the full query and 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
May 27, 2014 at 10:35 am
Viewing 15 posts - 3,016 through 3,030 (of 19,560 total)