Viewing 15 posts - 1,666 through 1,680 (of 8,416 total)
Toreador (9/20/2011)
Learned something new - not sure how useful it is to know, but these things are always interesting 🙂
It depends. The average DBA can get by perfectly well...
September 20, 2011 at 9:53 am
September 20, 2011 at 9:41 am
Kiara (9/20/2011)
Ninja's_RGR'us (9/20/2011)
Well now you can actually sell this as deep dive training! 😀
*groan* Are we going to be drowning in puns now?
It's sink or swim on The Thread today.
September 20, 2011 at 7:56 am
L' Eomot Inversé (9/20/2011)
September 20, 2011 at 7:31 am
Gianluca Sartori (9/20/2011)
That was nasty! I know very few people that can read that query and guess what it does.
There might be other ways to construct a "WITH ()" that...
September 20, 2011 at 6:26 am
Ninja's_RGR'us (9/20/2011)
Obviously I wasn't clear in my writing (for a change :-D).
You were perfectly clear - I deliberately chose to misinterpret you. On the subject of MERGE:
WITH CHANGE_TRACKING_CONTEXT (0x)
MERGE...
September 20, 2011 at 6:24 am
Brandie Tarvin (9/20/2011)
And yet the engine complains if I don't have any previous statement that have a ';' and don't put one before the WITH.
I was going to reply but...
September 20, 2011 at 6:20 am
Ninja's_RGR'us (9/20/2011)
I was going more for select or dml.
MERGE will be very upset to hear it's not DML :pinch:
But yes, I know what you had in mind - it just...
September 20, 2011 at 6:10 am
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 master.dbo.spt_values AS A USING...
September 20, 2011 at 6:02 am
Brandie Tarvin (9/20/2011)
CTEs (i.e. ;WIth () ... SELECT ) are single statements in this context, yes?
Yes - most solutions to past challenges use CTEs extensively. Some would say to...
September 20, 2011 at 5:44 am
hakan.winther (9/20/2011)
codebyo (9/17/2011)
I'd love to see an article showing a real world application of switching partitions.
Partitioning and switching is excellent for archiving and for loading new data into a datawarehouse,...
September 20, 2011 at 2:52 am
SQLRNNR (9/19/2011)
Thanks for another superb question Paul.
Thanks for leaving a comment - I had completely forgotten this was scheduled for today!
September 19, 2011 at 10:33 pm
bitbucket-25253 (9/19/2011)
Chad what adds to my confusion is items like:Checkpoint will cause the log buffer to be flushed to disk (the current set of un-hardened log records).
Checkpoint calculates the minimum...
September 19, 2011 at 5:00 pm
To answer your question from The Thread, and a couple of points from your last post, run something like this:
USE Sandpit -- A database in SIMPLE recovery!
CHECKPOINT
SELECT * FROM sys.fn_dblog(NULL,...
September 19, 2011 at 4:47 pm
Jeff Moden (9/19/2011)
I do. As a matter of fact, it's in the link you posted.
The only bit I could find was this:
Columns are rolled up from right to left....
September 19, 2011 at 3:49 pm
Viewing 15 posts - 1,666 through 1,680 (of 8,416 total)