Viewing 15 posts - 121 through 135 (of 1,179 total)
Good one, Andy. Thank you.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 10, 2014 at 11:10 pm
If you have tested and result set are giving correct output than you can keep the upgraded version of the database i.e. 110 elase you can change it back to...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 10, 2014 at 4:02 am
Looks like extract of the output.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 10, 2014 at 3:46 am
Rebuild the index or drop and recreat index for object id 60 and run DBCC CHECKDB to verify.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 10, 2014 at 12:24 am
Koen Verbeeck (6/10/2014)
Easy one, thanks!
+1
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 10, 2014 at 12:18 am
As there are 1 TB data suggested to avoid any constraints on the table. e.g. foreignkey, check constraints, indexes etc. This will speed up the process. You can do the...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 9, 2014 at 6:24 am
Repeted but OK. Thanks for the question.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 9, 2014 at 5:28 am
My approach is similar to Hansi. If you do have enough disk space and shrink is only 5 GB just let it be.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 6, 2014 at 2:58 am
Looks like SAN issue.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 6, 2014 at 2:51 am
Yes it is possible. Refer following link:
http://msdn.microsoft.com/en-us/library/ms189127.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 6, 2014 at 12:38 am
It will be difficult unless you are tracking the changes.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 6, 2014 at 12:17 am
What if once user has version 1.1/1.2 and switch back to 1.0 or user use their login on old version 1.0 after he used higher verison? How data consistency maintained?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 6, 2014 at 12:09 am
Hello Saikat,
Pl. do not post the duplicate thread on the multiple places. It will creat confusion and difficult to track the thread.
Cheers.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 6, 2014 at 12:03 am
Refer following link might help:
http://stackoverflow.com/questions/11278114/enable-remote-connections-for-sql-server-express-2012
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 5, 2014 at 11:59 pm
Are you perfroming the restore on the server is having same version of SQL Server?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 5, 2014 at 12:23 am
Viewing 15 posts - 121 through 135 (of 1,179 total)