Very useful article, but I can't help but wonder if this was just an excuse to show off that you have a 7970 clocked at 1010MHz!

I read some time ago...

Thanks 🙂

I'll be working on this stuff a bit more over the next couple of weeks once I've got my currently development version in live.

ah cool. Good to know I'm not abusing the udf 🙂

Although I will admit to using them in 1 or 2 insert into select constructs but with no more than...

Thanks for the reference it'll be useful in the future.

Although I don't think Scalar vs ITVF is really a big issue for me as I'm not querying the scalar functions...

Right now at the quietest part of the day with probably half the company having taken the day off our busiest SQL Server database is fluctuating between 250 batch...

Lol thanks. Once I've found an execution plan that works nicely I'll do some research on convincing the sprocs to use the right one and will probably end up asking...

I often find articles written by people who speak English as a second language are done to a better standard of English that those who speak the language natively.

I speak...

Lets make a list.

Pacifically instead of specifically

Irregardless instead of regardless/irrespective

To instead of too

Your instead of you're

Lose instead of loose

Dose instead of does

Heigth instead of Height (people round here even pronounce...

Owe eye could tell a tail or too about my spelling.

excellent article but I very much dislike Grammarly.

it said I had 8 critical errors in 1 paragraph from a systems...

I know this is an old one but maybe allowing users to log in with Facebook or LinkedIn would be a happy middle ground - most people have one of...

Is it just my browser or is this article missing some code? eg all of it?

:rolleyes:

cheers

Wow... An I thought my 20GB reporting database had lots of records in it...

Brilliant thanks guys.

Turns out our supplier quoted us for 2x hex core cpu per machine because she thought we could do with an upgrade.

Clearly, we only ever use the best,...

Lots of copies..This is all for 1 database...

production application:

Main server:

primary copy of the database

backup image from previous night

DR/HA server:

copy of the database

UAT server:

2x copy of the database

reports systems:

vm report...

disadvantages:

2012 might be more expensive to implement depending on version/hardware

not all 3rd party software vendors have confirmed official support for 2012 as a backend database (check into what software they...