SQLServerCentral Article

SQL Server Stored Procedures and SET options

SET options on stored Procedures work a bit different when compared with ad-hoc queries. These differences in behavior are often overlooked when developing the procedures and generating deployment scripts. This mistake can lead to undesired behavior in the application.

4.25 (36)

You rated this post out of 5. Change rating

2015-10-02 (first published: )

19,904 reads

SQLServerCentral Article

An in-depth look at change detection in SQL Server - Part 02

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.

4.92 (12)

You rated this post out of 5. Change rating

2013-02-19

8,214 reads

SQLServerCentral Article

An in-depth look at change detection in SQL Server - Part 01

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.

4.58 (12)

You rated this post out of 5. Change rating

2013-02-12

5,167 reads

SQLServerCentral Article

Never update systems tables directly - a study in Agent job scheduling

It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.

4.44 (16)

You rated this post out of 5. Change rating

2012-09-17

5,460 reads

Blogs

TryHackMe Advent of Cyber

By

I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...

You should be running on SQL Server 2022

By

It’s me again with my apparently semi-annual blog post. This time we’re going to...

Removing a PowerShell Array Element–#SQLNewBlogger

By

I saw an article on this and realized I had no idea how to...

Read the latest Blogs

Forums

Asking for your feedback on a PHP code security scanner in beta

By Kevbrock12

Hey! Kev is here to invite you to an exciting experience. Our team, full...

WHY Follow a LEFT OUTER JOIN with another LEFT OUTER JOIN

By YSLGuru

NOTE: The Topic Title probably isn't very good but I wasn't sure how to...

Replication Monitoring with Always On Availability Group

By sqlpops

Hey Folks, So I have SQL Transactional Replication set up on a database that's...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers