Stories tagged with MS SQL - DeveloperSites

MS SQL

atom rss
1
likes
spam Like Dislike

When and When Not To Use NOLOCK
published 847 days, 15 hours, 29 minutes ago posted by matthewpomarmatthewpomar 857 days, 13 hours, 40 minutes ago
Wednesday, December 29, 2021 1:17:53 PM GMT Sunday, December 19, 2021 3:06:48 PM GMT
When and When Not To Use NOLOCK
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 847 days, 15 hours, 29 minutes ago posted by matthewpomarmatthewpomar 857 days, 13 hours, 47 minutes ago
Wednesday, December 29, 2021 1:17:53 PM GMT Sunday, December 19, 2021 2:59:45 PM GMT
Good Reasons Not To Use SQL Server To Send Emails
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: 3 | comment | | source: www.brentozar.com
tags: Email, MS SQL