Viewing 15 posts - 211 through 225 (of 274 total)
Dear Jeff sir,
I did not rebuild ALL indexes in the database with fillfactor=90. Only on some tables, index fragmentation was greater than 95%. For these indexes, i rebuilt with fillfactor=90...
August 30, 2015 at 8:45 am
Good morning Gail Madam and everyone,
I reduced the fill factor value, set it to 90 and then rebuilded the indexes. It worked for majority of indexes. However, for some indexes...
August 29, 2015 at 3:46 am
Dear Lowell,
Thats the catch. The login cannot be removed from db_owner. They have some reasons for it.
August 24, 2015 at 5:46 am
Dear Jonas
We want our app login(prduser) to have ONLY execute permission to procedures.It must NOT be able to ALTER or DROP stored procedure. It is allowed to do everything else....
August 24, 2015 at 5:08 am
Sir is a respectful term of address. I am an entry level while you all are already in the dba field for years. Hence, as a token of courtesy, I...
August 21, 2015 at 10:08 am
Dear Chris sir,
Openquery can tune/improve performance but the architect told not to replace linked server with openquery. This is because we are migrating to cloud and architect said that it...
August 21, 2015 at 6:05 am
sir,
I informed to colleague. He will run and check.
August 21, 2015 at 5:14 am
Dear Chris sir,
There is remote join in the query you posted. I came across an article that says Remote join doesn’t work well on SQL server 2005. Ours is 2005.
August 20, 2015 at 1:00 am
The login had db_owner permission to the database. Will the trigger override the db_owner permission previlige?
August 19, 2015 at 11:53 pm
Dear Lowell sir,
The Applications use this login in their connection string and perform DML and other operations. Some of the business logic is in the stored procedures and hence the...
August 19, 2015 at 9:13 am
Datatype of te.TripEndTime. You had asked what is the datatype of te.TripEndTime.
August 18, 2015 at 11:52 am
We have Update Stats configured to run every week on Thursday, Sunday at 6:00:00 AM.
On the remote server, this job runs every week on Sunday at 7:00:00 AM
August 18, 2015 at 11:30 am
TotalDistanceTravelled is from table tbltripenddetail
August 18, 2015 at 11:13 am
Viewing 15 posts - 211 through 225 (of 274 total)