I'd love to see an example too. But it seems the issue is somewhat complicated by the use of C# and SQL. Hacking this system would require passing a value...

My interpretation of the blog post is that it's so hard to choose the *right* clustered index that you're better off erring on the side of omitting one completely. Not...

Question #2...I am not entirely following this bit:

When SUM() is used with an OVER clause that contains an ORDER BY, then a window frame is "required."  If you...

ISNULL(LAG([to], 1) OVER(PARTITION BY CustID ORDER BY c.TransDate, c.Amount), 0)
Am I misunderstanding something here? The ISNULL check would never return NULL, and thus 0, because you've already...

Or even just MS Access.

As far as I can tell, it seems to work the same either way. Just didn't want to accidentally screw this up.

Yes it's easy to test against '' manually and see the results. I was just curious if there was a function or something so I could see the "value" of...

Lynn, just curious...is there a function we can use to see the "value" that SQL Server is assigning to these text strings to determine if they are "greater than" the...

[post deleted]

It seems kinda arbitrary to assume that if/when a "deactivated" Country reverted to "active", that the previous Active/Inactive flags would still be applicable to its child Regions/Cities. Maybe that's the...

Never even heard of SIGN(). Cool. 🙂

or just dump a guid into each field in your pk.

I still just don't fully understand how salts and the like are supposedly so helpful, because it seems like they have to be stored somewhere. Either in code or in...