double post...

you can get that info from the default trace (if it is running)

to be alerted would require you to set up an agent job that parsed the default trace at...

thanks for making me laugh this morning...:-D

that...

you could look into RedGate SQL DataCompare Pro.

i used that software with its command line capibilites to keep 2 databases in sync on different systems for a week during a...

i think you would find that a properly configured SAN will almost always be faster than local disks. of course, your mileage will vary.

you could have 8 internal SSD drives...

Still not the 40 minutes you claimed to get on the old server...... but 1:30 for 500GB is pretty decent.

my vote would be for Windows 2008 R2.

i would only use Windows 2012 Core. The GUI on 2012 is (IMHO) clunky.

you would need another table for a join that contained the first date of every month.

I don't think i have your answer, (its a bit tough to understand what you...

you run anti-virus on those nodes? I always check anti-virus logs when all else appears normal.

DECLARE @GetInstances TABLE

( Value nvarchar(100),

InstanceNames nvarchar(100),

Data nvarchar(100))

Insert into @GetInstances

EXECUTE xp_regread

@rootkey = 'HKEY_LOCAL_MACHINE',

@key = 'SOFTWARE\Microsoft\Microsoft SQL Server',

@value_name = 'InstalledInstances'

Select InstanceNames from...

you're very welcome.

UPDATE T1 --TableA

SET IDAlias = T2.Alias

FROM TableB T2 INNER JOIN TableA T1

ON T1.CustomerID = T2.CustomerID

you could do this;

create table #MyHead (PhoneNumber varchar(100))

insert into #MyHead VALUES ('212/2222255'),

('212.222.5555'),

('(212).222.5555'),

('212-222-5555'),

('212-222-5555 EXT 511')

;

WITH CTE AS (

select

CASE

WHEN charindex('/', PhoneNumber) > 0 then REPLACE(PhoneNumber,'/','')

WHEN charindex('.', PhoneNumber) >...

might be that allocating 150GB is what is taking up some of your time. when a failover occurs, tempdb is re-created. by pre-allocating the space, the server has to actually...