Viewing 15 posts - 17,221 through 17,235 (of 39,958 total)
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
Being sa on SQL Server, either on Win2K3 or Win2K8 doesn't give you rights to stop any service. That depends on your rights in the underlying Windows host.
In 2008,...
January 7, 2011 at 9:50 am
Please don't post your email in forums. Responses will come here.
It's not quite clear what you are asking. Please spend time to clearly explain what you do not understand. To...
January 7, 2011 at 9:41 am
It's lazy developers. They think their time is too valuable to optimize this instead of fixing it right so that network and database resources are not wasted. A simple checksum...
January 7, 2011 at 9:39 am
How long do you need to keep this? And how is the data used? It can be handy to keep this information in each record, and it can reduce contention...
January 7, 2011 at 9:35 am
Would this help?
http://msdn.microsoft.com/en-us/library/ms178655.aspx
You could scan this for the status of a mirrored pair.
January 7, 2011 at 9:33 am
Viewing 15 posts - 17,221 through 17,235 (of 39,958 total)