Steve Jones - SSC Editor (1/12/2016)

---

peter.row (1/12/2016)

---

Really Steve?

A Google site appears not to work on an MS browser? Did you read the rest of my post?

Obviously we are all biased...

ZZartin (1/12/2016)

---

There are a disturbing number of applications whose web interfaces will only work in IE. And while newer versions of IE might be fully compatible with current browser...

Really Steve?

A Google site appears not to work on an MS browser? Did you read the rest of my post?

Obviously we are all biased by the sites we use. For...

I predominately use IE and Edge and this piece (and some of the comments) are just FUD frankly.

From IE9 onwards each version got better and better in terms of web...

It would be interesting to see some performance information with some large data to see how this performs.

I'd always thought that a lot of these kinds of operations would be...

This is clever but ultimately I would never use it.

It is wide open for SQL injection attack and it basically is a hello world type query in the really world...

Added a cursor just the other week when a recursive CTE used in a cross apply was causing a query to take over the .NET default 30 second timeout -...

The script in the answer fails because of the following:

select @a, @b, @c

As @c is not declared (nor is it used elsewhere in the script).

I answered neither because neither option answers the question posed.

You say you have an identity column, you add 4 rows and want to add a 5th.

Since this is a table...

+1 to the badly phrased question.

I put none of the above because as with most things with SQL it depends.

With the cost of RAM these days I would never run...

TomThomson (8/6/2014)

---

peter.row (8/6/2014)

---

In typical SQL style actually the answer is "it depends" - on how you work.

Hovering the mouse may be quick but not that helpful since as soon as...

In typical SQL style actually the answer is "it depends" - on how you work.

Hovering the mouse may be quick but not that helpful since as soon as you start...

Dan Messenger (8/5/2014)

---

If you have the Hyper-V Platform role installed then your 'host' OS is indeed running inside a hypervisor - everything is as Hyper-V is a Type 1 Hypervisor.

At...

My mistake I have the Hyper-V Manager installed on my Win 8.1 Enterprise box.

Under windows features this is listed at the bottom of the umbrella Hyper-V tree item as:

- Hyper-V...

Well as mentioned originally I tested this on my Window 8.1.1 64Bit machine with SQL Server 2008 R2 (SP2) 64Bit which also happens to have the Hyper-V Manager (client) installed...