Viewing 15 posts - 5,746 through 5,760 (of 39,831 total)
Um....no. Just no.
T/SQL scaling is not linear, it's freaking exponential. Or compound-exponential. Developing against...
March 1, 2018 at 9:53 am
It would be helpful to know exactly what code/process is executing this, as noted by Andrew. You might be performing quite a bit of unnecessary work and overloading the system....
March 1, 2018 at 3:34 am
March 1, 2018 at 2:59 am
Is there much of a difference between single server and scale out? Or having SSRS separate from the engine? If so, maybe better to have separate articles. If it's just...
March 1, 2018 at 2:55 am
Hmmm, OK. I tried this:
CREATE LOGIN JoeDBA with password = 'xxx'
GO
GRANT ALTER ANY DATABASE TO JoeDBA
I then opened a new window, logging...
March 1, 2018 at 2:43 am
Gah, not sure what I was thinking. Must have gotten distracted as I was moving the code over. Corrected. The answer and explanation should be 0####
March 1, 2018 at 2:28 am
February 28, 2018 at 7:35 am
There have been reports from some people, others reported no change. I suspect this is workload dependent.
February 28, 2018 at 7:34 am
SQL in the City today, if you have time: https://www.youtube.com/watch?v=0qyMutBkZsg
February 28, 2018 at 6:46 am
By calling it 'intelligence', I think AI is being much oversold. It's...
February 23, 2018 at 4:37 pm
So we deny benefits or employment or insurance to someone based on...
February 23, 2018 at 4:33 pm
Do you mean add a second instance? Is the first instance still there? Are you licensing by cores? If so, you can add new instances.
February 23, 2018 at 3:48 pm
This appears after failover is complete? I would double check all the configuration and make sure every database you expect is in the AG. Make sure the database is not...
February 23, 2018 at 8:28 am
Viewing 15 posts - 5,746 through 5,760 (of 39,831 total)