There isn't an Availability Group in SQL Server 2008 R2. That technology was introduced in 2012. You have a cluster, or really, a Failover Clustered Instance (FCI) with two nodes...

This is based on your language setting.

SELECT top 10
 *
 FROM sys.syslanguages

There is a datefirst column here. If you change the language, you change this.

Apart from that,...

I find myself getting annoyed or frustrated at times with other's work schedules. Either they're behind, or they are go-getters and doing more than ever. Depending on my mood and...

Put the code inline. We have a button (Insert/edit code) above in the toolbar for formatting.

For the Access file, you can zip it, but not many people want to download...

True. In most places I've worked, we move tapes offsite, in case of an environmental issue. There's a rotation involved. If you keep all the tapes online, you're defeating a...

There were a lot of columns in there, and I grabbed the first bit on the screen. I added Unit_Cost to the display in the question.

Some of the differences are driven by patents, which is silly. I wouldn't be surprised is there is some legal reason for the upper left/upper right. Or maybe just competition....

If I knew I had to look for a job next Jan 1, I would immediately start training on Azure. I don't really know anything about it but I...

i started to juggle

Still terrible at it but apparently it has decent amount of things it does for you:

• • improving hand eye connection

• ...

Yes, it is

Never been much of a Corvette fan, but they've grown on me. I did love the Corvette Summer model, but those are too expensive.

That's because I can't read a calendar.

Corrected.

You have parenthesis, not brackets in the original query. Not to be pedantic, but we can get confused if we're not all using the same nomenclature.

The WHERE clause is applied...

+1 Billion to Roger Plowman for his post above.  I'll also add that commenting code when you're writing it is pretty simple.  The first thing I normally do is...

Please post the code with a repro that has some data. We don't allow .sql files to be uploaded.