Viewing 10 posts - 271 through 280 (of 280 total)
Agree, not a good thing to do. Putting your DB into the full recovery model with both full & trans log backups should do the trick.
October 18, 2011 at 7:40 am
Thought this was straightforward but sadly not
Surprised that the NULL was not caught in the check constraint...
More coffee required.
October 17, 2011 at 2:51 am
You need to create endpoints, not listeners (that's Oracle).
See the article here -> http://technet.microsoft.com/en-us/library/ms181591.aspx
October 13, 2011 at 10:29 am
Surely this is a permissions issue? Are you using a domain account to log in at both locations, or are you using two different local accounts? Have you...
October 13, 2011 at 10:27 am
Do you have any detailed information in the error logs i.e. error code? What was the exception? How has the asp code changed (if it has) since the...
October 13, 2011 at 10:22 am
Ensure the windows account newUser you are using is explicitly specified as a separate login of type Windows authentication. Theoretically if newUser is a member of a group with...
October 7, 2011 at 8:53 am
You could split out the data files into different file groups and drives, then configure your SAN and switches for multipathing. This could potentially double or at least increase...
October 6, 2011 at 7:34 am
Could you imagine the I/O on a bulk insert to a table with 999 nonclustered indexes though?
I think the DB engine would actually explode. 🙂
October 6, 2011 at 2:55 am
Hah, fair enough! This is not the first time I've heard that opinion aired!
Out of interest, does anyone know why AUTO_SHRINK is such a bad idea? I know...
October 4, 2011 at 12:07 am
You could set up an auto job to shrink the database(s) when your backups are taken, which would maximise available space at all times.
I'd only recommend doing this in...
October 3, 2011 at 10:31 am
Viewing 10 posts - 271 through 280 (of 280 total)