Viewing 15 posts - 1 through 15 (of 51 total)
Merry Christmas to all.
Movie traditions:
Grant, I agree with Miracle on 34th,...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
December 21, 2020 at 2:04 pm
Henk, Did you open a ticket with Microsoft about the issue?
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
November 19, 2020 at 9:08 pm
Jeff, Your suggestion has plausibility. My question to you would be, if those characters are the problem, why does it only happen on the new versions of the driver?
We are...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
November 19, 2020 at 8:04 pm
We had the same problem starting last night when we shut down the VM that hosts one of our SQL Servers due to a Hyper-V host issue. This particular sql...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
October 16, 2020 at 9:07 pm
Thank you for the reply.
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
June 12, 2018 at 8:30 am
Could you clarify the Maximum Server Memory formula?
My VM's for sql server run with a minimum of 48gb.
If I follow your recommendation, I would be taking 9gb away...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
June 11, 2018 at 9:25 am
Nice article. I have been working on a similar concept for our environments.
I did notice a disparity between you sql for the table and your paragraph describing it.
In...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
May 1, 2018 at 6:00 am
tom.artz (3/9/2015)
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
March 9, 2015 at 8:07 am
We are currently in the process of upgrading to 2012 for a majority of our sql servers. I still have one server on 2008 only because the 3rd party product...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
September 26, 2014 at 7:05 am
Good script.
Here is an improved version that:
- fixes the length = -1 problem for MAX.
- PRINTs the output to the Messages tab to make it easier to copy and past...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
April 18, 2014 at 1:04 pm
Bill,
Your senario might work if I had only a few databases to mirror and a few "applications" to change connection strings.
I have 66 databases, and growing, on the cluster. I...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
April 15, 2014 at 8:37 am
I found the article very interesting. As the sole DBA I am currently supporting 2 clustered environments in 2 domains. The headache I am going to be facing next summer...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
April 15, 2014 at 7:32 am
Ed,
Thanks for the comments.
I would normally agree with you and have the box rebuilt.
But in this case the box is already in production with one instance of sql running clustered...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
April 11, 2014 at 11:12 am
I should have done a little more digging before writing this post.
I figured it out.
Control Panel > Programs and Features.
Select Microsoft SQL Server 2012 (64-bit).
Click Uninstall/Change.
When the Add/Repair/Remove dialog come...
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
April 10, 2014 at 1:39 pm
Thank you for the post, it looks interesting.
One question.
How do you recreate it when Sql restarts?
Since tempdb is deleted and recreated on a restart.
Bill Soranno
MCP, MCTS, MCITP DBA
Database Administrator
Winona State University
Maxwell 143
"Quality, like Success, is a Journey, not a Destination" - William Soranno '92
March 12, 2014 at 12:58 pm
Viewing 15 posts - 1 through 15 (of 51 total)