Viewing 15 posts - 121 through 135 (of 715 total)
Ez question 4 me, as I am doing this staff a lot in my environment.
June 16, 2015 at 5:54 am
Now we all agree that the 1st row will be inserted & there is absolutely nothing in the code will disable the indexes, so the next question is: "When we...
June 10, 2015 at 5:25 am
Mauricio_ (6/10/2015)
I wanted to have all green checks in my QOTD list and now I've got a red cross!
You will get used to this 😛
June 10, 2015 at 5:20 am
ArnoKwetters (6/8/2015) How can you see then that the primairy key index has been disabled ?
In the Message pane when you execute the Index disable code.
June 8, 2015 at 2:18 am
TjhomasH6610 (6/3/2015)
On SQL 2012 I get script B before and after inserting the data.
Same here.
June 4, 2015 at 2:17 am
Thanx 4 the ez question, the options made it more easier.
June 2, 2015 at 11:55 pm
Nice question, I don`t remember I had the need to use FORMAT before, thanx.
June 2, 2015 at 12:50 am
I have no idea about this, never used this utility before, so learned somthing new today, thanx.
June 1, 2015 at 11:59 pm
OK, the author should have (like all other QotD) mention to select 2 answers, still it`s a very good question.
Thanx.
May 26, 2015 at 1:58 am
TomThomson (5/22/2015)
Good question. But the answer doesn't seem to cover all the places a global cursor is available where a local one wouldn't be.
+ 1
May 25, 2015 at 12:08 am
Viewing 15 posts - 121 through 135 (of 715 total)