Good work. I'm curious why you chose batch language instead of powershell.

Will it scale? Yes we have a shop, like others I'm sure, where DBAs are not in the loop when it comes to developing sql to satisfy business...

I have spoken with our development group about revising these updates. The other odd thing is that some don't use sp_executesql like most of our queries ( which are...

I attached two

Here is an example of the execution plan for these updates ( below ). When I look in the plan cache around the time of the deadlocks I...

Deadlock this morning. Table/index definitions are below the deadlock xml

index_ServiceRequest_ClientId

index_ServiceRequest_PullReport_FacilityId

Deadlock xml -- first process is the victim waitresource="PAGE: 5:15:8013416 points to...

I've used both Brent Ozar's Sp_BlitzIndex and Jason Strate's sp_indexanalysis. There seems to be precious little as far as any indexes not being used at all, but I need...

Yes, its not pretty. With 30 indexes on the table, I was hoping to find some to remove or change. Very difficult to do when such updates aren't...

Yes the deadlock graphs are showing page wait on one particular index. I just read an article recently suggesting use of DTA ( after searching on this issue )....

Although I'm not crazy about our Netapp snap manager for sql backup/restore solution, I do know that a native sql backup of our largest prod database takes at least six...

When I chose this option I was never asked for instants name or IP address must the cluster services be running for this install to work correctly

----add a new failover...

Thanks. Sounds like if I do anything in production it should just be SP2 with no Cumulative Updates. I hear your concern about CU's but seems I...

"everything is moving to NoSql" ??

Isn't it true generally that DBAs and developers on many non-microsoft platforms are more expensive ( and possibly harder to find ) ?

Another cost we...

We have a number of Sql 2008 and Sql 2012 Enterprise installations, but I recently saw our company take some serious steps towards Linux/Python/Java/DB2.

We have huge mix of platforms due...

Thanks, now to test in QA

CREATE NONCLUSTERED INDEX [index_ServiceRequest_BusinessProcessStatus] ON [dbo].[SERVICE_REQUEST]

(

[BUSINESS_PROCESS_STATUS] ASC,

[LAST_STATE_RESPONSE_CODE] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = ON, ONLINE = OFF, ALLOW_ROW_LOCKS =...