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,221 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,546 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,288 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,812 reads
2011-06-23
3,617 reads
By Chris Yates
I get asked a lot about why or how I began working with databases...
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Hi, we lost our sever sql2000 To restore database to a new one we...
Comments posted to this topic are about the item Do You Really Need HA?
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers