An Informal Look at Database Performance
A review on the basic steps to correct a poorly performing query
2010-09-08
12,487 reads
A review on the basic steps to correct a poorly performing query
2010-09-08
12,487 reads
A Technique to deal with moving data from multiple schemas into one table
2010-08-09
6,405 reads
Some useful undocumented extended and stored procedures in SQL Server 2005
2009-11-20 (first published: 2008-05-09)
33,494 reads
2009-01-17 (first published: 2008-05-28)
4,284 reads
2008-12-02
9,124 reads
2008-10-23 (first published: 2008-08-24)
1,917 reads
2008-09-09
12,792 reads
A discussion on using CTEs to speed the development and maintenance of reports and enhance readability.
2008-03-31
6,167 reads
Discusses the techniques and reasons to use opendatasource for reading text files in SQL Server 2005.
2007-12-13
10,386 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item Is Fabric a Reliable Service...
hi , a new user wants to be able to add sql agent jobs...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers