An Informal Look at Database Performance
A review on the basic steps to correct a poorly performing query
2010-09-08
12,429 reads
Timothy A Wiseman
- Interests: SQL Server, Python, Go, Mathematics, Legal Issues
Going From Many Schemas To One Schema
A Technique to deal with moving data from multiple schemas into one table
2010-08-09
6,383 reads
Undocumented Extended and Stored Procedures
Some useful undocumented extended and stored procedures in SQL Server 2005
2009-11-20 (first published: 2008-05-09)
33,105 reads
2009-01-17 (first published: 2008-05-28)
3,967 reads
2008-12-02
9,093 reads
2008-10-23 (first published: 2008-08-24)
1,863 reads
2008-09-09
12,759 reads
CTEs in Report Creation
A discussion on using CTEs to speed the development and maintenance of reports and enhance readability.
2008-03-31
6,118 reads
Reading Ad Hoc Text Files with OpenDataSource
Discusses the techniques and reasons to use opendatasource for reading text files in SQL Server 2005.
2007-12-13
10,271 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...