Finding the metadata for a query
You know I occasionally find it interesting how I learn new things. I was running through a practice test for...
2013-11-25
1,738 reads
You know I occasionally find it interesting how I learn new things. I was running through a practice test for...
2013-11-25
1,738 reads
Beginning of period calculations are common things. Rolling month reports, queries to pull everything from last month etc require beginning...
2013-11-20
751 reads
When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know...
2013-11-18
1,381 reads
Every morning we have a daily meeting and my manager asks who’s on call. And every morning some form of...
2013-11-13
588 reads
I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a...
2013-11-11
796 reads
For those who don’t know the three physical join operators are Hash Match, Loop Join and Nested Loops. Understanding these...
2013-11-06
661 reads
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2013-11-11 (first published: 2013-11-04)
1,850 reads
There are lots of ways to learn new things, or be reminded of old things. One of my favorites is...
2013-11-05 (first published: 2013-10-30)
5,040 reads
It’s one of those things that always aggravated me but not really enough to complain about. When you run a...
2013-10-28
689 reads
Yes I’m talking about FETCH as in a cursor, yes everyone hates cursors. But you know cursors are like anything...
2013-10-23
696 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