Viewing 15 posts - 7,321 through 7,335 (of 15,381 total)
Donnie Carvajal (8/1/2013)
Would you suggest adding the Update Statistics Task to my maintenance plan that backs up the full database every night?
That may be a waste of effort to do...
August 1, 2013 at 3:07 pm
Donnie Carvajal (8/1/2013)
BTW, all...
August 1, 2013 at 2:47 pm
Alvin Ramard (8/1/2013)
Sean Lange (8/1/2013)
jbalbo (8/1/2013)
Thanks Sean.. good ideaIts one thing I think I do get..
At least I think I do.. lol
It is exactly like a left join....only backwards....
August 1, 2013 at 2:45 pm
riya_dave (8/1/2013)
Member primarycondition primaryintensity secondarycondition secondaryIntensity
M2345 hf ...
August 1, 2013 at 2:36 pm
Looks like Lowell beat me to a response again. At least his more detailed and earlier than mine. 😀
August 1, 2013 at 2:34 pm
Donnie Carvajal (8/1/2013)
Thanks again.Is the goal to get the actual number of rows and estimated number of rows to be equal?
Donnie
An exact match is not necessary. In fact, it is...
August 1, 2013 at 2:32 pm
jbalbo (8/1/2013)
Thanks Sean.. good ideaIts one thing I think I do get..
At least I think I do.. lol
It is exactly like a left join....only backwards. 😛
August 1, 2013 at 2:27 pm
Donnie Carvajal (8/1/2013)
Here is the .sqlplan for the one of the queries that I anticipate may be causing a bottle neck as it is referenced on every request.
Unless I am...
August 1, 2013 at 1:53 pm
Lowell (8/1/2013)
your sample headers had five columns, but the data only appears in three.
how is anyone supposed to be able to use that?
i...
August 1, 2013 at 1:50 pm
riya_dave (8/1/2013)
this is my DDLcreate table member
(memberid int,
primarycondition varchar(50),
PrimaryIntensity int,
secondarycondition varchar(50),
Secondaryintensioty int)
sample data i already provided in my previous thread
I am not a paid employee of this site. I do...
August 1, 2013 at 1:49 pm
Also, you might consider reversing your code and making this a left join. Many people struggle with the concept of a right join because it is backwards for most people.
August 1, 2013 at 1:11 pm
I have tried to help you on so many threads and once again you haven't posted any details. If you would actually post ddl and sample data along with the...
August 1, 2013 at 1:09 pm
Durai Samuel (8/1/2013)
For full information about primary keyplease view the below link
Please note that this is thread is 6 years old. I did however head over and read the link...
August 1, 2013 at 1:03 pm
Donnie Carvajal (8/1/2013)
Thanks for the quick responses. What is a .sqlplan? Is it the estimated execution plan from ssms?
The estimated plan could be saved as a .sqlplan just...
August 1, 2013 at 12:53 pm
You could also use PARSENAME for this.
select PARSENAME(Value, 2) as FirstPart, PARSENAME(Value, 1) as SecondPart
from #mytable
August 1, 2013 at 12:49 pm
Viewing 15 posts - 7,321 through 7,335 (of 15,381 total)