Viewing 15 posts - 226 through 240 (of 280 total)
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
Gail Madam,
It is production. Is it ok to drop the fill factor? Also, i should be doing it during non-business hours, correct?
August 18, 2015 at 1:23 am
Good morning Gail Madam,
I Rebuild the index again last night. percentage of fragmentation increased for the below index after 6-8 hours.
Here is the definition of the index:
CREATE NONCLUSTERED INDEX...
August 17, 2015 at 11:43 pm
Dear Gail Madam,
I really salute for your will to help newbies/juniors like me.
August 14, 2015 at 6:01 am
Gail Shaw Madam,
Thanks for your reply. No shrink operation was performed. Regarding inserts, how to know if any data load or insert operation happened?
August 14, 2015 at 4:53 am
Gail Madam,
I have attached screenshot of what i see in the activity monitor. . Is this some issue? What do i need to do? Please help
August 13, 2015 at 1:28 am
Alex,
What i meant was our environment is small and there is no pressure on me to fix the issue immediately. They have told me to take my time to look...
August 13, 2015 at 1:21 am
Dear Gail ShawMadam,
I am junior dba. I was told that this forum have great,SQL experts,kind hearted wonderful people with good virtues like all of you here and willing to...
August 12, 2015 at 11:27 pm
Madam, i am junior dba. I was told that this forum have great,SQL experts,kind hearted people with good virtues like all of you here and willing to help. Our environment...
August 11, 2015 at 11:46 am
Madam,
So,take a full/diff backup after the log chain got broken and ten restore it with norecovery on secondary? Do we need to re-configure log shipping again?
August 8, 2015 at 12:50 pm
Jason Sir,
So, in log shipping, suppose the .trn file got corrupted today at 7 AM, do i need to take full backup immediately and restore it on secondary with norecovery?...
August 8, 2015 at 10:48 am
Viewing 15 posts - 226 through 240 (of 280 total)