T-SQL Tuesday #85: Backup and Recovery
It’s that time of the month… the time when all of the T-SQL bloggers have a party and blog about...
2016-12-13
402 reads
It’s that time of the month… the time when all of the T-SQL bloggers have a party and blog about...
2016-12-13
402 reads
Most of the DBCC commands return their results as textual output, even if you have SSMS configured to return result...
2016-11-16
471 reads
Having a solid knowledge of the window functions if vital to high performance T-SQL Code. The key to these functions is how the OVER clause is used. This article will dive into how to use the OVER clause.
2016-09-30 (first published: 2015-10-14)
182,866 reads
PARSENAME is perhaps the most infrequently used built-in documented function in SQL Server. SQL Server Microsoft Certified Master Wayne Sheffield shows why this nifty function ought to be included in your SQL toolbox.
2016-01-15 (first published: 2014-03-17)
23,567 reads
Using SQLCMD Mode in SSMS is easy. This short piece will show you how to get started.
2015-10-16 (first published: 2013-05-06)
22,863 reads
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2015-07-20
765 reads
A while back, I wrote a blog post showing the differences (including performance) between Inline Table-Valued Functions (ITVF) and Multi-Statement...
2015-07-16
1,097 reads
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2015-05-11
578 reads
SQL Server expert Wayne Sheffield looks into the new T-SQL analytic functions coming in SQL Server 2012.
2015-05-01 (first published: 2012-01-19)
31,525 reads
Earlier this month, I hosted the 61st occurrence of the monthly TSQL-Tuesday blogging party. With a topic of “Giving Back”,...
2014-12-31
1,389 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers