Viewing 15 posts - 17,161 through 17,175 (of 39,903 total)
Javascript is amazing. It makes web pages so much more interactive and interesting. It runs in a fairly low privileged manner under your account, and it's an amazing language.
It's also...
January 8, 2011 at 9:16 am
I think it's more a question of how small is it until you get the "yes-it's-the-whole-fist-customer-service" treatment.
January 8, 2011 at 8:59 am
Mark has written a nice suggestions, but it would be nice to know *how* you back up the database and then shrink the log.
- a full backup does not...
January 8, 2011 at 8:54 am
Good thought, Gus.
A few wait stat posts:
http://www.sqlservercentral.com/blogs/sqlrnnr/archive/2010/12/13/wait-stats-resources.aspx
January 7, 2011 at 1:06 pm
Eric has summarized nicely what I would do.
One note, be sure adding the identity will not break other code.
January 7, 2011 at 1:04 pm
qur7 (1/7/2011)
Now...
January 7, 2011 at 1:03 pm
qur7 (1/7/2011)
Dont want to sound too much of a rookie but how would I proceed after that ...
lets say based on your code the value is...
January 7, 2011 at 1:02 pm
Elliot, we are not disagreeing. I was responding to the OP as a clarification. What you have written is correct, but this is not a difference because of the OS...
January 7, 2011 at 1:01 pm
cengland0 (1/7/2011)
mtassin (1/7/2011)
Transaction log backups are not a major change. It's a backup. SQL server does the rest.
I disagree -- it is a major change. If it...
January 7, 2011 at 12:56 pm
I am wary of backing up to the same file every time. It is asking for an issue. What if the tape failed, you didn't fix things, and your backup...
January 7, 2011 at 10:57 am
If the log needs the space, you're going to run out of space anywhere. A log backup allows the log space to be re-used and overwritten.
Feeling like the log...
January 7, 2011 at 10:21 am
You are welcome.
This might help you for future questions: http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 7, 2011 at 10:18 am
Sorry, query the table in an SSIS task. Based on the value, then you would execute the proper code.
set @currentmirror = select status from dbmirroring table
if @currentmirror is null
...
January 7, 2011 at 10:01 am
Your Target server memory is what SQL wants, and it matches your total. So I don't think you have memory pressure here.
The high I/Os might just be the sign of...
January 7, 2011 at 9:59 am
You also still haven't explained what doesn't work or the join. What is the point there? I assume that you are trying to get child records, but is there a...
January 7, 2011 at 9:57 am
Viewing 15 posts - 17,161 through 17,175 (of 39,903 total)