I don't believe anyone has mentioned it but are you using backup compression?

Congratulations on your new Senior DBA position!

good call. your way seems pretty simple with less work to be done.

This shows why you're getting 320

select a.id, a.amt, b.amt

from nav a

inner join balance b

on a.id = b.id

This is an example to return the expected result of 310 using simple joins...

REPLACE ( string_expression , string_pattern , string_replacement )

SELECT REPLACE ( 'closed won' , 'closed won', 'award')

the string_expression can be a column, variable, or string.

oh man!

I'v been away for a bit, again.

Voluntary pitchers and catchers (and injured players i.e. Boston 2012 roster) report today! And 10 days until the first spring training game! What...

oh man! The Yankees looking to Youklis to play at third base? 1/12mil.

So we were just talking about long contract deals of 10 years and the risk that comes along with it. Injuries and diminishing level of skill. Alex Rodriguez is to...

news is Longoria signed an extension with the Rays. Good through 2022 (wow! :w00t: )

That's such a huge risk for any team to take. To hope someone stays healthy for...

SELECT STUFF(STUFF(STUFF(my_time_column, 1, 0, REPLICATE('0', 6 - LEN(my_time_column))),3,0,':'),6,0,':'),

have you checked the windows logs? I'm sure something would be in there if a failover was attempted but couldn't succeed for some reason.

Good reading at SI.com.

Josh Hamilton is a potential free agent if the Rangers don't sign him. Their concern is his addictions (to energy drinks!).

Raphael Soriano opted out of his...

Ray K (11/1/2012)

I'll make you a deal. A-Rod for Middleton and Big...

Yep, another good series. I would have been happy either way.

Now let the A-Rod trade rumors begin!

1. SQL Server (troubleshooting, debugging, tuning and optimization of SQL queries and stored procedures) 2. Database administration (Replication, design experience with RDBMS. 3.DR: doing quality assurance of the database components...