Sure.

Hahahhahahahahahaha!

Hehehe..

*snigger*

How you store the data and how you process it should be determined by the type of the data, the type of analysis and the type of results.

Is the...

Cool, so which of the features are you looking to test? Failover clustering...

First thing.

AlwaysOn is a marketing term, not a feature. The features are AlwaysOn:Availability Groups and AlwaysOn: Failover Clustering

Second thing, Developer Edition is licensed only for non-production usage. While it's...

Is SQL the thing using the cpu?

kd11 (5/4/2015)

---

Let me re-word that, I want to fire a trigger when column2, column3, column5 and column9 are updated/insert (not the other six columns) so do I need to use...

Please go and read the blog post I...

Ignoring the syntax problems (which is because you're missing a comma between the two parameters), this is generally not a good idea and will probably lead to performance problems in...

A name specified on a rollback MUST match the name given on the outermost begin tran. You have no name on the begin tran, hence naming the rollback throws an...

Don't use the GUI.

The T-SQL query window in SSMS doesn't have a timeout set (the GUI does), so a written query will run as long as necessary. It may be...

Chat with whoever you purchased it from, they should be able to provide the 2012 media.

That link is a service pack.

MSDN downloads or the Volume Licencing page, depending on how your version is licensed.

You can not include it in a specific trace definition, but that's all. You can't stop a trace from ever seeing the column.

Weird. I suspect because Round returns numeric of the same precision and scale as its input, and 10 won't fit into a numeric (2,1)

As a workaround:

select ROUND(CAST(9.5 AS Numeric(3,1)), 0)...

Not really. No...

All of those functions are likely to cause performance problems if they're called within another select. Data-accessing scalar functions should be avoided whereever possible and especially avoided within another query.

Try...