Well, you could say that about life, in general.  But I the trade-off here is data integrity versus performance.  Wrong data versus fast data.  It is not that close...

• This reply was modified 5 years, 10 months ago by peter.row.

I strongly recommend that you upgrade that to the latest...

Oh, what a recipe for disaster!  Since you are requerying the data every time, you have NO WAY to know if the offset is still valid.  You are going...

• This reply was modified 5 years, 10 months ago by peter.row.

From the performance article this one links to it looks like the answer is no - it suggests that doing a count() in a separate query is the best option...

We will soon be able to drop support for SQL 2008R2 from our product making SQL 2014 the minimum and thus we could use this newer paging syntax. However currently...

Seems like this will just add more stuff to be concerned with. Typically I just always use nvarchar thus internationalised text data is not a problem and since we primarily...

Unfortunately with a combination of VPN to server + T-SQL + 3rd party partner it is possible to write reports with SSRS and thus we (dev side) are forced to...

Thank you very much, Peter. Now, I'm concerned about SSRS and how we're trying to go to it. I work for a large state agency, so reporting is a...

Well you have to use your own custom written authentication DLL with SSRS unless you are running the whole thing on a Windows domain then you need to be able...

• This reply was modified 6 years, 1 month ago by peter.row. Reason: wording/grammar

Peter, Customers are learning to move faster, but it's a slow process. I expect that in five years, things will have changed a lot, especially a there are no...

• This reply was modified 6 years, 1 month ago by peter.row.

Since we use SSRS then Azure SQL Server is out the door immediately.

Typically I'd love for us to be using the latest and greatest SQL Server but our customers are...

Some what off topic, I just noticed the "Take a peek into our servers" stuff in the footer.

Isn't this a penetration test failure as you are exposing server names thus...

I think where I'm at we tend to "loose" the comments in our VCS because the developers feature branch everything, so unless you know what branch the change was...

I work for a small company that has three people who work with SQL and VB.net. We are very interested in learning how to use a Version Control System,...

Oh in that case you won't lose anything. JIRA is a task management system it is not a VCS. We use SVN for VCS and JIRA for task management.