John, the decision is up to you, but please consider that you had good feedback from this article in general. I'm sorry that you feel you've been mistreated. My comments...

John Hick-456673 (4/17/2015)

spaghettidba (4/17/2015)

craig 81366 (4/18/2013)

I'm going to be...

craig 81366 (4/18/2013)

I'm going to be blunt here.

I find...

And the question is?

The optimal index for this query is the following:

CREATE NONCLUSTERED INDEX IX_ForThisQuery

ON forex_coll (

parent_agent_cd ASC,

forex_tag_no ASC,

paying_agent_cd ASC,

...

Confirmed. It's the parameterization that protects you. You run into issues with improper dynamic sql.

You're ok, no sql injection possible here.

More readable format for those who want to answer:

+-------------------------------------------------+---------------------+--------------+------------------+---------------------+

| wait_type ...

It's working for me, it must be something else.

BTW, the script has only 35 lines and it's complaining about an error at line 67, so maybe you're not showing us...

An index on (parent_agent_cd , forex_tag_no, paying_agent_cd , created_on ) might help.

Can you show us the actual plan?

XP is out of support and a bag of security holes. It's a 14 years old OS. Get out of there as soon as you can.

SSMS will connect, but you won't get access to the new features and you may get some errors in dialog windows. I suggest that you install SSMS 2014, which works...

I guess that the culprit is network or disk load during the backup operation.

Which waits do you see during the backup operation?

Using sp_WhoIsActive (or querying directly sys.dm_exec_* DMVs), which wait...

There's no need to reinvent the wheel. Use Ola Hallengren's maintenance solution. http://ola.hallengren.com

It's impossible to tell which column belongs to which table, so there's no way we can answer your question. Add table prefix to each column.