I am surprised that no one has mentioned this, but there is another option. It does require a downtime, but may not take as long as using a defrag...

R L Reid (7/7/2008)

---

Jeffrey - Interesting post. I've taken MS's "don't install a CU without a specific reason" seriously (even though I modify registries and list systems files, ha!)

And...

The only thing I can think of is that maybe you have SQL Server setup in the cluster group on that server instead of in the SQL group.

pradeepkk2003 (7/6/2008)

---

Hi All,

I am new to this so need some expert guidance. In one of my datetime field data is stored in the format

yyyy-mm-dd hh:min:sec.

I am trying to retrieve the...

CU = Cumulative update. This is a rollup of all of the post SP2 hot fixes that are available. There is also CU7 that is available.

Unless there is...

Maybe you can adapt the following to work for you.

If object_id('tempdb..#test') Is Not Null

Begin;

Drop Table #test;

End;

Go

Create Table #test (Sr1 int, Col1 char(8), Col2 int, Col3 char(6));

Go

Insert Into #test (Sr1, Col1,...

What are the expected results you are looking for?

Please read the following article:

Best Practices: http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you provide the create and insert statement and expected results, it will be a...

What version is the server running, and what version are your client tools on? If you are not on at least 9.0.3054 for both - then you will have...

Well, the first thing you need to do is identify how you will determine whether or not your table has a new row (inserted).

Do you have any date columns on...

In SSMS, connect to the server using Object Explorer - right-click the server name and select properties. Select Memory and you can change it there.

From a query, you can...

To add to what Carl has given you, I would recommend setting the max memory for no more than 20GB (leave 4GB for the OS) and set the min memory...

Yes you are right - 0 and 100 are exactly the same. I thought I had read where 0 would actually leave a small amount of space, but I...

Congratulations Jeff and Michael - well deserved.

talentguy123 (7/1/2008)

---

We have a customer that is getting an extra file in their database

backup. this is not one of our nightly jobs. Can you please ID

where this job is run...

Also check the fillfactor on your indexes - could be causing lots of page splits if this is too high. Note: a value of 0 is almost equivalent to...