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
423 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
669 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
669 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,465 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
397 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
715 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
397 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
712 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
491 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,701 reads
Blogs
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Forums
Parameter sniffing issue with different minutes as opposed to using midnight
Hej, I'm not facing this issue but as I was working another parameter sniffing...
Some query values change when query is run but not others. Why?
Hi everyone I have a 1000 line SQL query that is too long to...
using different credentials when debugging ssis
hi, now and then i want one connection in my ssis pkgs to use...