muthukkumaran Kaliyamoorthy (6/23/2011)

---

tt-615680 (6/23/2011)

---

Hi All,

I have an SQL 2000 Database which is 135GB and I want to perform "Shrink Database" but I want to know what is the maximum percentage...

SELECT GetDate() as Run_Date,

rtrim(Cast(@@ServerName as varchar(100))) as Server,

spid,

blocked,

waittime,

sb.name,

lastwaittype,

...

Thank you for the reply.

The user that is suppose to have run the particular query is not running anything at the time.

Thank you

Thank you for your reply. I have been using SQL Profiler to see if the program is running but it's not there. It is an SQL Agent job that seems...

Thank you so much for all your advice

GilaMonster (2/26/2011)

---

Query sys.database_files

2. When to truncate the log files in order to free up space, therefore the the server...

LutzM (2/21/2011)

---

Please provide the sample data your result is based on in a ready to use format.

Your expected result and the "sample data" provided so far don't seem to match....

I am only getting the data from one table which is:

orderid (int)

customer (varchar)

Deliverydate (varchar)

ChangedDate (datetime)

I am only getting the data from one table which is:

orderid customer Deliverydate ChangedDate

12345 Bob...

All the other jobs seem to be fine for now. The indexes are dropped on a daily and...

Thank you for the reply. Yes I...

s_osborne2 (1/18/2011)

---

You can always set the degree of parallelism to 1 if you are having problems with particular queries. We use it sometimes.

Example:

SELECT

*

FROM

...

ALZDBA (1/18/2011)

---

setting it to 1 will prevent query parallelism for your instance.

If that is your goal, that's the way to do it.

Is that your goal ?

On most of our oltp...

s_osborne2 (10/11/2010)

---

Does it now always fail at this step or is it just sometimes?

We've seen a problem recently with xp_smtp_sendmail being unable to run on SQL Server 2008 64 bit...

Grant Fritchey (10/5/2010)

---

tt-615680 (10/5/2010)

---

Yes, I know there are many queries or sysyem sp's that cannot...

Grant Fritchey (10/5/2010)

---

tt-615680 (10/5/2010)

---

GilaMonster (9/29/2010)

---

The default...