Loading XML Data into SQL Server (SQL Spackle)
Learn how to load data in an XML file into a table in SQL Server.
2013-05-31 (first published: 2011-01-03)
20,527 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
Comparing Table Variables with Temporary Tables
This articles brings a comparison of temporary tables with table variables from SQL Server author, Wayne Sheffield. In includes an in-depth look at the differences between them.
2012-06-08 (first published: 2009-06-10)
61,214 reads
Performance Test of New Date Manipulation Functions (SQL Spackle)
Performance test of new SQL 2012 functions DateTimeFromParts and Format
2012-05-10
6,186 reads
The OVER Clause enhancements in SQL Server code named “Denali”, CTP3
A look at how the OVER clause is changing in SQL 11, based on the CTP 3 released to the public.
2011-08-25
9,404 reads
Setting SQL Server Default Locations
How to set the default locations for backups, data files, and log files in SQL Server.
2010-11-11
8,532 reads
SQL Server Ranking Functions
A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications.
2010-04-20
14,847 reads
Fixing DBCC CHECKDB Msg 8992 Errors
Returning author Wayne Sheffield recently had some database corruption - read about how it was fixed.
2010-03-03
8,823 reads
2010-02-19 (first published: 2008-12-05)
38,765 reads
Using XML to Enhance the Performance of String Manipulations
This article from Wayne Sheffield shows how the use of XML can speed up those string manipulations in your T-SQL code.
2008-08-20
9,869 reads
Using XML to pass Multi-Select parameters from SSRS to SQL Server
How to use XML to pass Multi-Select parameters from Reporting Services to SQL Server.
2008-05-08
9,703 reads
Blogs
Advice I Like: Art
By Steve Jones
Superheroes and saints never make art. Only imperfect beings can make art because art...
Why Optimize CPU for RDS SQL Server is a game changer
One feature that I have been waiting for years! The new announcement around optimize...
Performance tuning KubeVirt for SQL Server
Following on from my last post about Getting Started With KubeVirt & SQL Server,...
Forums
data type gets lost in data flow
Hi, in a simple oledb source->derived column->oledb destination data flow, 2 of my...
i noticed the sqlhealth extende event is on by default , so can i reduce
hi, i noticed the sqlhealth extended event is on by default , and it...
New-AzSqlInstanceServerTrustCertificate - Failed and no clues
Using New-AzSqlInstanceServerTrustCertificate to import a certificate and get the message New-AzSqlInstanceServerTrustCertificate: Long running operation...
Question of the Day
The Read Committed Snapshot Isolation behaviour
I am currently working with Sql Server 2022 and AdventureWorks database. First of all, let's set the "Read Committed Snapshot" to ON:
use master; go alter database AdventureWorks set read_committed_snapshot on with no_wait; goThen, from Session 1, I execute the following code:
--Session 1 use AdventureWorks; go create table ##t1 (id int, f1 varchar(10)); go insert into ##t1 values (1, 'A');From another session, called Session 2, I open a transaction and execute the following update:
--Session 2 use AdventureWorks; go begin tran; update ##t1 set f1 = 'B' where id = 1;Now, going back to Session 1, what happens if I execute this statement?
--Session 1 select f1 from ##t1 where id = 1;See possible answers