Viewing 15 posts - 4,861 through 4,875 (of 8,416 total)
lmu92 (3/25/2010)
Now that we know the downsides of either of the two options the answer regarding the method to use is a lot easier: "It depends" 😀 :w00t:
As always* 😉
March 25, 2010 at 10:04 am
Kevin Bullen (3/25/2010)
I'm still going to poke around a bit and understand why it runs differently in dev and prod.
Trace.
March 25, 2010 at 9:54 am
Grant Fritchey (3/25/2010)
March 25, 2010 at 9:53 am
There's no real harm in doing what they are asking, so it's hard to come up with a compelling argument not to do it.
My best shot would probably be to...
March 25, 2010 at 9:49 am
Grant Fritchey (3/25/2010)
March 25, 2010 at 9:31 am
Seeing as an INSTEAD OF trigger is already being used, another option is:
USE tempdb;
CREATE TABLE dbo.Test
(
...
March 25, 2010 at 9:05 am
stroebele (3/25/2010)
March 25, 2010 at 8:41 am
Improved recursive solution:
WITH [Recursive]
AS (
SELECT TOP (1)
...
March 25, 2010 at 8:38 am
The Dixie Flatline (3/25/2010)
I'm about to start through Itzik Ben-Gan's "T-SQL Querying".
It's not in there 🙁
Something I read on one of the SQL Server Team blogs once upon a time....
March 25, 2010 at 8:27 am
The Dixie Flatline (3/25/2010)
I expect that one day they will refine the optimizer to the point where knows to do that with MIN() too.
That's called a loose index scan. ...
March 25, 2010 at 8:10 am
Fishbarnriots (3/25/2010)
...it seems that even if opening a stored proc using "Modify", then closing, if repeated 100+ times, same result.
It would surprise me if that were the case, since the...
March 25, 2010 at 7:39 am
The Dixie Flatline (3/25/2010)
Tell me you have a life outside SQL.
(0 row(s) affected)
March 25, 2010 at 7:35 am
Eric Zierdt (3/25/2010)
...so looks like I don't have READ_COMMITTED_SNAPSHOT enabled.
Ok, cool. One less thing to worry about. I am a fan of RCS, but you do have...
March 25, 2010 at 7:33 am
The Dixie Flatline (3/25/2010)
I still don't understand why the obvious query is unacceptable.
select assetID, min([date])
from t1
where [date] < inceptionDate
group by assetID
You have dealt with the 'Senior Software Engineer' before, right?...
March 25, 2010 at 7:25 am
Viewing 15 posts - 4,861 through 4,875 (of 8,416 total)