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,...

WayneS (1/6/2011)

---

So, is the second part related...

WayneS (1/6/2011)

---

I guess I hit enter... I've PM'd Steve to see if he can take it out, all I can do is edit...

trash

Not as far as I know

http://msdn.microsoft.com/en-us/library/ms151216%28v=SQL.100%29.aspx

servername must match the windows name. Sp_dropserver/sp_addserver needed.

Also, you can do a netstat from the command line, and see what port is open and listening. Should be 1433.