ScottPletcher (11/4/2015)

---

river1 (11/4/2015)

---

Hi,

I saw this job below which runs from 20 to 20 minutos on my production server.

Is it normal to have a statistics update every 20 minutos?

...

and ...

You can run this query:

SELECT

[sch].[name] + '.'...

river1 (11/5/2015)

---

Hi,

I was using performance monitor to check the activities on my disks.

I saw that with frequence it goes to 100% . Although it's an OLTP system should this be...

Hi,

There are performance counter for the disks.

You can measure for example

Avg. Disk Sec/Read and Avg. Disk sec/Write counters

in the Performance monitor tool (perfmon.exe). You can find them under Physical...

You'd better not make a data/schema comparison after and...

Are there any jobs that could make update/insert of data?

Do you need data compare, schema compare or both?

It's definitely not desired read/write per sec times. We had a case with a SSD disk that went gone ... first starting with 0ms response times and increasing to 1.5sec....

Hugo Kornelis (10/7/2015)

---

The question is okay (though I was hoping everyone would know that - not every table needs an IDENTITY primary key, you know?)

I don't understand the discussion on...

Thanks for the great articles. The SQL folks definitely need this knowledge.

Yes, it's an easy question. It's a way how to prevent TRUNCATE on a table(s), especially in datawarehouses.

Clever approach from Superdoc.

Very basic question.

Use this

SELECT t.ProductID,tmp.MaxSeqNo,t.Balance

FROM YourTable t

JOIN

( SELECT ProductID , MAX(SeqNo) [MaxSeqNo]

FROM YourTable

...

Jacob Wilkins (7/31/2015)

---

A little more detail on what happens here:

1) Creating and populating the table. Nothing special to see in this bit.

2) Running the SELECT * from the Query2 window....

Question is not formed well.

The Query Store feature is not enabled for which databases?

- It's not enabled for all user databases by default. And you cannot enable the...