Good point, I can add that, once I figure out formatting.

I just messaged Steve Jones to help with creating a poll that is multiple-choice across groups and single-choice within a...

Oh, the formatting seems weird, it doesn't show all options.

How do I delete this one, and how do I increase the number of options in poll ?

Nevermind, found a workaround. The code was as such:

select name, count(*) from employees group by name

select * from RemoteServer..departments

I modified it to :

SET ANSI_WARNINGS OFF

select name, count(*) from...

I found this query that checks how many plans in cache actually used parallelism in order to compare their cost with COP (cost of parallelism):

SELECT

CAST(n.value('(@StatementSubTreeCost)[1]', 'VARCHAR(128)')...

number of physical cores in one NUMA node

I forgot to mention, the servers are virtual (VMware). Does usual NUMA/core setting on physical servers still apply to VMs ?

Make sure cost...

@josh, i meant to say if that TDE isn't implemented, they could recover it.

Commvault uses its own deduplication algo for databases, which massively reduces backup size, and I...

Just found that - replication started failing immediately after an update job that ran at 9pm yesterday on Publisher.

The job runs every night, and it was never an issue all...

<bump>

Any feasible tuning possible from the .sqlplans ?

Attached .sqlplan from TEST & PROD

I already ran sp_updatestats on both.

Off-hours I plan to do an update with fullscan.

@Eirikur, yes I checked there but was wondering if any 'undocumented' flags.. guess not.

@lowell, yes I resorted to that

@lowell,

I thought I was going crazy / blind too.

So had a colleague look at my screen while i hit the NEW-QUERY button (which by default opens a same...

no one else experiencing this ?

when you run select @@version on your 2012 SP2 server, does the result show '(SP2)' ?

Gail - yes, it's the same db. Lower environments were created using Production database backup.

Eirik - YES, they are in SIMPLE recovery !

Andrew - It is a different server however - backup taken on PRODUCTION, while restore done on TEST

but the logical & physical...