Viewing 15 posts - 16,141 through 16,155 (of 39,922 total)
This (http://www.sqlservercentral.com/Forums/Topic993883-146-6.aspx#bm1008735) seems to indicate this is by design. I would shrink the file, looking to deallocate the LOB extents.
May 16, 2011 at 10:00 am
The Rockies are still in 2nd in the West, but the worst record in the NL after the 11-2 start. Not sure they'll be in things this fall if they...
May 16, 2011 at 9:51 am
Hmmm, not sure about image. Have to look it up, but I'd guess sp_spaceused is broke.
Did you delete a lot of the image data?
May 16, 2011 at 9:44 am
Glad you enjoyed it, Gus (and everyone else). Sorry I didn't get down there to see you, but I needed the downtime. Would have canceled anyway since my wife was...
May 16, 2011 at 9:42 am
Ah, sorry. The explanation editor box is small for me and I didn't see that part of the explanation. It's been fixed.
My apologies.
May 16, 2011 at 9:40 am
No, ghost cleanup has already run for you. It's possible the deletes happened on pages/extents that are mixed with live records, and so you can't easily remove those without the...
May 16, 2011 at 9:38 am
On a server you can query sys.servers to see remote servers registered. That doesn't tell you where ServerA is being used, but it can tell you if you are on...
May 16, 2011 at 9:26 am
Short answer, test. Not sure how the 32 bit drivers will work, but I'd install them on a x64 instance and see if you can access things. There is a...
May 16, 2011 at 9:24 am
That's like saying it took me 2 hours to get to work yesterday but it normally takes me 1 hour. Why?
There's no way we can know what took longer. Can...
May 16, 2011 at 9:22 am
Always go downstream first, since the update could change the db version. Things are usually backwards compatible, not forward. So log shipped receivers first, then live servers.
Replication: Do you mean...
May 16, 2011 at 9:21 am
Is this a one time thing or a regular occurrence? If it's regular, have you looked at DTS? You can use the Import wizard from EM to create a package...
May 16, 2011 at 9:14 am
If you have an active connection, you can open all of them without issue. Is there a reason you can't make one connection and leave it open?
May 16, 2011 at 9:11 am
I think that's it. It's a verification of the creator/author of the assembly.
May 16, 2011 at 9:10 am
Deletes are deferred, with the rows "marked" as deleted and then the ghost cleanup task running later. So if you delete something and check space immediately, it will not appear.
Second,...
May 16, 2011 at 9:09 am
Viewing 15 posts - 16,141 through 16,155 (of 39,922 total)