Viewing 15 posts - 5,011 through 5,025 (of 5,590 total)
Very good article David.
One area where I find INTERSECT / EXCEPT easier to work with is when dealing with multiple columns, such as what you might find for a PK....
July 19, 2009 at 9:29 am
Gianluca Sartori (7/17/2009)
July 17, 2009 at 11:03 am
Gianluca Sartori (7/17/2009)
WayneS (7/16/2009)
I find this theory interesting, since the columns that are in the where clause are not in the tables that are producing scans.
It doesn't matter, the optimizer...
July 17, 2009 at 2:19 am
You've given us almost no information with which to help you. What is the error message? What are the scripts? How are you trying to call them from sqlcmd? Since...
July 17, 2009 at 2:15 am
Out of curiousity, what was your solution?
July 16, 2009 at 9:15 pm
Lamprey13 (7/16/2009)
On Instructor try...
July 16, 2009 at 6:35 pm
Jack Corbett (7/16/2009)
I wonder if you might be better off breaking it down into some steps using temp tables.
Jack, I see we're thinking alike here...
You reference the transaction_update...
July 16, 2009 at 8:48 am
Gianluca Sartori (7/16/2009)
The scan is due to the OR to include NULL values for processed_flag and reviewed. Using ISNULL or...
July 16, 2009 at 8:30 am
info (7/13/2009)
Thank you for your help.I will try what you mentioned.
When you say "your text file", would that be my table name?
No, that means some text file...
July 15, 2009 at 2:55 pm
Actually, it will number the existing rows in physical order starting at the seed, which you have specified to be 1.
Try this out for an example:
CREATE TABLE #tmp (TextData varchar(max))
BULK...
July 13, 2009 at 9:02 pm
GSquared (7/13/2009)
Table variables are always estimated as if they were going to only have 1 row in them. That will give you a very false low on the cost,...
July 13, 2009 at 5:59 pm
meo2 (7/13/2009)
I am trying to execute a paramtrized stored procedure, it works fine when @IncludeDeleted = 1
but it gives an error message when it is set to 0
"Msg 137,...
July 13, 2009 at 5:41 pm
July 11, 2009 at 10:14 pm
why weren't they destroyed when the stored proc completed on the 2nd July. Even if the proc bombed out with an error I would have thought the local temp table...
July 11, 2009 at 7:08 pm
Lowell (7/11/2009)
stick in the master database, and because it starts with "sp_" and uses the catibility views, it will be...
July 11, 2009 at 6:59 pm
Viewing 15 posts - 5,011 through 5,025 (of 5,590 total)