Viewing 15 posts - 91 through 105 (of 1,179 total)
Interesting question, thank you Andy.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 20, 2014 at 1:23 am
Require the smallest amount of additional permissions to be granted
:unsure:
However even I am not sure if SET STATISTICS IO is enough to check a best performing query.
Developer need to check...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 19, 2014 at 2:54 am
Thanks for interesting question Andy.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 19, 2014 at 2:49 am
Yes it is fine.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 18, 2014 at 4:48 am
I usually do not change the model database size and preafer to keep it as default size. I never encounter any issue keeping model size as default.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 18, 2014 at 4:24 am
You have to declare missing variables
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 11:31 pm
Missed today as I went back to my old days SQL 2000 🙂
What would be the error message in SQL 2000? If error message is same points should be...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 10:24 pm
It is normal during the reindex your log grow hence your database size grow and depending on the database design and activities on the database.
If you do not want...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 10:12 pm
Did you get a chance to find out any error in SQL OR WINDOW log?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 6:10 am
pmadhavapeddi22 (6/17/2014)
I have tried taking the backup with the following t-sql commands
case I
-----------------------------------------------------
backup database XTEST_DB to disk
='c:\XTEST_DB.bak' with compression
backup database XTEST_DB to disk
='c:\XTEST_DB.bak'
-----------------------------------------------------
Both the backups are successful. first backup is...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 6:03 am
Nothing to do with checkpoints.
Thanks Gail,
Agreed; it do not have to do anything with respect to checkpoints.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 5:48 am
Maintenance plan may avoid such duplicate entry.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 5:35 am
Extract from BOL for (Drop Table):
Large tables and indexes that use more than 128 extents are dropped in two separate phases: logical and physical. In the logical phase, the existing...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 5:21 am
On a safer side you can create similar virtual envoronment and perform the task before touching live environment.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 5:12 am
You can generate script of the existing replication and execute it on your test environment. If required you can change the database name.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 17, 2014 at 5:06 am
Viewing 15 posts - 91 through 105 (of 1,179 total)