Viewing 15 posts - 586 through 600 (of 5,394 total)
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...
April 19, 2015 at 3:16 am
John Hick-456673 (4/17/2015)
spaghettidba (4/17/2015)
craig 81366 (4/18/2013)
John Hick-456673 (4/18/2013)
I have tested it against large tables (1 billion plus rows) and performance is much better than with dynamic SQL.
I'm going to be...
April 18, 2015 at 10:34 am
craig 81366 (4/18/2013)
John Hick-456673 (4/18/2013)
I have tested it against large tables (1 billion plus rows) and performance is much better than with dynamic SQL.
I'm going to be blunt here.
I find...
April 17, 2015 at 5:11 pm
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,
...
April 17, 2015 at 3:02 pm
Confirmed. It's the parameterization that protects you. You run into issues with improper dynamic sql.
April 17, 2015 at 10:26 am
You're ok, no sql injection possible here.
April 17, 2015 at 10:08 am
More readable format for those who want to answer:
+-------------------------------------------------+---------------------+--------------+------------------+---------------------+
| wait_type ...
April 17, 2015 at 9:29 am
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...
April 17, 2015 at 8:06 am
An index on (parent_agent_cd , forex_tag_no, paying_agent_cd , created_on ) might help.
Can you show us the actual plan?
April 17, 2015 at 7:57 am
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.
April 17, 2015 at 4:53 am
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...
April 17, 2015 at 4:18 am
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...
April 17, 2015 at 3:29 am
There's no need to reinvent the wheel. Use Ola Hallengren's maintenance solution. http://ola.hallengren.com
April 17, 2015 at 2:46 am
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.
April 17, 2015 at 2:38 am
Viewing 15 posts - 586 through 600 (of 5,394 total)