Viewing 15 posts - 16,981 through 16,995 (of 39,902 total)
You should not upgrade past what the server is. If you have dev edition, keep that in sync with the server by applying the same SPs and CUs.
January 24, 2011 at 9:52 am
Congrats, Grant.
Somehow I'm not sure this will get me out of UK trips.
January 24, 2011 at 9:50 am
The log can still grow if you have one large transaction. Without knowing what the process is, it's hard to tell, but log backups do not function in simple mode....
January 24, 2011 at 9:47 am
You calculate a checksum across the page. When you read the page, you recalculate the checksum. If it doesn't match the value stored in the page header, than you have...
January 24, 2011 at 9:37 am
Do you already have MS products? There is Small Business Server, but that feels like a large load for one system.
I might look at Standard edition unless you really think...
January 24, 2011 at 9:07 am
SanDroid (1/24/2011)
Steve Jones - SSC Editor (1/24/2011)
January 24, 2011 at 8:39 am
The overhead is listed at 1-2% overhead from what I saw in a presentation by Paul Randal.
If you can't spare that, you have capacity issues.
January 24, 2011 at 8:36 am
Kevin, very true. I think this one is mostly a 100 level, sometimes going to a 200 level of stuff. It probably needs to be separated out to Dev and...
January 24, 2011 at 8:35 am
If you are set to simple mode, transaction log backups do not work or matter. Each checkpoint (every few minutes) results in a clearing of committed transactions from the log.
2GB...
January 24, 2011 at 7:53 am
Good suggestions. I'll add some of these, as well as clean up the abstract a bit.
January 24, 2011 at 7:48 am
Interesting comments. I've never had anyone mention the title, but those are good points. I'll see if I can come up with something else that might better describe this session.
January 24, 2011 at 7:47 am
Corruption usually occurs from some hardware issue. A voltage fluctuation, a bad driver, some anomaly that cases the bits written to disk to be incorrect.
January 24, 2011 at 7:45 am
You should pass in the user ID as a parameter for stored procedures. This would allow you to better understand what is happening.
you can get the command a session is...
January 24, 2011 at 7:30 am
We both do kenpo karate, about 4 years for him. I've studied a few more arts, but this was a good local fit for my son. Lots of Muy Thai...
January 24, 2011 at 6:54 am
Definitely not SQL related, but my kid got his black belt today. Very proud of him.
January 22, 2011 at 6:36 pm
Viewing 15 posts - 16,981 through 16,995 (of 39,902 total)