By default the SET XACT_ABORT is OFF. There ar very few cases where the T-SQL statement that raised exception are rolled back and the transaction continues processing. Depending upon the...

As this is very old thread.

But just updating this with the solution that the new keyword THROW introduced in SQL Server 2012 will serve the purpose.

THROW in CATCH block will...

I was anticipating this kind of reply 🙂

just stumbled on this thread, didn't realized its 6yrs old :w00t:

But the fact remains same right, then & now? 😎

+1 for Matt's response.

Theoretically Covering Index & Included Columns are same. The difference should be cited as: Covering Index/Included Columns vs Composite Index.

I would suggest not to rely on DUMPS if you really want to add value to your carrier.

You can check my blog post for 70-461 exam: http://sqlwithmanoj.wordpress.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/[/url]

All the best!!!

In my opinion just similar to others:

- TABLES are database Objects and

- CURSORS are Programming Constructs (not to confuse with the cursor data-type),

no matter how you declare them.

An...

Do check following site for the preparation of 70-461 exam.

Link: http://sqlwithmanoj.wordpress.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/[/url]

Check following blog post on what to prepare for 70-461 Exam (Querying SQL Server 2012)

Link:http://sqlwithmanoj.wordpress.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/[/url]

Sean Lange (9/20/2012)

---

Yes it is true that sometimes you can't the code and that is exactly why I said he may be stuck with it. I would vehemently disagree about...

@sean, Cursors were never on bad performance, its upto you when and how you use them. Some developers use them very early rather than creating complex set based...

Yes, as mentioned by @Grant use "Upgrade Advisor" for SQL Server 2008. Check this blog post where I used the same for upgrading to SQL Server 2012, link: http://sqlwithmanoj.wordpress.com/2012/09/02/upgrade-to-sql-server-2012-use-upgrade-advisor/[/url]

This tool...

Well answer to this is "it depends" on situation to situation, like: volume of data, indexes on columns and selectivity of rows.

IN & NOT IN generally should be avoided and...

jeff.mason (6/20/2012)

---

If the value of the PK is vital, and gaps cannot be supported, I'd look at implementing one of 2012's new features -- a SEQUENCE. You can programmatically...

It is true you can make cursors more optimal than a while loop but why bother with them at all? In your examples there is absolutely nothing that can't be...

What kinds of patterns you want to search for?

If not complex then you can use some expressions with LIKE clause.

Like if you want to search Canada ZIP codes, which are...