I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 219, comments - 2287, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

February 2008 Blog Posts

How SQL Server short-circuits WHERE condition evaluation

It does when it feels like it, but not in the way you immediately think of. A few days ago Jeff posted about short-circuiting wondering how it works and since I've played with this a long while ago I thought I'd share my results. Hopefully it will make it clearer how SQL Server behaves when evaluating conditions in its WHERE clause. So let's see how it's done in greater detail. First we must create our test table with some sample data which will be defined like this: IF OBJECT_ID('t1') IS NOT NULL DROP TABLE t1 CREATE TABLE t1(id INT PRIMARY...

posted @ Monday, February 25, 2008 10:54 AM | Feedback (10) | Filed Under [ SQL Server ]

Weekend Fun: Bruce Schneier Facts

We all heard about the Chuck Norris Facts, right? Well if you're a fan of security you have to be familiar with Bruce Schneier and his excellent blog. What I didn't know is that he also has a collection of facts! Just how cool is that???   Here are some I found funny: - For Bruce Schneier, SHA-1 is merely a compression algorithm. - Bruce Schneier once compressed a single bit of information to half its size. - Bruce Schneier doesn't need backups because his hard drive knows that failure is not an option. - Bruce Schneier shaves with Occam's razor. - Bruce Schneier knows the last digit of...

posted @ Saturday, February 16, 2008 12:19 AM | Feedback (2) | Filed Under [ Misc ]

Watershed Image Segmentation in C#

This is an implementation of the Grayscale Immersion Watershed Segmentation in C# based on the

Vincent-Soille immersion watershed algorithm

 

Read Full Post.

 

posted @ Monday, February 11, 2008 6:46 PM | Feedback (69) | Filed Under [ .Net ]

Integrating Profiler and PerfMon Log Files

I've written an article here on SQL Team about Integrating Profiler and PerfMon Log Files. Troubleshooting SQL Server requires the use of both PerfMon (Performance/System Monitor) and SQL Trace files created by SQL Profiler or directly by SQL Server trace. Analysis of the gathered data is much easier if you can correlate your trace file with the PerfMon counters. In this article I'll show how to create a PerfMon counters log file and SQL Profiler Trace file, how to read them both and how to correlate the two files in SQL Profiler.   Integrating Profiler and PerfMon Log Files

posted @ Friday, February 08, 2008 2:49 PM | Feedback (0) | Filed Under [ SQL Server ]

Back to Basics: Count, Count, Count, Sum or how to Count

Probably everyone is familiar with the Count(*) function in SQL Server. But there seems to be a great deal of confusion amongst youngsters (SQL wise) about how all its possible options work. Let us banish the confusion back to the dark realms where in belongs to: DECLARE @t TABLE (val INT) INSERT INTO @t SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT NULL UNION ALL SELECT NULL UNION ALL SELECT 4 UNION ALL SELECT 4 UNION ALL SELECT 5 SELECT COUNT(*) AS CountAll, -- counts all rows COUNT(val) AS CountAllNoNull, -- counts rows that don't contain NULL COUNT(DISTINCT val)...

posted @ Monday, February 04, 2008 5:24 PM | Feedback (4) | Filed Under [ SQL Server Back to Basics ]

Powered by:
Powered By Subtext Powered By ASP.NET