Viewing 7 posts - 16 through 22 (of 22 total)
so to test whether I'm crazy or not, I did a restore on the 3TB database onto a test server and deleted every table except for one table, which is...
July 19, 2012 at 12:21 pm
log space is not an issue.
I see the DBCC process running, but it almost looks like nothing is going on. I would expect to see some heavy I/O activity,...
July 17, 2012 at 2:42 pm
this is not the log I am trying to shrink, it's one of the data files I am trying to shrink.
July 17, 2012 at 2:19 pm
I actually did do that for one of my packages, but that was easy because it only involved one table. I would have to hate to write a separate...
June 29, 2012 at 1:11 pm
well, this is a time series table, so the datetime field is a timestamp. However, the timestamp is not a physical representation of when the row gets inserted into...
March 19, 2012 at 9:41 am
it's actually 50 billion rows....cut down to about 12 billion rows. Table is not wide though, it's basically like a key value pair with an ID, a datetime, and...
March 17, 2012 at 12:40 pm
anyone? surely someone else must have this issue?
March 17, 2012 at 11:50 am
Viewing 7 posts - 16 through 22 (of 22 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy