An Informal Look at Database Performance
A review on the basic steps to correct a poorly performing query
2010-09-08
12,480 reads
A review on the basic steps to correct a poorly performing query
2010-09-08
12,480 reads
A Technique to deal with moving data from multiple schemas into one table
2010-08-09
6,401 reads
Some useful undocumented extended and stored procedures in SQL Server 2005
2009-11-20 (first published: 2008-05-09)
33,452 reads
2009-01-17 (first published: 2008-05-28)
4,231 reads
2008-12-02
9,122 reads
2008-10-23 (first published: 2008-08-24)
1,915 reads
2008-09-09
12,787 reads
A discussion on using CTEs to speed the development and maintenance of reports and enhance readability.
2008-03-31
6,159 reads
Discusses the techniques and reasons to use opendatasource for reading text files in SQL Server 2005.
2007-12-13
10,376 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers