Viewing 15 posts - 5,386 through 5,400 (of 7,484 total)
Gianluca Sartori (9/20/2011)
SQL Kiwi (9/20/2011)
Ninja's_RGR'us (9/20/2011)
Try doing ;with () Without any select after the with and you'll see if the engine thinks the statement is complete ;-).
Ok:
WITH CHANGE_TRACKING_CONTEXT (0x)
MERGE...
September 20, 2011 at 7:21 am
SQL Kiwi (9/19/2011)
Evil Kraig F (9/19/2011)
Paul, remember when I mentioned in that other thread that Partitioning seems to be a Level III item? 🙂
Indeed. Perhaps we need more...
September 19, 2011 at 1:23 pm
Tom.Thomson (9/18/2011)
September 19, 2011 at 9:12 am
Powercut
----------
At about 9:20 this morning I discovered that the electricity supply was scheduled to be cut of for maintenance/enhancement work from 9:20 to 14:00.
Destroyed my schedule for today. ...
September 19, 2011 at 8:54 am
Ray K (9/19/2011)
Tom.Thomson (9/17/2011)
Ray K (9/16/2011)
Tom.Thomson (9/16/2011)
Ray K (9/16/2011)
Daniel Bowlin (9/16/2011)
ZoomSchwartz
(Let's see if anyone picks up on this!)
Bifigliano
Tom wins the prize!
The hard part was choosing between Bifigliano and Profigliano.
No-one else...
September 19, 2011 at 8:49 am
SQLRNNR (9/18/2011)
Catching up on a lot of old questions eh Tom?
SQLRNNR (9/18/2011)
Catching up on a lot of old questions eh Tom?
Yes - learning about bits that I haven't used yet...
September 19, 2011 at 8:25 am
Michael Valentine Jones (4/27/2011)
In any case, that will not guarantee a unique number, because two different sessions can run that code at the same time and get the same number.
And...
September 18, 2011 at 6:00 pm
Sean Lange (4/27/2011)
Not to mention that most servers have the time changed twice a year. Daylight saving time. :w00t:
Nor that the part that's supposed to be a 10 digit number...
September 18, 2011 at 5:43 pm
I don't like the answer here. Surely the right thing to do is rewrite the code that is doing the receives so that selects don't interfere with each other...
September 18, 2011 at 4:37 pm
Why no option for ALTER INDEX REBUILD WITH ONLINE = ON? Maybe I have an index which splits frequently and need to clean up splits that have propagated above...
September 18, 2011 at 1:04 pm
SQLRNNR (9/18/2011)
Tom.Thomson (9/17/2011)
Lynn Pettis (9/17/2011)
We are getting close. Who will be the lucky winner making the 30,000 post to The Thread???
Out of date Lynn, we are now going to...
September 18, 2011 at 12:49 pm
jarney (3/20/2007)
From BOL - Server Enhancements (SSAS)
<B>Multi-Instance Support</B>
Up to 50 <FONT style="BACKGROUND-COLOR: #316ac5" color=#ffffff>instances</FONT> of the <FONT style="BACKGROUND-COLOR: #316ac5" color=#ffffff>Analysis Services</FONT> service from Microsoft SQL Server 2005 Enterprise Edition...
September 18, 2011 at 12:06 pm
Drat, I read this as a licensing question (because it's utterly vacuous interpreted any other way, even though that word "database" muddies the waters somewhat). So I got it...
September 18, 2011 at 11:33 am
Actually you can't use DESX either. If you ask for DESX you get Triple DES with a 168 bit key (MS claims it's 192 bits; I don't believe them,...
September 18, 2011 at 11:12 am
Given that the provider side has to be configured to allow ad hoc access and that this connect item is still outstanding after four and a half years, people might...
September 18, 2011 at 10:46 am
Viewing 15 posts - 5,386 through 5,400 (of 7,484 total)