Viewing 15 posts - 2,026 through 2,040 (of 18,926 total)
From your last message I assume that you have seen the command in profiler sent from either BIDS or SSRS.
Please paste it here.
P.S. You won't see the full query of...
October 14, 2011 at 10:05 am
The only thing I have in mind is that you're limited to only 1 table at a time for this setting. So maybe something else is left set to...
October 14, 2011 at 10:03 am
Lowell (10/14/2011)
maybe this?
SELECT table1.column4,
table2.column5
FROM ...
October 14, 2011 at 9:54 am
What code did you try?
If you do left join on AND = 2 it should do exactly what you need.
October 14, 2011 at 9:47 am
pwalter83 (10/14/2011)
Ninja's_RGR'us (10/13/2011)
Check up that series, might give you great pointers :
This is getting out of hand now, I am unable to find the particular piece of code in...
October 14, 2011 at 9:21 am
98% of the people here have never used Oracle. I personally have no idea what this syntaxe does.
Can you show us a little sample data and the required output?...
October 14, 2011 at 9:04 am
Dev @ +91 973 913 6683 (10/14/2011)
The day goes by :
get up
go to work
Get back home (hopefully the same day).
Not everyday... Only on QA deployment, Staging Deployment &...
October 14, 2011 at 9:02 am
This is what Gail has in mind :
http://sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx
This is where I'd go next for an overall health check (not specific to this problem).
http://www.brentozar.com/blitz/
And here's the 2.5 hours video that...
October 14, 2011 at 8:28 am
adlakha.22 (10/14/2011)
Your query worked great when I tried with distinct.But still its taking 83 Seconds to execute.
Do you have any other idea to make it more optimize.
Thanks in advance
Post the...
October 14, 2011 at 7:07 am
SwayneBell (10/14/2011)
I don't know if that's just in Canada or not, so to be on the...
October 14, 2011 at 7:05 am
steveb. (10/14/2011)
Ninja's_RGR'us (10/14/2011)
When's the last time you walked into an office with less than 1 computer per user??? Or even 1 computer overall?
1 computer with SQL tools? ...
October 14, 2011 at 6:44 am
steveb. (10/14/2011)
but i always feel that if people...
October 14, 2011 at 6:35 am
steveb. (10/14/2011)
Dev @ +91 973 913 6683 (10/14/2011)
So you can't just make a single login, give it to 3 or 100 persons and just buy 1 cal.
Many...
October 14, 2011 at 6:25 am
Dev @ +91 973 913 6683 (10/14/2011)
That way you pay nothing in extra license fees, but you can possibly pack anoter 1000 users on there.
I didn't get quoted...
October 14, 2011 at 6:22 am
Viewing 15 posts - 2,026 through 2,040 (of 18,926 total)