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,443 reads
Learn how to load data in an XML file into a table in SQL Server.
2013-05-31 (first published: 2011-01-03)
20,443 reads
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)
60,745 reads
Performance test of new SQL 2012 functions DateTimeFromParts and Format
2012-05-10
6,113 reads
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,357 reads
How to set the default locations for backups, data files, and log files in SQL Server.
2010-11-11
8,251 reads
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,745 reads
Returning author Wayne Sheffield recently had some database corruption - read about how it was fixed.
2010-03-03
8,568 reads
2010-02-19 (first published: 2008-12-05)
38,417 reads
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,772 reads
How to use XML to pass Multi-Select parameters from Reporting Services to SQL Server.
2008-05-08
9,554 reads
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
I have the user Managed identity <myusermanagedidentity> , granted it carte blanche alter...
First off, my apologies for what could potentially be a bad title! I am...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers