Viewing 15 posts - 2,281 through 2,295 (of 39,720 total)
Sizes are likely out because the file list doesn't seem available.
You inspired me. I'm going to write an article based on this, as some of these things are interesting...
October 14, 2020 at 10:53 pm
If you restore headeronly for the master backup, this should give you the versions. You can map those to the CUs from here: https://www.sqlservercentral.com/articles/sql-server-build-lists
If the master dbs are in...
October 14, 2020 at 9:25 pm
They're not allowed to play for you until they've been quarantined on your team for 14 days, per Gov Cuomo
October 14, 2020 at 9:13 pm
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
Viewing 15 posts - 2,281 through 2,295 (of 39,720 total)