As you advance in your skills as a Transact-SQL developer or SQL Server database administrator there will come a time when you need to override SQL Server's locking scheme and force a particular range of locks on a table. This article by Randy Dyess shows you how to optimize your queries using table hints.
2002-04-15
21,983 reads
In this article Randy Dyness shows you how to avoid temp tables whenever to maximize the performance of your queries.
2008-05-30 (first published: 2002-04-09)
70,065 reads
This article demonstrates the flexibility of static SQL when using the CASE function in a WHERE clause, SELECT clause, ORDER BY clause, GROUP BY clause, HAVING clause, and JOIN. This is done with five examples and includes sample code you can execute on your SQL Server.
2002-03-14
11,561 reads
This week Andy continues his series on how to reduce the number of round trips to the server by looking at some things you can easily add to your applications without a lot of rearchitecting.
2002-03-11
8,072 reads
Robert Marda continues his series on dynamic SQL and shows you how to rewrite some queries that you may think need dynamic SQL.
2002-03-07
13,139 reads
Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.
2002-03-01
2,857 reads
One of the most overlooked areas in optimizing SQL Server and Transact-SQL is the recompilations of stored procedures. A database getting thousands of recompiles an hour will suffer in performance and show short term blocking that will affect the database users. This article by Randy Dyess shows you some of the ways you can avoid stored procedure recompiles.
2002-02-26
25,107 reads
A series of web presenatations from Microsoft about tuning SQL Server 2000.
2002-02-15
1,362 reads
Most DBAs and developers prefer not to use dynamic SQL for a number of reasons. There are some reasons to use this query type though. This article covers a few of those.
2002-02-12
14,889 reads
This article examines how index statistics are used in SQL Server 6.5
2002-02-08
239 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers