|
|
-
|
|
Every so often on the on-line forums, the question of : Which is better Count(*) or Count(1) ? will occur. So can it categorically be proved than one is better than the other ? What we need to do is populate a table and use both count(*) and count(1) and see if we get any performance differen......
|
|
-
|
|
Well , that was an experience. It was my first time arranging anything like that and it seemed to me that everything came together in the end ok. Things didn't quite go according to plan when I was delayed setting up by the filming of a Jack the Ripper drama in the pub, additionally Ne......
|
|
-
|
|
While the SQL Server NULLIF() function is very handy in many cases, there are a few things you need to keep in mind while using this function. This posts presents some of those scenarios where you might find unexpected results.
For those who have not used it, if the result of the two parameters......
|
|
-
|
|
During his 24 Hours of Pass session, Andy Leonard was asked about the difference between a IsNull and a coalesce operation. Ordinarily, and let’s assume we are only talking about 2 parameters here, there isn’t much difference between them. Certainly you could probably run a million row q......
|
|
-
|
|
In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation.
When executing this code
Code Snippet
<ol style="background: #ff......
|
|
-
|
|
For those that may of missed it, voting for SQLBits sessions is now open. Make your voice heard and get voting. It is quite a choice to pick a mere 10 sessions from the nearly 100 session listed, but it will give the committee a really good idea of what YOU want. Additional......
|
|
-
|
|
I am somewhat uncomfortable blogging this, as I feel that it falls into “Polish a turd” category. Having said that, it is a particularly ugly turd and it does polish up rather well. Though as the saying goes, it is still a turd.
The evils and inadequacies of UDF (User Defined Func......
|
|
-
|
|
One of my back burner projects is to setup a local user group.
I'm delighted to now say that this is up and running. Over the next few months,
I hope to provide some great quality sessions and also provide some ‘virgin’
speakers, myself included, with an environment to practice. ......
|
|
-
|
|
It’s as simple as that. If you don’t specify ORDER BY, then the order of your result set is not guaranteed. Oh sure , there may be situations where the data looks like it is being returned ordered, but this is not really the case. So, for example :CREATE TABLE #Example
(
row_id INTEGER
......
|
|
-
|
|
Ever been curious about the schema of , say an SSRS rdl file ? How about the execution plan ? Not only should you already have the .XSD files , check out the folder ‘Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver’ , but they are also available online here. ......
|
|