But read my reply (page 1 of replies to this "article") with simple T-SQL to find islands and gaps. I expect it's faster than windowing functions.

/* Occam says, do we really need these new T-SQL constructs? And, when delivering a solution, anticipate that the client may ask some follow-on questions. Thus, it's often...

The novel The Casual Vacancy by JK Rowling features SQL injection as a major plot element. I don't want to be too much of a spoiler so I won't...

A small business cannot hire an employee into every role that is defined by division of labor in a multinational corp. Some small businesses are successful as small businesses....

Sarbanes-Oxley (SOX) does require separation of responsibilities. Application developers are not allowed to "fix" production data. I can't disagree with this.

But I never forget the quote...

The function of calculating storage space for the data and making sure it's backed up-- and that restore works!-- is a crucial function-- but one that is very easy to...

I worked at a university as a data analyst using statistical software in 1983-- yes, 1983. I struggled to manage data relationships using SPSS. Then I was introduced...

If you have $75000 annual income ethical, no path to grow that income, and one-time opportunity for $1 million bonus not-so-ethical-- what would you do?

Question from a DBA--

I have to ask this question because I have no experience doing user interface programming-- I use T-SQL and SSMS, and Excel to deliver reports, for everything...

>>wouldn't it be helpful

It takes a few minutes to write exactly the helpful query you need on tables and indexes, no need to wish

Use this query to identify which columns...

I work as a SQL Server contractor/consultant, typically three to six month assignments at companies having "problems with the databases" so I've seen use of SQL Server at many companies....

>>

Here we've always been of the belief that you shouldn't have tables with date ranges, because tables get created and populated, the query in question works, and the table gets...

What I meant to say in my first post is that programmers should know what a programmer's editor can do and when to use it. Time estimates based on...

I know the big vendors want to hold programmers captive in their IDEs (studios) but I'll never give up the programmer's editor that I use -- Epsilon. Using Epsilon...

If the data is stored in a relational database, the only way to read/write it is with SQL. By definition. So training-wheel programmers write LINQ which writes SQL,...