Kent SqlServer UserGroup
I am now in the process of arranging the 2nd meeting of the kent sqlserver user group. This will be...
2010-08-27
426 reads
Dave Ballantyne
Kent SQL Server User Group
Well , that was an experience.
It was my first time arranging anything like that and it seemed to me that...
2010-08-19
672 reads
Inconsistent NullIF Behaviour ?
NullIf can be a very handy function sometimes. For those who have not used it, if the result of the...
2010-08-06
672 reads
Count(*) or Count(1) ?
Every so often on the on-line forums, the question of : Which is better Count(*) or Count(1) ? will occur. So can...
2010-07-27
1,469 reads
SQLBits 7
For those that may of missed it, voting for SQLBits sessions is now open. Make your voice heard and get...
2010-07-20
399 reads
Using a UDF as a SARG. Make a hash of it!
I am somewhat uncomfortable blogging this, as I feel that it falls into “Polish a turd” category. Having said that,...
2010-07-02
728 reads
Kent Sql Server UserGroup
One of my back burner projects is to setup a local user group.
I'm delighted to now say that this is...
2010-06-28
404 reads
SQL 101 : Without “ORDER BY”, order is not guaranteed.
It’s as simple as that. If you don’t specify ORDER BY, then the order of your result set is not...
2010-06-26
714 reads
SQL Server XML Schemas
Ever been curious about the schema of , say an SSRS rdl file ? How about the execution plan ?
Not only should...
2010-06-15
494 reads
Challenge 19 – An Explanation of a Query
I have received a number of requests for an explanation of my winning query of TSQL Challenge 19. This involved...
2010-05-27
1,705 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers