Viewing 15 posts - 241 through 255 (of 371 total)
I didn't test the answer but I knew the following:
#2: UNION is not allowed to be used that way;
#3: That's not enough and will make things worse as every col1...
October 23, 2011 at 10:59 am
GilaMonster (10/22/2011)
Depends on the size of the database, maintenance window length, restore requirements and a few other things.
I see what you mean.
Every situation is unique and must be analyzed properly....
October 22, 2011 at 12:49 pm
That's probably the best article I have read about transaction logs.
Can't believe I missed it before.
Thank you for sharing.
Best regards,
October 21, 2011 at 9:02 pm
Interesting discussion.
Would the Full-Diff-Log backup method be recommended over the Full-Log method or it depends on the size of the database? I'm asking because I have seen both methods like...
October 21, 2011 at 8:31 pm
Britt Cluff (10/21/2011)
Thanks for the question. What's the point in using TOP in a view?
I wonder that too since the result may be different in each SELECT of the view.
Maybe...
October 21, 2011 at 6:31 am
Ha. Got it right. And it was a tricky question. 😛
But a great one about a somewhat confusing subject (the ORDER BY, in that case, belongs only to the data...
October 21, 2011 at 4:11 am
Scott Levy (10/20/2011)
Andre, both PC's are connecting to the same database on the server and as far as I know they are both running the same version of Management Studio.
Sorry...
October 20, 2011 at 8:55 pm
This seems to be a parsing error and I don't think it has to do with SSMS as it's just a GUI (frontend) and it doesn't have control over query...
October 20, 2011 at 7:51 pm
I see. 🙂
It'd be nice to see the actual code though to see if there's a problem with different database compatibility levels.
Best regards,
October 20, 2011 at 5:50 pm
I have never seen such thing in T-SQL before.
Are you sure it's running properly on one of your PCs?
Best regards,
October 20, 2011 at 5:27 pm
You could also use WHERE NOT EXISTS with a similar query like Sean's code.
Best regards,
October 20, 2011 at 8:55 am
ChrisM@Work(10/13/2011)
October 13, 2011 at 5:35 am
You could try running a test example using the estimated execution plan button and the percentage taken by each method. I can tell you that the single UPDATE affecting several...
October 13, 2011 at 5:16 am
vk-kirov (10/10/2011)
codebyo (10/10/2011)
After the EXCEPT, only the number 4 remains. So where...
October 11, 2011 at 5:33 am
That looks and executes right... but I can't understand why the result is not only the number 4.
After the EXCEPT, only the number 4 remains. So where does that 5...
October 10, 2011 at 9:55 pm
Viewing 15 posts - 241 through 255 (of 371 total)