This article came in the nick of time. Needed to create a view using distinct data. But you cannot put an index on a view that uses DISTINCT or a CTE. I ended up using the GROUP BY method, but you must use COUNT_BIG for some reason. Update: Turns ...

I'm curious as to why "coalesce" is not in IntelliSense options. ISNULL is, but not Coalesce. Also, when I am writing wondow functions, sometimes "PARTITION_FRAGMENT_ID" has stuck itself in there. It drives me nuts. Thanks for the ctrl+shift+R hint....

We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

select space(6)+cast(0x486170707920566149656E74696E6592732044617921 as varchar(100)) For Feb 14th....

select space(6)+cast(0x486170707920566149656E74696E6592732044617921 as varchar(100)) For Feb 14th....

I work with academia frequently, and therefore, get a chance to interact with students and experience the issues they face first hand. I recently had a very interesting experience during one of these visits. I will try to present the experience as a sto...

OK, I'll admit. I had no idea if you put a number after "GO" it would do that command x number of times. Thanks for these little tidbits of info....

OK, I'll admit. I had no idea if you put a number after "GO" it would do that command x number of times. Thanks for these little tidbits of info....

Does the numbering system imply the preferred method to select top records? ...