Like the hanko[1] in Japan, these devices are becoming an extension of ourselves. It is not uncommon for a device to have our authority. Many a tablet or smartphone has...

Steve Jones - SSC Editor (9/15/2015)

---

Sean Redmond (9/14/2015)

---

Hi Steve,

There are several metrics that can be used:

1. How fast can an everyday problem be solved? Does a complex query...

Hi Steve,

There are several metrics that can be used:

1. How fast can an everyday problem be solved? Does a complex query take the DBA 30 minutes to do...

SQL Server is expensive. It also needs an NT Server licence. One realistically needs new licences every 7 or so years.

This must be realised by senior management when the decision...

Firstly, if it ain't broke, don't fix it.

Secondly, is this not a task for the sysadmins? They are responsible for security. If they are happy that the server is nicely...

I wanted to make the point that one has to remember time-constraints.

Many problem-solvers are perfectionists and they want nothing but the perfect query. It may take them 2 weeks when...

PAH» Your comments "Better to listen and nod in most cases." remind me of a brief dip into the book Men are from Mars, Women are from Venus. one of...

I use the analogy of cost-based heuristics of the SQL Server query engine. It doesn't always choose the most efficient implementation of a query, rather just one that is fast...

In my experience, people who use DBs at least an SSMS level fall into several categories (and often they overlap) and they are:

• People who design DBs;

• People...

Hi Gail,

This query returns the number of threads per username, per title, per month, per forum within a specific timerange.

Since the limiting factors here are in the dbo.Threads table...

My thoughts on the issue of salary:

If salaries are to be revealed for one, they are to be revealed for all. As with others who work in public services,...

When asked once how long it would take to accomplish a new task, I answered that I didn't know. I was told that that was the wrong answer. I was...

Hi Steve,

I believe that they should have released it initially as an option they way that Reporting Services v1.0 for SQL Server 2000 was — with its own installer....

Hi Gilamonster,

It's not the space that is the problem, it's the inherent limitations of the In-Memory system. I have been given a 64GB system that I may use for...

Hi Steve,

How often do we get a version that can promise a 10x improvement to a system? I see In-Memory-OLTP as the biggest change, or, at least, potential change...