Viewing 15 posts - 20,071 through 20,085 (of 22,202 total)
This will work with 2000:
SELECT
A.RetailerID,
b.RetailerIDTheirs
FROM TableA AS A
LEFT JOIN TableB AS B
ON A.RetailerID =...
June 24, 2008 at 9:22 am
The short and long answer in this case is, it depends.
There are a lot of variables involved in this sort of thing and the right answer in one case isn't...
June 24, 2008 at 8:39 am
Only 62 tables. We had one that was 85 and we got it to run in under 2 seconds (of course, it took 12 minutes to recompile).
But seriously, everyone else...
June 24, 2008 at 5:35 am
I'm not sure this is what you're looking for, but maybe using the OUTPUT clause?:
INSERT INTO Person
OUTPUT PersonId INTO #Temp
.....
June 24, 2008 at 5:28 am
There's not really fine-grained control that will allow you to manipulate the cache in that manner. I have heard of a number cache problems with the release version and SP1....
June 24, 2008 at 5:23 am
Excellent. Thanks for reporting back what worked.
June 24, 2008 at 5:12 am
It's a general rule that you should have a clustered index on every table (there are exceptions and exceptions to the exceptions). For detailed discussion of why this is so,...
June 23, 2008 at 9:52 am
Yes, that's true. It won't help you bury the bodies. In fact, it usually digs them up, like a dog. Traitors!
June 23, 2008 at 8:29 am
Sounds like it could be parameter sniffing. Check the execution plans to see if they're changing between the non-parameratized values and the parameratized values. You can try a couple of...
June 23, 2008 at 8:19 am
And, deadlocks are an error that can be captured with a TRY/CATCH statement in TSQL. You can try resubmitting the query a certain number of times before you finally give...
June 23, 2008 at 8:12 am
The proc cache is your bestest buddy. Why on earth do you want it cleared out all the time? What problem are you trying to solve?
June 23, 2008 at 8:10 am
Gail's 100% on the money here.
If you just look at the differences you can see why. A view is simply a select statement kept around in a way that sort...
June 23, 2008 at 8:07 am
Just to take a slightly contrarian point of view.
We did a lot of testing and found, depending on the number of columns and the type of data in a table,...
June 23, 2008 at 8:02 am
Shiraz (6/23/2008)
June 23, 2008 at 7:10 am
I get into work at 7AM. That gives me a good hour and a half before other people start coming in. It's the only way I know to get a...
June 23, 2008 at 6:23 am
Viewing 15 posts - 20,071 through 20,085 (of 22,202 total)