Viewing 15 posts - 61 through 75 (of 469 total)
baghel_ramdas (1/15/2010)
May I know who is The_SQL_DBA?
That would be me I guess ;-)...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 15, 2010 at 10:19 am
I guess the embarrassment depends on the difficulty of question?
You can't get away by answering basic questions wrong. Also, depends on the role that you are applying for. I would...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 15, 2010 at 10:04 am
Was this cluster tested thoroughly before SQL server was installed on it?
Also, did you if it was a side by side upgrade, did you failover the nodes after installing SQL...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 15, 2010 at 9:28 am
As Gail suggested Drop the clustered index on 'tblTime' and recreate it.
Then run the checkdb statement again.
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 1:43 pm
snu155 (1/14/2010)
kinda like yelling at spock and punching kirk
Go to bulk logged, i'm fine with that
Go to simple...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 1:31 pm
You still haven't answered my original question..how did you arrive at the conclusion that there will be a 24 hours data loss..??
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 1:16 pm
Did you try reading this article. It might actually help in your case I see there is a high value for single page allocator from what you have posted.
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 12:58 pm
Try to get a new full backup of this database and then try the restore. If it errors again, then you might as well run DBCC Checkdb on you source...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 12:47 pm
If you intend to provide HA to your principal database then I would like to say that Replication is NOT a HA solution. It is used to reduce the overhead...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 12:44 pm
Did you have the table names specified explicitly in your maintenance plan job?
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 12:31 pm
I would never recommend taking a production system to Simple unless you can accept a 24 hour loss of data (even if it is just temporary).
Why would the data loss...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 12:27 pm
Depends on how the data is being retrieved from the table. Check the execution plan of any of your queries and see if it makes any difference by adding an...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 12:23 pm
Ali_SQLDBA (1/14/2010)
post the results for the below query on your table
dbcc showcontig('table_name') with fast
The above query on my deleted table is givng this message as expected
"Msg 2501, Level 16, State...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 12:18 pm
Ali_SQLDBA (1/14/2010)
The_SQL_DBA (1/14/2010)
Can you tell us the fragmentation level on this table..post the results for the below query on your table
dbcc showcontig('table_name') with fast..
do...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 12:15 pm
Can you tell us the fragmentation level on this table..
post the results for the below query on your table
dbcc showcontig('table_name') with fast
With so many DML's I suppose you are better...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 14, 2010 at 10:34 am
Viewing 15 posts - 61 through 75 (of 469 total)