Viewing 15 posts - 16,186 through 16,200 (of 39,970 total)
I see people go both ways on this. Ultimately since you can't usually guarantee that xx piece of technology caused the corruption, you bring the system back online. I've seen...
May 16, 2011 at 12:11 pm
Jagadeesh Medabalimi (5/15/2011)
For me, SQL Server would be great if they can deliver exactly what they promise.Productivity, Security, Performance, Scalability, Robustness, and finally solid ROI.
What does that mean? That's a...
May 16, 2011 at 10:03 am
I agree with Sean, nvarchar won't really hurt and if you have EE, you can compress the data, so it won't double the space if not needed.
However, even uncompressed, I...
May 16, 2011 at 10:01 am
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
Viewing 15 posts - 16,186 through 16,200 (of 39,970 total)