Viewing 15 posts - 721 through 735 (of 860 total)
what is your system configuration?
Check this out:
February 14, 2009 at 9:03 am
peace2007 (2/14/2009)
I need to know the most important regular works that each DBA should perform on SQL Servers to prevent performance problems, etc.
The major part is Query Tuning
I would say...
February 14, 2009 at 8:10 am
dakshinamurthy
I would like to know How and when we need to rebuild indexes, reorganise indexes , defragindexes in SQL Server 2005. Please suggest a link or article which explains this.
ALTER...
February 14, 2009 at 7:34 am
exec sp_update_resume
exec sp_distribute_resume
:w00t:
February 14, 2009 at 6:58 am
digitalox (2/13/2009)
February 14, 2009 at 6:31 am
dharris (2/13/2009)
I work for a software company, our web application uses a SQL database for its backend. I took our application and set it up on one of our...
February 14, 2009 at 6:19 am
pixye.sb (2/13/2009)
Very useful the COPY_DATA option
COPY_ONLY backups.
No problem, its our pleasure:)
February 13, 2009 at 6:02 am
Nisha (2/13/2009)
UserName UserType ...
February 13, 2009 at 1:04 am
Nisha (2/12/2009)
May be this is because the database owner has been dropped.....
Try to set the database owner of the referenced database to an existing one..for ex. "sa"
sp_changedbowner 'sa'
How do...
February 13, 2009 at 12:18 am
dallas13 (2/12/2009)
hmmm... as i told u... i can see the status sometimes as(Mirror,Synchronized/Restoring...)
so looks like it fixes by itself only..... strange...
no its not strane its the default...
February 12, 2009 at 2:59 pm
Well, here is the thing:
Have you got any backups scheduled already for your DR plan? If so, you don't want to affect your overall backup sets. you can create COPY_ONLY...
February 12, 2009 at 7:03 am
Checkpoints writes all dirty pages for the current database to disk. Dirty pages are pages that are entered in the cache and modified, but not written to the disk yet....
February 12, 2009 at 6:45 am
If you are returning large number of row sets then obviously table scan is better. Don't forget to post the query and the table structure.
February 12, 2009 at 6:13 am
pjlewis (2/11/2009)
February 11, 2009 at 12:44 pm
.
To b honest, in this case you have explained, I would have a service that Synchs the data as they change. Much more easier to maintain.
This is just...
February 11, 2009 at 7:59 am
Viewing 15 posts - 721 through 735 (of 860 total)