Viewing 15 posts - 196 through 210 (of 1,179 total)
SORT_IN_TEMPDB option will use tempdb while reindexing, due to this your tempdb will grow. Also reindexing may have blocking depending on the database activity. Other option is if fregmentation is...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 7, 2014 at 3:04 am
Pl. find any other error in windows error log.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 7, 2014 at 2:24 am
One more good question on new technology, did some research. Thanks!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 7, 2014 at 12:23 am
It clearly mention about running multiple task like reindexing or shrinkfile. Try to find what exactly was running at that time for further investigation.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2014 at 5:10 am
Limited SAN space could be culprit. However let us know the detail error message for further investigation.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2014 at 5:07 am
What permission you do have on server/database?
You can run following command to find specific tables:
sp_helpindex...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2014 at 2:57 am
Good One, Thanks!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 6, 2014 at 1:06 am
You can generate the script for the required Stored procedures. Now you do have script ready for all required procedures. Create ALLPROC procedure which include all this code to create...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 5, 2014 at 11:48 pm
It is advisable to involve the storage guy to investigate further.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 5, 2014 at 11:40 pm
You can create the ISCSI drive on VM which shares the drive similar to SAN and proceed further. Also you can create two identical hardware for cluster and try always...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 5, 2014 at 10:44 pm
Interesting one. Thanks.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 5, 2014 at 3:40 am
Great Eirikur, is it possible to send this OUTPUT to excel using this T-sql?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 2, 2014 at 4:11 am
There are two ways you can achieve this.
1st Create a table(tblToBeDeleted) for records to be deleted. Insert the data into tblToBeDeleted and once insert is done you can delete...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 2, 2014 at 2:57 am
Yes in realtime scenarios we can use P2P replication and usually used for production, marketing, sales etc. to keep the data upto date.
Refer following MS link for further detail...
http://technet.microsoft.com/en-us/library/ms151196.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 2, 2014 at 1:09 am
Yes, you can create a job for RESTORE to execute it on demand.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
May 2, 2014 at 12:26 am
Viewing 15 posts - 196 through 210 (of 1,179 total)