CAST(<Calculation> AS NUMERIC(6, 2))

Actually, Gail has a point.  I apparently have 34 points from the past 30 days, and I've barely posted anything I can bring to mind

The following guide for Max memory is as good as any, and better than most.https://sqlserverperformance.wordpress.com/2009/10/29/suggested-max-memory-settings-for-sql-server-20052008/
however, when you talk about "memory pressure" because SQL Server is using most or...

If you're after the query plan, why not pull it out of cache?

james.h291183 (1/6/2017)

---

Ah sorry I wasn't clear, I have the local version of SQL Server 2016, it's just that the Azure DB I was connected to has now run out (free...

SQL Server Developer Edition is now free. You can download that locally.

http://www.microsoft.com/en-us/sql-server/sql-server-editions-developers

Michael Gerholdt (12/20/2016)

---

Initially, AlwaysOn Availability group works from everywhere with clients of various sorts aimed at listener.

Do a manual failover, and now only clients on the same VLAN as the...

Personally, I would always use a date dim for this type of thing. There are many scripts out there which should do most of the donkey work for you.

Firstly,...

Would you not be licensing cores, rather than VM's?

Slight but IMHO important...

Something like this?

select

ag.Name, AGReplica.replica_server_name, ag.Group_Id, agl.dns_name as 'ListenerName', COUNT(db.database_id) 'DatabaseCount'

from

master.sys.availability_groups ag

left join

master.sys.availability_group_listeners agl

on ag.group_id = agl.group_id

left outer join

sys.dm_hadr_database_replica_states db

on db.group_id =...

Sergiy (11/28/2016)

4. Vehicle registrations are not unique for a car.

You may change your car registration any day, by purchasing a personalised plate.

Not to mention - in many countries registration plates...