Fabiano Amorim was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current knowledge, he then decided to find out for himself whether what he'd said was right, and started an epic journey of exploration into Distribution Statistics and the way that the Query Optimiser uses them.
2011-07-13
2,132 reads
Fabiano Amorim was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current knowledge, he then decided to find out for himself whether what he'd said was right, and started an epic journey of exploration into Distribution Statistics and the way that the Query Optimiser uses them.
2011-07-12
2,173 reads
2011-07-11
3,228 reads
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.
2011-07-08
3,997 reads
This artcle attempts to differentiate between the uses of WITH RECOMPILE and OPTION (RECOMPILE) features.
2011-07-07
8,592 reads
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
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
In the second part of his optimization series, Dave Ballantyne shows us how to add conditional logic to set based, more efficient T-SQL code.
2011-06-28
5,312 reads
Learn how you can remove a cursor and optimize a routine that loops through a series of data and performs various calculations in this short article from Dave Ballantyne.
2011-06-27
7,839 reads
2011-06-23
3,622 reads
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
I’ve been running this blog on Hugo for a long time, and like most...
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers