Steve, Grant, thanks so much for yours answers.

It is a busy DB, in the Top10 of wait types are PAGELATCH and PAGEIOLATCH, the average of pages read, scanned, written per...

Thanks for your answer.

Really, it doesn't seem that there is a negative impact in the throughput, but i don't sure because the DMV doesn't lie... or yes?

Hello.

I think that it is very important.

Changes in SET ROWCOUNT cause RECOMPILES in 2012 and 2014. In 2008 and 2008-R2 not.

Why? I don't know, but the profiler doesn't lie. Without...

Hello.

Plan's set options and the set values in the connections (event audit logon) are the same.

Instalation: SQL 2012 SP1 Standart Edition version 11.0.3128.0 with pool connection.

In the procs we use...

I traced using eventclass 14 (audit logon) and 17 (existing connections). I didn't see changes in the set options.

any idea?

Thanks for all.

Thank you very much for your answer.

I shall look that.

Ok, i thought that it was the best way to determine the cost threshold for parallelism because the values are approximate.

Thank you very much Grant.

I saw some plan with several NodeId with zero value.

Is the total cost of the plan the sum of the EstimatedTotalSubtreeCost relationated with the NodeId that...

Thank you very much.

A example of Row_number()

Suppose that we want to know the number of executions and the duration's average of the procedure's executions of our application in the databases's customers.

We create the...

Erland, thank you very much.

I wanted that exactly.

Excuse me, my english is very bad.

A BD with 2 filegroups filestream.

One table in each filestream.

CREATE TABLE dbo.Table1 (

PkTable1 int NOT NULL,

FileFS1 varbinary](max FILESTREAM NULL,

...

My idea is several filegroups with partition scheme, because i need to separate data in 4 geoghraphics areas and also to separate historic, configuration and master data.

For that, my question...

Thank you very much.

Thank you very much.