The basic texts for developing SQL code tend to leave unsaid the basic techniques for building routines such as stored procedures in TSQL. Phil Factor is well-known for his more lengthy and complex stored procedures, so we asked him to explain in more detail how he goes about developing things without the comfort of Visual Studio.
"If you cannot measure something, you cannot improve it." - Lord Kelvin. That quote and a blog about it inspired today's editorial.
This artcle attempts to differentiate between the uses of WITH RECOMPILE and OPTION (RECOMPILE) features.
Table Value Constructors (TVCs) are a useful feature of 2008, allowing you to specify tables of values and expressions. Users who are stuck with previous versions of SQL Server can play along, since Rob Sheldon demonstrates that there have always been ways of doing this in SQL Server, though less elegantly.
Today we have a guest editorial from Andy Warren. We often find that many DBAs fall into the job as accidental DBAs, and need more training. Is a boot camp the way to get them up to speed quickly?
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
This editorial was originally published on Nov 21, 2005. It is being re-run today as Steve is on holiday. How much money is it worth to compromise your ethics? Steve Jones asks today as many companies around the world seem to be doing that.
: "It is a narrow mind that cannot see things from more than one point of view." —George Eliot
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.
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Comments posted to this topic are about the item Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers