Nice article :).

You have mentioned your data transfer from PolyBase to Azure DW was 300GB/min? That is insane !!! .I am very curious to know how did you move...

DBconsistency check script has been working great. Hats off to you :).

I would like to make few recommendations, i feel there is a basic feature missing, script should be able...

After exchanging few emails with Ola, it is working now. It was a stupid mistake, in the job step the word sqlcmd should be in the first line, i...

Makes sense. I did enabled traceflag 2562, now the estimated for CheckAlloc is 450MB and for CheckTable is 750GB !!!. Looks like enabling trace flag 2562 and getting estimates is...

Thank you for the scripts.

In the database integrity script, my script keeps failing, i did some research but i couldn't find anything online.

sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d master -Q "EXECUTE...

If i was you and this was production, i would either call Microsoft or one of sql experts here. There could be many things going wrong, hard to explain...

Thanks. Looks like i cannot prevent corruption but may be able react quickly.

SQLKnowItAll (9/26/2013)

---

So... I set this up and now I keep getting an error on the step:

Executed as user: new_user. The server principal "new_user"

is not able to access the database "userdatabase1"...

ZZartin (5/1/2015)

---

Well based on your criteria that you never want your queries going to disk you would need enough memory to hold your entire DB....

A good starting point...

I should have provided more details. I have about 5 databases and i know that one of my biggest database is using 80% of allocated memory, this database is also...

Jacob Wilkins (4/30/2015)

---

Ah, my apologies, I fear my explanation was not clear enough.

How much memory to add is exactly what you have at the end of the process I...

Jacob Wilkins (4/30/2015)

---

This is actually something I do on a regular basis in evaluating environments, and the following is the method I've settled on.

I first check PLE during during business...

TheSQLGuru (3/13/2015)

---

"planning to do a scale": what does that mean, exactly??

Done right, SQL Server can be successfully virtualized to run almost any workload. Done WRONG, and you can't...

ScottPletcher (1/13/2015)

---

curious_sqldba (1/13/2015)

---

ScottPletcher (1/13/2015)

---

You don't need to re-count the rows every time.

DECLARE @BatchSize int

DECLARE @RowRount int

DECLARE @TableRowCount int

DECLARE @TableRowLimit int

SET @BatchSize = 10000

SELECT @TableRowCount = COUNT(*)

FROM PtActs WITH (NOLOCK)

SET...

ScottPletcher (1/13/2015)

---

You don't need to re-count the rows every time.

DECLARE @BatchSize int

DECLARE @RowRount int

DECLARE @TableRowCount int

DECLARE @TableRowLimit int

SET @BatchSize = 10000

SELECT @TableRowCount = COUNT(*)

FROM PtActs WITH (NOLOCK)

SET @TableRowLimit =...