Viewing 15 posts - 18,106 through 18,120 (of 19,564 total)
Lynn Pettis (1/15/2010)
Mauve (1/15/2010)
Lynn Pettis (1/15/2010)
I don't read the QotD in the newsletter, I read it on SSC.
And it is best to answer later in the day as the question...
January 15, 2010 at 5:29 pm
Mauve (1/15/2010)
Lynn Pettis (1/15/2010)
I don't read the QotD in the newsletter, I read it on SSC.
And it is best to answer later in the day as the question is usually...
January 15, 2010 at 5:28 pm
Here is a another thread on that same topic.
http://www.sqlservercentral.com/Forums/Topic818809-146-1.aspx
January 15, 2010 at 4:14 pm
Most excellent. Thanks for the update.
January 15, 2010 at 4:11 pm
I could imagine. I have come into jobs where we had to replace a bunch of DTA indexes. Similar exercise. Pain in the butt - and very...
January 15, 2010 at 4:10 pm
TheSQLGuru (1/15/2010)
CirquedeSQLeil (1/15/2010)
gmby (1/15/2010)
lol, I've got a database that has a few of those runaway DTA indexes (all columns included) -
I've seen that as well. Nice to...
January 15, 2010 at 3:25 pm
dba_neo (1/15/2010)
By running the dbcc checkdb() repair_allow_data_loss,the data will be lost.as i dont have the backup of DB
Potentially lost. Data may be lost - it depends on how bad...
January 15, 2010 at 1:32 pm
Gail provides some very good points. She provided a link about Dirty Reads, you should read that article. Tuning queries, indexes, and database design should be the approach...
January 15, 2010 at 1:30 pm
gmby (1/15/2010)
lol, I've got a database that has a few of those runaway DTA indexes (all columns included) -
I've seen that as well. Nice to run the...
January 15, 2010 at 1:22 pm
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Med).
Your output is suggesting that you run the above repair option at a minimum. Do you...
January 15, 2010 at 1:13 pm
Lynn Pettis (1/15/2010)
Love you must the easy ones.
nice
January 15, 2010 at 1:02 pm
Chris Quinn-821458 (1/15/2010)
CirquedeSQLeil (1/15/2010)
...... 1
You may be down to 1, but I have a feeling that there will be no work done 😀
You would lose the bet - I...
January 15, 2010 at 10:51 am
I saw posted in another thread the suggestion of Creating an alternative user to replace SA. Leave SA in place - but decrease its permissions.
That might assist you somewhat...
January 15, 2010 at 10:49 am
Most excellent. Glad to be of service.
January 15, 2010 at 10:45 am
Viewing 15 posts - 18,106 through 18,120 (of 19,564 total)