Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Test Post–Disregard

SQL Blog Test Read more

0 comments, 297 reads

Posted in James' SQL Blog on 14 December 2011

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

0 comments, 200 reads

Posted in James' SQL Blog on 14 December 2011

WAN Optimization–Part 2

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

0 comments, 376 reads

Posted in James' SQL Blog on 5 December 2011

WAN Optimization Evaluation Review–Part 1

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

3 comments, 868 reads

Posted in James' SQL Blog on 30 November 2011

WAN Optimization Solutions–Input Needed Please!

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. 

  1. How much optimization do you see on SQL Server 2008 R2?  Asynchronous Mirror?
  2. Does it really help if I…

Read more

1 comments, 390 reads

Posted in James' SQL Blog on 2 November 2011

Fatal Error Emails This Morning…

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

0 comments, 314 reads

Posted in James' SQL Blog on 1 November 2011

I/O Error On TempDB

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

0 comments, 969 reads

Posted in James' SQL Blog on 28 October 2011

An Update To My Previous Post

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

0 comments, 290 reads

Posted in James' SQL Blog on 13 May 2011

My Partitioning And Compression Quest! (Continued)

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,
    [Currency] SMALLMONEY,
    [Flag] SMALLINT,
    [Currency_Max] SMALLMONEY,
    [Note] VARCHAR(500))

There is only one… Read more

4 comments, 454 reads

Posted in James' SQL Blog on 5 May 2011

My Partitioning And Compression Quest!

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

1 comments, 329 reads

Posted in James' SQL Blog on 3 May 2011

Thirty-Three Weeks…

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

6 comments, 278 reads

Posted in James' SQL Blog on 21 April 2011

Adding Data Files To A Mirrored Database

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

6 comments, 1,925 reads

Posted in James' SQL Blog on 20 April 2011