Adding new files to a log-shipped database (SQL Spackle)
Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.
2024-10-11 (first published: 2013-06-06)
5,796 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
Creating a Comma-Separated List (SQL Spackle)
Learn how to create a comma separated list of values in this short SQL Spackle article by Wayne Sheffield.
2024-08-09 (first published: 2011-01-12)
46,326 reads
Understanding the OVER Clause in SQL Server
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.
2019-09-19 (first published: 2015-10-14)
182,375 reads
Splitting Strings in SQL Server 2016
Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods
2018-06-15 (first published: 2016-04-12)
9,349 reads
Having fun with PARSENAME (SQL Spackle)
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,140 reads
An Introduction to the SQLCMD Mode in SSMS (SQL Spackle)
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,256 reads
The new Analytic functions in SQL Server 2012
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,406 reads
Transaction Isolation Levels
An examination into how the various transaction isolation levels affect locking (and blocking)
2014-02-13
9,014 reads
Creating templates for use in BIDS (SQL Spackle)
Learn how to create and use templates in BIDS in this short SQL Spackle article.
2013-12-30 (first published: 2011-04-21)
11,022 reads
Locking, Blocking and Deadlocking
Introduction into Locking, Blocking and Deadlocks in SQL Server, and why SQL Server uses these actions.
2013-11-18
10,989 reads
Blogs
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Forums
Collecting active node hostname at centralized location
So folks we have around 30/40 sql server failover cluster insatnce with each having...
Beginner in sql server
Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id]...
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers