Viewing 15 posts - 1,186 through 1,200 (of 9,643 total)
It could change because the Query Optimizer changed the execution plan and is applying the CAST within the JOIN before the WHERE clause.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 9, 2013 at 11:16 am
You can create user databases on an SSRS SQL server instance if you want and if the server has the resources for it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 9, 2013 at 11:11 am
Something like this would work:
With units AS
(
Select Distinct
unit
FROM
dbo.Full_Referrals_Dataset_live
)
SELECT
count(FR.[Unit]) as Actual,
U.unit,
FR.[1st_of_month],
FR.[last_of_month]
FROM
units as U LEFT JOIN
dbo.Full_Referrals_Dataset_live as FR
WHERE
FR.RfR1 = '18 month project'
GROUP BY
U.unit,
FR.[1st_of_month],
FR.[last_of_month];
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 9, 2013 at 11:09 am
According to BOL:
2.After adding an article to a publication, you must create a new snapshot for the publication (and all partitions if it is a merge publication with parameterized filters)....
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 9, 2013 at 10:54 am
Grant Fritchey (10/7/2013)
Jack Corbett (10/7/2013)
GilaMonster (10/7/2013)
Jack Corbett (10/7/2013)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 7, 2013 at 9:22 am
GilaMonster (10/7/2013)
Jack Corbett (10/7/2013)
I actually had a recruiter contact me about a contract in NYC with a title of Data Architect that they wanted to pay 45/hr for.
That's...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 7, 2013 at 7:47 am
Grant Fritchey (10/7/2013)
Jack Corbett (10/7/2013)
Jeff Moden (10/5/2013)
Speaking of "unbelievable", is [font="Arial Black"]THIS[/font] all that a Master's degree + the ability to walk on water is worth nowadays?
In some...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 7, 2013 at 7:44 am
Jeff Moden (10/5/2013)
Speaking of "unbelievable", is [font="Arial Black"]THIS[/font] all that a Master's degree + the ability to walk on water is worth nowadays?
In some parts of the country that probably...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 7, 2013 at 7:10 am
sam bryant (10/3/2013)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 4, 2013 at 6:51 am
WayneS (10/3/2013)
Who is going to the Summit this year? (I need to figure out who to meet up with...)
I'm planning on being there. Of course I have had years...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 3, 2013 at 11:29 am
javierrunto (10/3/2013)
Thanks for your answer, could you tell me how to do or a place to find the answer? thanks
http://technet.microsoft.com/en-us/library/ms159272(v=SQL.105).aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 3, 2013 at 9:51 am
sam bryant (10/3/2013)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 3, 2013 at 9:49 am
Glenn's script is pretty good and I also like Brent Ozar Unlimited's sp_BlitzIndex.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 3, 2013 at 9:29 am
Could be a bad parameter sniffing issue where the cached plan was really only the best plan for the initial parameters passed in.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 3, 2013 at 9:27 am
Yes. Your biggest issue will be security.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 3, 2013 at 9:24 am
Viewing 15 posts - 1,186 through 1,200 (of 9,643 total)