Viewing 15 posts - 7,576 through 7,590 (of 59,072 total)
Thanks! Would this work for whole db rather than individual table? How about Primary keys and clustered index?
You've got to be really careful about disabling any PK or UNIQUE...
March 10, 2020 at 12:26 am
No... you still have the LSN problem.
March 10, 2020 at 12:09 am
As a bit of a side bar, I'm always amazed when someone says they have a shedload of servers but no money to actually support them. It just doesn't make...
March 10, 2020 at 12:07 am
>> your examples didn't have a join in - they were single table selects <<
If you've done a good job with your schema, then they will be a lot...
March 9, 2020 at 11:25 pm
Sure... just like I said over on SQLTeam.com...
To be honest, there is no completely reliable method to ensure that you don't delete stored procedures that are being used.. Consider the...
March 9, 2020 at 2:51 pm
Considering that it took almost 3 decades for them to get their fingers out of their ears on a true CSV format, I'll say "good luck with that submittal" David.
March 9, 2020 at 2:47 pm
wait until you get an application that wants to create sql agent jobs and then delete them after. not a hope in hell stopping that process running as SA
we...
March 9, 2020 at 2:19 pm
Dear Jeff,
Thank you for kind help!
I quite agree with you!
my said procedure, I just want to verify how the transaction(rollback) works on the said scripts, actually, when the 1st...
March 9, 2020 at 2:10 pm
Don't get me wrong. I totally agree with you on big stuff about pencil and paper not being the way to go. My point was meant to be that no...
March 9, 2020 at 2:04 pm
Thank you for the response, but need explanation for this problem / solution.
CPU looked ok on the VM ( ~ 30% ) . but view was opening ok till...
March 8, 2020 at 3:53 pm
p.s. With regard to the original question of...
I'm doing development on large SCD2 tables (100M+ rows). When I've fixed bugs and it's time to re-run, I need to restore the...
March 8, 2020 at 3:50 pm
Correct. But, be really careful about killing SPIDs... kill the wrong one and your server server could serve as a boat anchor for hours. You should also plan on finding...
March 8, 2020 at 2:45 pm
I can't help you with your Visual Studio problem because I don't use it. I can tell you, though, that your formula for age in years is incorrect simply because...
March 7, 2020 at 3:45 pm
... but I am wondering if I can apply the filegroup backup from one database to another, specifically restoring only a particular filegroup of the database...
To the best of...
March 7, 2020 at 3:15 pm
Thanks for the feedback, Greg. I totally agree... this site has been a staple of knowledge for me, as well. I don't believe that I'd have been able to do...
March 7, 2020 at 3:04 pm
Viewing 15 posts - 7,576 through 7,590 (of 59,072 total)