Stories tagged with MS SQL - DeveloperSites
1
likes
spam Like Dislike

When and When Not To Use NOLOCK

published 182 days, 15 hours, 44 minutes ago posted by matthewpomarmatthewpomar 192 days, 13 hours, 55 minutes ago
Wednesday, December 29, 2021 1:17:53 PM GMT Sunday, December 19, 2021 3:06:48 PM GMT
To NOLOCK or Not to NOLOCK... That is the question. Lots of developers who don't fully understand the requirements of their application or how NOLOCK works will indiscriminately add NOLOCK to all of the SQL queries. But doing so isn't always the best decision. Brent Ozar describes some times when it is beneficial to use NOLOCK and times where it isn't the right choice. (more)
category: SQL Server | clicked: 1 | comment | | source: www.brentozar.com
tags: MS SQL, Performance
1
likes
spam Like Dislike

Good Reasons Not To Use SQL Server To Send Emails

published 182 days, 15 hours, 44 minutes ago posted by matthewpomarmatthewpomar 192 days, 14 hours, 2 minutes ago
Wednesday, December 29, 2021 1:17:53 PM GMT Sunday, December 19, 2021 2:59:45 PM GMT
When all you have is a hammer, everything looks like a nail. Over the years, I have seen my fair share of complex SQL Server applications, where loads of business logic exist in stored procedures and cursors churn through thousands of records handling complex business rules and sending out emails. But there are some really good reasons not to send emails from SQL Server. In his blog, Brent Ozar describes some of these reasons. (more)
category: SQL Server | clicked: 2 | comment | | source: www.brentozar.com
tags: Email, MS SQL