Viewing 15 posts - 12,046 through 12,060 (of 22,214 total)
The end of the backup process marks transactions as rollforward or rollback depending on if they're completed or not when the backup finishes. So you can get both situations, the...
August 17, 2011 at 8:58 am
The size of the transaction log is usually reflective of the size of the transactions. Have you tried monitoring the freespace in the tran log during the index rebuild. I...
August 17, 2011 at 8:56 am
A server side trace capturing a reasonable number of columns and events (depending on the events, statement level execs for example would be bad) will not be noticeable on most...
August 17, 2011 at 7:41 am
Or Team Foundation Services, or Vault, or SVN... anything but VSS.
August 17, 2011 at 7:04 am
I'd suggest doing a search online for Bill of Materials database designs. There are a bunch out there because it's a common problem. Use one of them as the basis...
August 17, 2011 at 5:52 am
Wow, I didn't even know DBGhost was still around.
Getting your database into source control is actually pretty easy. The hard part is establishing a disciplined development and deployment process around...
August 17, 2011 at 5:50 am
If you don't create tables with FILESTREAM, why set it up on the database at all?
August 17, 2011 at 5:37 am
Just remember that while an identity value does uniquely identify a row, it doesn't uniquely identify it for the business. So, just as an example, you need to store first...
August 17, 2011 at 5:37 am
In general, throw disks at the problem. Assuming a reasonably well tuned set of queries, good cpu and enough memory, the most likely issue with that much data is I/O,...
August 17, 2011 at 5:29 am
Statistics are stored with the database. They will be the same on the restored database as they were on the backed up database. This is true even between versions, except,...
August 17, 2011 at 5:27 am
What level are you looking for? Low level, this is how indexes are stored kind of stuff, or high level, this is what SSRS is for which is different than...
August 17, 2011 at 5:24 am
BrainDonor (8/16/2011)
Grant Fritchey (8/12/2011)
August 16, 2011 at 5:26 am
Have you had a radical increase in the size of the database? If it's exactly the same size (or near enough to it), then I'd guess some form of contention....
August 15, 2011 at 12:18 pm
Kiara (8/15/2011)
Grant Fritchey (8/15/2011)
Anyone you need to check with to say nice things about Red Gate? Nope!
However, pass the word on how the presentation went, how many people attended, if...
August 15, 2011 at 11:35 am
Kiara (8/15/2011)
August 15, 2011 at 10:21 am
Viewing 15 posts - 12,046 through 12,060 (of 22,214 total)