Viewing 15 posts - 2,386 through 2,400 (of 39,817 total)
One other question, you have the systemdbs, but do you have the versions of SQL for each?
October 14, 2020 at 9:11 pm
From a few others:
If you connect to the restored instance with the DAC, and then go to the restored_master, you can try this:
select * from sys.sysdbreg
That gets...
October 14, 2020 at 8:47 pm
I don't think you can easily. Lots of stuff in here is a view, which means there are live queries here.
What I'd do, is restore this master as the master...
October 14, 2020 at 6:37 pm
If I have a clustered index on orderdate, and a nonclustered index on orderdate, I might use both of them. If I'm joining the table on orderdate, and not retrieving...
October 14, 2020 at 6:18 pm
First few weeks meetings were far less, now my calendar looks like a losing game of Tetris.
If doctors complain about paperwork you should see what UK teachers have to...
October 14, 2020 at 6:03 pm
I hate that that's the answer, but I think the multiple dependencies here are often a problem with some of the things in SSMS
October 14, 2020 at 6:03 pm
If I were going to FL, it would be Pensacola/Destin/etc. area, but unlikely. Gotten too used to the dry weather.
Now I have a hard time thinking of leaving CO, except...
October 13, 2020 at 7:11 pm
All the older views are deprecated, but they are not likely to be enhanced, nor removed. You should be using the modern view.
October 13, 2020 at 1:55 am
For saving space, https://voiceofthedba.com/2014/12/01/creating-placeholder-files/
October 9, 2020 at 5:00 pm
Thanks, I think I've gotten used to typing postgresql too often.
container are my go to now, to avoid installing more software that might change behavior. I keep thinking I ought...
October 9, 2020 at 4:38 pm
For the main job you've set up, did you check all databases or all user databases?
October 9, 2020 at 4:14 pm
Your downfall here is going to be trying to do it all at once.
You cannot touch the vendor DB, but there is nothing stopping you from creating your own...
October 8, 2020 at 4:42 pm
Some people like columns. I've run into some tables with high hundreds of columns, which astounds me.
October 8, 2020 at 4:26 pm
I travel all over, and most big cities are bad in places, but also not bad in others. Parts of LA/SoCal make me crazy, but others aren't bad. Busy, but...
October 7, 2020 at 5:03 pm
Viewing 15 posts - 2,386 through 2,400 (of 39,817 total)