Viewing 15 posts - 406 through 420 (of 469 total)
I had this issue with my server too. This happens when your drive which holds the data is not started but SQL server starts and cannot locate these files. Make...
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."
October 10, 2008 at 1:36 pm
its not only confusing but it makes me at loss of words to explain this behaviour. I mean which process do I need to rollback to continue with the other...i...
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."
October 10, 2008 at 10:21 am
yes it shows same SPID a bunch of times and then the message is SPID 50 blocking SPID 50 blocked by SPID 50..this is so strange..I dont know if there...
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."
October 10, 2008 at 9:04 am
Corretion : Counters that tell about reads and not writes.
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."
October 10, 2008 at 8:05 am
If possible check the code that is executed with this link..if not include counters that pertain to writes to that specific database. Make sure to add filters so as not...
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."
October 10, 2008 at 8:05 am
Thats awesome many..thanks a lot
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."
October 8, 2008 at 4:57 pm
When I put forth the idea and the risk involved in doing this conversion to management, they said they were better off without doing it. The reason being the hundreds...
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."
September 29, 2008 at 8:36 pm
well the rowcount has worked like a charm. I shall try yhe wait for also. I am also referencing by the indexed column in the where clause now.
thanks a...
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."
September 29, 2008 at 8:30 pm
There are seven related tables that are dependent. I am supposed to delete the data starting with the table on the lowest level of the parent child hierarchy. There is...
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."
September 28, 2008 at 10:58 am
@Jeffrey: I would want to delete a large amount of data as is required and that the table size decreases dramatically after the test delete. Now my obvious question is...
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."
September 28, 2008 at 8:00 am
Sorry about not posting in detail. The export job was failing on account of seeing some alien char. It's a CHAR RERTURN...I got it now..appreciate all your replies guys..thanks!!!
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."
September 28, 2008 at 7:51 am
Well if there are many a processes that are active on the DB then your process works fine. I wouldn't be searching for a number of transactions and kill them...thanks!!!
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."
September 26, 2008 at 3:12 pm
Go to Current Activity in the Management Folder.
Kill the process that is using this DB that you want to restore. Single User, will not help the cause. The error says...
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."
September 26, 2008 at 2:02 pm
Good question. But what ever space you provide to begin with at the end of the day you have to give tempdb the space it needs. I would begin with...
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."
September 24, 2008 at 7:51 am
The TRUNCATE_ONLY clause of the DUMP statement removes the inactive part of the log without making a backup copy of it. I am not sure if LSN's change unless...
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."
September 24, 2008 at 7:36 am
Viewing 15 posts - 406 through 420 (of 469 total)