Viewing 15 posts - 1 through 15 (of 82 total)
Thanks Brian for such an extensive reply! I looked through your suggestions and they all sound like good tips. I have spoken to the users and what used to take...
June 9, 2021 at 12:40 pm
OK my mistake, i wasn't scrolling along far enough for query 10, it was all on the right lower side of the screen. I can now see that the majority...
June 8, 2021 at 2:19 pm
Thanks Grant, i shall have a read!
February 13, 2019 at 8:15 am
Thanks for response Grant. I've not used ColumnStore Indexes before and taking a while to wrap my head around it.
My next question is - any DBAs out there...
February 11, 2019 at 3:02 am
Wow! Interesting. Anyone using this?
January 15, 2019 at 9:40 am
Thanks for all the replies everyone! I don't think this should be an issue about trust (though some will make it about that)... it's about focus. The focus of developers...
September 11, 2018 at 4:29 am
It feels like a good AlwaysOn/Windows clustering overview would do you well here, have you seen this AlwaysOn Stairway? http://www.sqlservercentral.com/stairway/112556/
And some other useful articles:
September 7, 2018 at 7:51 am
If I understand you correctly, after setting up AlwaysOn you have two aliases of the same name, one pointing to the local subnet, one pointing to secondary subnet? This happened...
September 7, 2018 at 3:18 am
Sorry for the delay in getting back to you guys, i had a couple days off. So here's what's odd - the query isn't using the index, which explains why...
July 20, 2018 at 8:58 am
Hi Sue... thanks for the response. That's how I generated the ini - when through a GUI install. It has saved the right settings for the installation parameters so no...
July 12, 2018 at 7:05 am
I can see its a complex one to tackle, but so so useful. I'm sure whatever you came up with would be valuable! Can you have stairways within stairways? So...
July 11, 2018 at 4:10 am
Thanks Gail, those look like some really great books, i will look into them. I just like the idea of a Stairway as it's something to work through in those...
July 9, 2018 at 4:26 am
Yes the RPO and RTO are key. But i think it's fair to say that high availability means near real time data synchronisation, automatic failover and zero data loss, not...
July 9, 2018 at 3:17 am
Thanks for coming back to me guys. I agree it makes sense to keep things separate where possible...
July 2, 2018 at 3:21 am
Thanks Sue. Yes i'm aware of all those things. Just hoping for something a little more off the shelf 🙂 I've managed to configure some PBM conditions which alert on...
June 29, 2018 at 9:52 am