GilaMonster (6/26/2015)

---

Why would you want more than 20% of you memory to not be used? Surely the point is to ensure that the data cache is used, not that SQL...

Thanks a lot... 🙂

A reindex also updates stats with a good sample...

james.a.payne (2/17/2015)

---

OP: Something that might be useful for you down the track is to only reorganize indexes that allow page locks. Otherwise it will throw an error and the index...

ScottPletcher (2/17/2015)

---

There is no such thing as an accurate, global freespace percentage. Freespace needs to be set index by index. Thus, a generic rebuild should never specify a...

haha... 106 as at last count... I would have mentioned the application but I fear being sued 😀

shivendrakumaryadav60 (2/16/2015)

---

Hi,

. wow..nice script...:-)...very true.....I am having the same scenario. And index maintenance become a very crucial in this situation. I am using more or less same script...

maliqiakbar (1/30/2015)

---

Select @@version is the command to give you information about sql server edition that is used. If you cannot even go to the instance have you try restarting the...

In my case we are already past 180 days so I can no longer access the instance to check @@version. Could this...

The instance is not clustered.

I ran setup and used the maintenance> Edition Upgrade option on installation centre.

kdburger (4/20/2012)

---

I'm just a novice, and probably shouldn't even post to this site. But, I wanted to ask what is likely a rediculous question. How did you 'extend the...

... Thus, My general recommendation in a SAN environment would be to present a new LUN to the server, partition and format it correctly, then move the data files. Yes,...

The replication Monitor also helps. Rightclick your pubication and select Launch Replication Monitor.

Wiered as it may seem, I am relatively new to Powershell. I notice in the script you declared a variable that append the current date to the backup file name....

quackhandle1975 (6/29/2012)

---

Nice article, I have implemented this a number of times, as much as you try and coerce your boss/cient into using/buying 64bit OS/SQL, you have to work with what...