|
|
-
|
|
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......
|
|
-
|
|
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......
|
|
-
|
|
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......
|
|
-
|
|
To me, as a professional software developer, SSIS is severely hindered by its lack of the ability to pass variables into a package. It is such an obvious and simple piece of functionality that it seems incredible to believe that, within SSIS as standard, a parent process cannot tell a child how to b......
|
|
-
|
|
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......
|
|
-
|
|
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......
|
|