Recently I came across with an article on DB2 about using Union instead of OR. So I thought of carrying out a research on SQL Server on what scenarios UNION is optimal in and which scenarios OR would be best. I will analyze this with a few scenarios using samples taken from the AdventureWorks database
2011-07-06
6,349 reads
: "It is a narrow mind that cannot see things from more than one point of view." —George Eliot
2011-07-05 (first published: 2009-05-20)
8,256 reads
Indexes speed retrieval of rows from database tables or views. Here are the top index-related T-SQL statements that SQL Server DBAs should know.
2011-07-05
8,937 reads
This article explains the differences between the Truncate and Delete commands in SQL Server.
2011-07-04 (first published: 2007-11-22)
37,199 reads
It is recommended that you remove all special characters and HTML formatting. This task can be handled in TSQL code, however in this case I have the opportunity to use .NET and the power of the regular expressions to manage the string. In this tip, I'll build a CLR function which cleans up a string of HTML tags and special characters. I'll use Visual Studio 2010 with C# as the programming language. Check out this tip for my solution.
2011-07-04
3,902 reads
Arshad Ali examines the different types and different layers of security that SQL Server Service Broker provides during communication and while accessing Service Broker objects.
2011-07-04
1,810 reads
Monitoring your SQL Server instances and figuring out what's going on is important to keep an eye on your environment. David Bird brings us a new series that looks at how you might start setting this up with Integration Services.
2011-07-01 (first published: 2008-01-07)
27,831 reads
FTP Task lets you copy files across distributed, frequently incompatible systems.
2011-07-01
3,288 reads
Learn the basics of first normal form and what that means to a database designer from Tom Thomson.
2011-06-30
10,903 reads
2011-06-30 (first published: 2009-05-13)
7,316 reads
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Comments posted to this topic are about the item Finding Bad Queries
Comments posted to this topic are about the item The Service Name