Viewing 15 posts - 3,106 through 3,120 (of 5,841 total)
patrickmcginnis59 (12/30/2011)
TheSQLGuru (12/30/2011)
December 30, 2011 at 1:23 pm
I would try dropping off the PK from the table variable (note you do NOT have a temporary table here - it is a table var with many things that...
December 30, 2011 at 10:17 am
Get a copy of the SQL Server MVP Deep Dives 2 book and read my chapter titled "Death by UDF" for some details on how devastatingly bad UDFs can be!!
December 28, 2011 at 8:34 am
1) I don't see where anyone asked this question so: WHY do you think you need/want partitioning at all? a few million rows per year is chump change unless...
December 22, 2011 at 12:57 pm
Sorry, but I am at a loss here. You are now dropping columns off of the T3 query. This is too complex (for me anyway) to help you...
December 14, 2011 at 12:01 pm
1) you still haven't provided what you think is the expected outcome for some set of rows that you think is giving you bad output.
2) your use of month-to-date is...
December 14, 2011 at 10:21 am
Dev (12/14/2011)
Ninja's_RGR'us (12/13/2011)
TheSQLGuru (12/13/2011)
...That would be one HELL of a typo! 8 extra characters that actually spell out 2 appropriate words!?! 😎
Go easy on the kid...
December 14, 2011 at 9:07 am
1) your last set of sample data seems to be missing the last 5 or 6 commas between the 'fields' of data.
2) you need to construct a SIMPLE set of...
December 14, 2011 at 8:53 am
Dev (12/13/2011)
chetanr.jain (12/13/2011)
sp_whoisactive == ?Does not seems to be familiar procedure.
can anybody post the code for this procedure.
Just a TYPO...
sp_who [ [ @loginame = ] 'login'...
December 13, 2011 at 12:55 pm
Unintended cartesian product is likely culprit here. You need to catch it while it is running however. sp_whoisactive can show you the currently executing query plan and statements...
December 13, 2011 at 7:20 am
Some of the worst things I have ever had to clean up at clients came from the unfettered use of DTA. Use it (without sufficient knowledge and thought) at...
December 12, 2011 at 6:42 pm
I will go with parameter sniffing too. BTW, next time you see this you do NOT have to bounce the box to clear it!! You can run this: ...
December 8, 2011 at 8:35 am
I have seen issues at clients where the prep/unprep stuff was a huge perf issue because it was getting called a bajillion times for stuff that was only executed ONCE!...
December 8, 2011 at 8:29 am
JamesMorrison (12/7/2011)
TheSQLGuru (12/7/2011)
1) The best option would be $10K worth of ME!!
I am sure you are a talented and entertaining personality, but I am not seeking to hire anyone....
December 7, 2011 at 4:38 pm
Altering the table to add the columns back in is going to be the first step I think. If you restore the most recent backup with the data in...
December 7, 2011 at 3:10 pm
Viewing 15 posts - 3,106 through 3,120 (of 5,841 total)