so can I uncheck the GRANt permission for EXECUTE (...

HanShi (9/11/2014)

---

I haven't installed a CU recently, but if I recall correctly all SQL services need to be stopped. During the initial configuration steps a check on locked files is...

HanShi (9/10/2014)

---

The installation of a CU is basically the same as the installation of a SP. Of course: to be sure and on the safe side you should first execute...

WhiteLotus (9/9/2014)

---

Hi All ,

I would like to apply Cumulative update into production ( SQL Server 2008 ) .. I am a bit worried that I will break something ..because I...

Thank you...

Adi Cohn-120898 (9/2/2014)

---

The profiler has the columns Application Name, Login Name and Host Name. You can use them to figure out from which application, login and machine any statement...

Luis Cazares (8/28/2014)

---

The RIGHT function is one option, you could also use STUFF function. Additionally, you could cast your result as a numeric data type.

However, the most important thing to...

TheAccidentalDBA (8/26/2014)

---

As Grant mentioned, you can increase the log back up frequency. Can you do one at 3AM?. Do you have any batch jobs running? If so, its quite possible...

Eirikur Eiriksson (8/25/2014)

---

I guess the threshold is a...

Wison (8/25/2014)

---

actually, we use receive top 1 in the interface sp.

i think what you need to do is:

1. increase the max_queue_readers parameter in the queue definition. the default is 1....

TheAccidentalDBA (8/25/2014)

---

Do you check the index fragmentation for a rebuild (http://msdn.microsoft.com/en-us/library/ms189858.aspx )?. This way you will not rebuild all the index. Your logs might be growing big...

Grant Fritchey (8/25/2014)

---

How long does it take to rebuild your indexes. You would at least want to get a log backup at the beginning and end of that process (no,...

Shawn Melton (8/24/2014)

---

Unless you checked the log_reuse_wait_desc at the time of the error it likely cleared up by the time you got into the office to check it. It was...

WhiteLotus (8/22/2014)

---

Hi all ,

A client of mine complaint about his Service Broker Message queue..

last week the number of queue is around 2000 something and today become 3000 something ...they want...

Jeff Moden (8/19/2014)

---

WhiteLotus (8/19/2014)

---

Thanks for your response! appreciate it !

Yes I use SOLARWIND to monitor...