ISNULL() VS. COALESCE()
There are a lot of arguments about which of these to use. In my opinion, they both have their place. ...
2010-02-11
9,052 reads
There are a lot of arguments about which of these to use. In my opinion, they both have their place. ...
2010-02-11
9,052 reads
Today I'll be tagging along with Kevin Kline for the Quest Pain of the Week webcast. We'll be talking about...
2010-02-11
916 reads
I answered a forum post the other day over on SSC on the differences between the trace events stmtcompleted and...
2010-02-11
2,901 reads
Update: Scroll to the bottom for more information added after originally posting.
Earlier this week a coworker asked me for help...
2010-02-10
706 reads
Introduction
Last night we had our February OPASS meeting with Ron Dameron (@RonDBA) presenting on Database Hardening using PowerShell. We broadcast...
2010-02-10
401 reads
Slightly off topic, but I’m adding this one to the Modern Resume blog since I think it’s something to be...
2010-02-10
481 reads
Really rainy in Orlando today, traffic is horrible. We had a higher than usual number of RSVP’s for the meeting,...
2010-02-10
472 reads
Greg Larsen is hosting SQLSaturday in Redmond, WA again this year, this time on June 12, 2009. Call for speakers...
2010-02-10
581 reads
In my first T-SQL Tuesday submission I thought I'd mention something that we often take for granted when working with...
2010-02-10
442 reads
I was watching Michelle Ufford’s (blog, Twitter) presentation from the 2009 PASS Summit recently on DVD. I had purchased them,...
2010-02-09
963 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers