This my friend, is a thing of beauty...

It always boggled the mind why MSQuery HAD to display things graphically for the parameters to work; anyhows I just gave this a...

That is a difficult one.

First thing I would ask is "What Government agency?" I'm not in the US, so obviously cant really do a proper comparison, but if they were...

yeah I do something similar, my standard method is to randomly type characters (letters, numbers and shift character) until I fill up a line of text in notepad, usually around...

Good Stuff 🙂

I know I have pointed every SQL developer that has come through our doors to at least one of Jeff's articles. Some of the code that man...

I ran all 3 queries with my DOB and the first and 3rd ones returned the incorrect value.

The 2nd query had the correct value.

looking at the case statement I think...

yes, yes you did

I think the confusion stems from the fact that Microsoft don't mention the word proxy in their documentation in any context other than "accounts", which can then have logins attached.

For newbies such as...

Let me preface this by saying I have had very little exposure to 2k5 AS and local cubes, however, after reading MSDN article, I have a question:

As the local cube...

Yeah, not knowing what it is that your application needs to do makes commenting difficult, and if the structure works for your app, then it works for your app

Actually it sounds like you might need to rethink your table design.

If you are storing a single row of data for a single object and only updating the values on...

SPf would help.  I don't think it is currently a part of any RFC (correct me if i'm wrong on that front) as it simply lives in the TXT field of...

Let's just hope that people don't stop thinking as a result of all these upcoming innovations.

Just because we are shown an answer does not mean we understand it. 

I have seen many...

True and correct.  I just put in the example code for the old style. I had actually noticed the execution plans were pretty much identical.

How people can still write in...

Actually, your logic is incorrect.

What are you basing your where statement on? It is where rats_filename is null.

Look at your...

Reymund is correct, there is no such function to do this (who knows why not cause a lot of people want to do this).  I have searched for this kind...