Viewing 15 posts - 1,741 through 1,755 (of 8,416 total)
Brandie Tarvin (8/26/2011)
And are you saying that using the...
August 26, 2011 at 6:31 am
A good question, though the example was more complex than it needed to be.
August 25, 2011 at 9:11 pm
Jack Corbett (8/25/2011)
August 25, 2011 at 7:18 pm
Hi Jack,
This is a horrible ROLLBACK bug, a bit like the one Remi found a week or so ago. Well ok so it's more of a plan caching bug...
August 25, 2011 at 7:11 pm
madonl (8/24/2011)
I should have googled before posting my question, the answer is already out there. Denali doesn't support UDAs with the Over clause. Oh well.
You can vote for Bob's connect...
August 25, 2011 at 5:40 am
Andrew Watson-478275 (8/24/2011)
Paul - that's exactly what I did when BOL didn't quite give enough information to answer. I agree with your view on the 2 point question...
No worries...
August 24, 2011 at 4:36 am
Tom.Thomson (8/24/2011)
Isn't the inability to apply the loop hint to a right join a bit bizarre though?
I would normally answer this, but today's question is one of three... 😉
Question 2...
August 24, 2011 at 4:34 am
Andrew Watson-478275 (8/24/2011)
There would have been less guesswork involved if the full error message had been given instead of just an extract
You can get the full error text without running...
August 24, 2011 at 3:30 am
David Burrows (8/23/2011)
I found this interestingdrop procedure sp_one
go
drop procedure sp_one
go
will drop the procedure in test2 and master
You're right, that is interesting. It makes sense, but I had never tried...
August 23, 2011 at 7:37 am
Jeff Moden (8/21/2011)
Understood but does that actually reduce the round trips to the server?
I suppose it might, since the request is likely to fit into fewer packets.
August 21, 2011 at 6:05 pm
Jeff Moden (8/20/2011)
August 20, 2011 at 9:51 pm
Remi,
You had convinced me that I was demonstrating a related problem, and not the exact one you are seeing in your database, so I created a Connect item of my...
August 18, 2011 at 10:09 pm
Ninja's_RGR'us (8/18/2011)
Only 1 problem @SqlWiki, [DateHistorique_fin] is not the leading column, it's the 2nd of 3 columns being changed from NOT NULL to NULLable.
Well there you go, I thought I...
August 18, 2011 at 7:39 pm
Ninja's_RGR'us (8/18/2011)
Please post your results with the version(s) you tested on.
Added my contribution.
August 18, 2011 at 3:09 pm
When snapshot isolation is on, SQL Server makes a mess of the logging when changing the NULLability of the leading key column of a compound clustered index, causing error 3316...
August 18, 2011 at 3:08 pm
Viewing 15 posts - 1,741 through 1,755 (of 8,416 total)