Viewing 15 posts - 4,111 through 4,125 (of 8,416 total)
CirquedeSQLeil (4/6/2010)
Nice question Paul.
1. Did you get it right?
2. Are you scared by the behaviour ANSI_NULLS OFF?
April 6, 2010 at 10:10 pm
CirquedeSQLeil (4/6/2010)
...Master and Model should not be very big. MSDB might get some weight to it (but still kind of small). I move them personally for consistency.
It is...
April 6, 2010 at 9:58 pm
CirquedeSQLeil (4/6/2010)
I really thought the thread would surpass 14k today.
Probably will - though the definition of 'today' varies...;-)
Eight hours of 7th April 2010 remain (local time).
April 6, 2010 at 9:54 pm
Jeff Moden (4/6/2010)
VERY clever. Seriously.
Thanks! :blush:
I have my moments...and you are a pain for making me spend half an hour finding that optimization!
Just kidding - I loved the challenge,...
April 6, 2010 at 9:34 pm
Query the sys.database_recovery_status system view.
The last_log_backup_lsn column will be NULL for a database that has not had a full back up
to start the log restore sequence.
SELECT database_name =...
April 6, 2010 at 8:59 pm
There seem to have been a rash of questions on the forums recently about how best to convert strings to dates in the database. Invariably, the thread features a...
April 6, 2010 at 8:53 pm
If the tables are different sizes, all bets are off. Different cardinality (row count) estimates, and statistics might lead to a different query plan - SQL Server might transition...
April 6, 2010 at 8:46 pm
CirquedeSQLeil (4/6/2010)
Thanks Paul for this suggested workaround.
Hey, thanks for mentioning it! 12th March I posted that - seems much longer ago for some reason...?!
April 6, 2010 at 8:26 pm
Jeff Moden (4/6/2010)
Thanks for the links, Paul. From what I've read in those links, it looks like SQL Server is using type 4, the random based values.
NEWID uses version...
April 6, 2010 at 8:23 pm
Marts (4/6/2010)
April 6, 2010 at 8:16 pm
Jeff Moden (4/6/2010)
Maybe this will help you to understand why the code you posted does suffer from the same problem even given the index provided.
Consider this code my apple sauce...
April 6, 2010 at 8:08 pm
Peter Brinkhaus (4/6/2010)
It's unclear to me why defining the function WITH SCHEMABINDING would make it deterministic.
The reason is that the engine only evaluates a function for determinism if it is...
April 6, 2010 at 6:52 pm
YSLGuru (4/6/2010)
April 6, 2010 at 6:12 pm
bobmclaren
My next option is to just use permanent tables. But if I'm filling and clearing them every 30 seconds, I'm going to end up with a huge transaction log.
Load...
April 6, 2010 at 5:57 pm
Peter Brinkhaus (4/6/2010)
To me it seems MS has reinvented its own definition of (non-)determinism. Given the MS definition, even GETDATE() would be a deterministic function, if only for 3ms.
I don't...
April 6, 2010 at 5:31 pm
Viewing 15 posts - 4,111 through 4,125 (of 8,416 total)