Being sa on SQL Server, either on Win2K3 or Win2K8 doesn't give you rights to stop any service. That depends on your rights in the underlying Windows host.

In 2008,...

Please don't post your email in forums. Responses will come here.

It's not quite clear what you are asking. Please spend time to clearly explain what you do not understand. To...

It's lazy developers. They think their time is too valuable to optimize this instead of fixing it right so that network and database resources are not wasted. A simple checksum...

How long do you need to keep this? And how is the data used? It can be handy to keep this information in each record, and it can reduce contention...

Would this help?

http://msdn.microsoft.com/en-us/library/ms178655.aspx

You could scan this for the status of a mirrored pair.

So what is not working? You haven't provided a reason why this doesn't work, or what you want to do. If you want to return all items from the table,...

I'm sure Jeff will like this: http://www.pcworld.com/article/215741/microsofts_hotmail_fail_a_bad_sign.html

It's most likely a people/process failure more than SQL Server, but it does give ammunition to the idea that individual cloud customers might not...

I might check on a few things here.

1. Check the buffer cache hit ratio, and see if it is high. Below 90%, I'd definitely be thinking memory.

2. Check page...

george sibbald (1/7/2011)

---

Steve Jones - SSC Editor (1/7/2011)

---

Mrs. Tripp recommends 512MB segments, so growth around 8GB at a time.

I would guess that depending on your volume, you might get better/worse...

Mrs. Tripp recommends 512MB segments, so growth around 8GB at a time.

I would guess that depending on your volume, you might get better/worse performance with that size. You'd have to...

Math is fun. Was working with my son on negative exponents the other day. Why do we flip it to the denominator? It's what we do, it's the pattern of...

Tom.Thomson (1/7/2011)

---

Nice question, but: why would anyone create a 50GB log file in one fell swoop, rather than say making a logfile of 7142 MB and then extending it by...

ditto

You don't want to always run MAXDOP 1 or MAXDOP 0. There may be queries that cause issues on your system and need modification, but it probably won't be a...

Not that I know of. You can try connecting by IP, port. That might work.

Can you not reconfigure SSRS to point to the new name? Or you don't want to,...