And another absolutely worth checking out:

Minion Reindex[/url]

I wrote a review of it here[/url].

nhansen pcc (4/13/2016)

Our SAN backup is actually pretty nice; it got me within 15 minutes of the time I wanted. Obviously not quite "point in time" like the SQL restore...

WhiteLotus (4/12/2016)

---

Thanks for the reply guys . Much appreciated !

Actually at that time I also used Performance monitor ( the value for TOTAL SERVER MEMORY was 1.6 GB – the...

nhansen pcc (4/12/2016)

---

So, to kind of re-iterate a question from higher in the thread:

If I do just a log backup in a timed job, and then restore a "snapshot" of...

BL0B_EATER (4/13/2016)

---

Once I have finished...

There go my plans.

Is that when it is? Cool. I can sleep in a little. HA!

I get in to London Thursday morning. I think the train is only 3 hours or so, so I should be to Liverpool by Thursday afternoon.

I'm presenting on Friday, early...

Ray K (3/30/2016)

---

I came up with an abstract. Let me know what you people think.

Groupthink is a phenomenon that is highly destructive -- and all too common in group...

Doug.F (4/12/2016)

---

If you have any recommendations on material concerning this subject, I'm always interested in learning more. Specifically, what I've been looking for recently is a more comprehensive understanding,...

Ron007 (4/11/2016)

---

compare execution plans in DEV and PROD

and use the query hint for index.... that using in prod.

the same index will use in dev if you put as shown...

Both plans are timing out. That means that, depending on the CPU cycles and estimates from the statistics, you could see different plans on different days on either environment. It...

Doug.F (4/11/2016)

---

I was thinking that as well, so I went ahead and ran a:

UPDATE STATISTICS dbo.TableName WITH FULLSCAN

On all tables that are being joined with the SQL query, unfortunately this...

The real problem is, you can't really prevent corruption. You could just have a bit of solar radiation hit the disk at just the right angle flipping a 1 to...

SQL Server will use every bit of memory you assign to it. It'll store data in cache and keep it there as long as it can in order to avoid...