Hmm. If you are deleting a large fraction of a table it is often best to drop existing non-clustered indexes and then rebuild after DML.

mark.worthen (2/26/2015)

---

I was wondering if there is a way to have a process run that will not write its changes to the transaction log? I have a process that...

One of the BEST ways to learn about SQL Server is to set up a profiler trace capturing RPC batch completed and TSQL batch completed and then have a GUI...

I think this is just a variant of the "gaps and islands" problem, for which there are many solutions. Binoogle itzik ben-gan gaps and islands to find a number...

Binoogle will get you the only resources out there that I know of. I still use the 2005 link too. It does need a refresh (and better documentation...

Possibly bug in Spotlight. Your your own DMVs to see what is in/happening in the procedure cache. Glenn Berry's SQL Diagnostics scripts are a good resource.

daniarchitect (2/24/2015)

---

Experts thank you all for responding quick and valuable inputs, it an eye opener.

we found a trigger which calls a procedure that uses a transaction , that caused the...

daniarchitect (2/24/2015)

---

Experts

We have 6 tables , 5 of them references 1 parent table.

there is one insert process through a stored procedure that an application is calling to insert data...

A Scalar UDF is one of the worst things you can do in SQL Server. Best BY FAR is to just inline the logic and use it directly in...

Please provide more detail about your scenario(s). You haven't given us enough information to help you.

I assume you are calling this a variable: %computername%? Not allowed IIRC.

Did you try with a specific name instead? Also, exactly what is the error you are getting??

sp_whoisactive. Free and AWESOME tool to show you what is happening on the server right now. Also can do differential time-based analysis. Find it on sqlblog.com, where...

Ford Fairlane (2/16/2015)

---

Thanks for the responses, I was not expecting it to be easy but to make it worse, the connection between the two systems is over a microwave link......

Is there Always On already established in the existing infrastructure?? I must have missed that. I read it that the AG stuff was going to be introduced in...

You can always set up your own log shipping instead of using the built-in stuff, which can use whatever backups you already do. I had to do that for a...