Viewing 15 posts - 1 through 15 (of 67 total)
Use DB.....That's where the problem was...... 🙂
October 6, 2021 at 4:04 pm
Enterprise edition. DB is in simple recovery even though it is prod and we are aware of the data loss if there are any issues. 200GB of memory with 56...
September 17, 2021 at 5:12 pm
No wonder I am losing hair.....
So I created one of the table from an existing DB, created one non clustered index, inserted more records into it. Made it 85% fragmented....
August 19, 2021 at 5:34 pm
What if I save the DDL as .sql file and use powershell to execute that command from the location on each database? Will that work? If so, then what's the...
October 2, 2016 at 6:05 pm
Truncating tables is out of the question as of now I think.
So what I did was (just for 1 DB), I generated the script from the Source and executed...
September 30, 2016 at 12:28 pm
My apologies, the source server is running on 2008R2 and the destination server is on 2014
September 30, 2016 at 12:14 pm
Guys I do appreciate you telling me that this is not a good practice and I do agree but this is what I was asked to do. And before we...
September 8, 2016 at 12:21 pm
Chitown (9/8/2016)
September 8, 2016 at 11:08 am
Thanks Phil but this question is for people who are not that busy so they can take their time and look at the code? If my question isn't clear then...
September 8, 2016 at 8:15 am
That query worked fine. That user was looking in the wrong server. Don't you just love that?:-)
September 6, 2016 at 12:22 pm
Michael L John (9/6/2016)
Chitown (9/6/2016)
This is what...
September 6, 2016 at 10:18 am
Yes, we do take full backups for dev servers every week and full, dif and tlog for Prod. We also have 6 months of backups for prod in place just...
August 29, 2016 at 4:22 pm
We are going to upgrade it next week but developers need the data now to test. I am sure that's not new.
Thanks!
August 29, 2016 at 1:54 pm
Thanks! Didn't think about that. Its running now.
August 23, 2016 at 10:57 am
Thanks for the reply. I appreciate that.
July 28, 2016 at 8:51 am
Viewing 15 posts - 1 through 15 (of 67 total)