Viewing 15 posts - 646 through 660 (of 1,179 total)
Fortunately I got 2 points.
The second count gives 1 but as there was no 1 in the answer hence selected 2 and got it correct.
In QOD we have...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 20, 2011 at 12:22 am
I guess it will be difficult to find out howmany attempts are left?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 12, 2011 at 3:56 am
You can also execute following command:
SELECT @@MAX_CONNECTIONS
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 12, 2011 at 3:41 am
The query you have executed is correct and contain maximum information about the backup and restore.
Now you would like to compare the same detail with Prod-db; the way you...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 23, 2011 at 12:12 am
Also check the stored procedure is written efficiently...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 19, 2011 at 3:47 am
Check following link:
http://technet.microsoft.com/en-us/library/ms187540.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 17, 2011 at 4:04 am
Generally it depends on the server and how much processes & activities are running on it.
Check if backup verification option is on? Internally when backup is done than backup plan...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 1, 2011 at 1:12 am
Post exact command you are executing and what exact error you are getting so that people can help you.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 31, 2011 at 4:21 am
"The lazy writer is a system process that flushes out batches of dirty, aged buffers (buffers that contain changes that must be written back to disk before the buffer can...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 24, 2011 at 1:34 am
It's security issue.
Following link might help you.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 23, 2011 at 1:38 am
Use perfmon and explore "Memory" & "SQL SERVER:Memory Manager" counters.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 23, 2011 at 1:25 am
For what reason are you looing for this option? performance?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 23, 2011 at 1:08 am
Pl. refer following link.
http://msdn.microsoft.com/en-us/library/ms187540(v=sql.90).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 20, 2011 at 4:45 am
You can also add one more begin tran - commit tran - rollback tran after
SELECT * INTO table2 FROM table3
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 17, 2011 at 1:22 am
Before restarting the server How about running DBCC CHECKDB to check database consistancy and any errors?
If able to get sufficient time to perform it as a safer side.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 17, 2011 at 1:11 am
Viewing 15 posts - 646 through 660 (of 1,179 total)