Temporary Post Used For Theme Detection (34836190-9a25-42fe-be54-415469756264 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (4211c8dc-abcd-4ab4-b505-10f305aa9533 - 3bfe001a-32de-4114-a6b4-4005b770f6d7) Read more
After installing the WAN optimization appliances on all of our main sites, we have liked what we’ve seen thus far. However, there are thing to note on the SQL database side where the appliances cannot optimize the network traffic. Here are some of the things to keep in mind that… Read more
We are evaluating a WAN optimization vendor and have so far installed the appliance at the primary site and end-user’s home computer. We will have to install another appliance to the DR site which will happen today or tomorrow. So far from the management console, it looks promising.
Since yesterday… Read more
I was just wondering if anyone has a WAN optimization solution as part of their infrastructure. I have a few questions and I just wanted a DBA’s perspective on all this.
- How much optimization do you see on SQL Server 2008 R2? Asynchronous Mirror?
- Does it really help if I…
So every morning I check my email on my phone. Normally, I don’t see any error emails from SQL Server which is great! However, this morning I saw many emails with the title:
SQL Server Alert System: ‘Fatal Error In Current Process’ occurred on \\server
Great… What a wonderful start… Read more
I was running a DBCC CHECKDB on a database when I got an error that says:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
I was like “Oh crap!” So I went to the SQL… Read more
I have picked Row compression and moved it out of [Primary] and into its own FileGroup and .NDF file. I’ve been monitoring it this week and it’s been looking good so far. *Knock on wood*
I have started on another large table and have chosen Row compression due to constant… Read more
Thank you, David C, for your comment! Please see below to the answers to your questions.
The table structure is:
CREATE TABLE [dbo].[Table_NoChange] (
[ID] INT NOT NULL,
[Time] SMALLDATETIME NOT NULL,
There is only one… Read more
So I have a pretty big database (around 1 TB) that’s getting a bit out of hand. I inherited it and have been doing things to improve it ever since I started this new job. And boy, there’s been some changes since I first started. Let’s just say that this… Read more
Good day SQLServerCentral!
(Note: This does not have anything to do with SQL; it’s more of a (*gulp*) regular blog…)
Thirty-three weeks. That is how many weeks my wife has been pregnant. This will be our first child and, oh boy, what a life changing experience this will be. … Read more
This is my first post! I don't really expect anyone to find this blog.
So I have a pretty big database (around 700 GB) and it's asynchronously mirrored to another location. I thought it would be best to make the [PRIMARY] FileGroup as small as possible so I started with… Read more