Viewing 15 posts - 1 through 15 (of 22 total)
We do not installed any monitoring tools for SQL server database.
Can you please suggest any monitoring tools, At least these tools will help when I have a situation like...
August 4, 2017 at 1:30 am
June 26, 2017 at 10:57 am
June 26, 2017 at 10:54 am
Adding to the above
I have added additional .ndf(Size 4MB) file to tempdb to release contention on .mdf (22GB Size)file of tempdb few days back.
It looks like...
June 25, 2017 at 9:48 pm
GilaMonster - Friday, June 23, 2017 6:38 AMCan you be a little more explicit about what you're looking for?
We have some data...
June 23, 2017 at 10:50 pm
Please find attached actual execution plan of the query.
June 9, 2017 at 5:57 am
I raised this question to improve performance of the query.It would be more help full if you give based on execuiton plan,
June 9, 2017 at 4:59 am
The above query has retrieving 2010899 rows .Exection time 11:25 sec
June 9, 2017 at 4:51 am
It's dataware house application.
Every day I collect database statistics and rebuilding existing indexes if require.
I am fresher to SQL server plz help how to go ahead on this.
June 9, 2017 at 3:59 am
Please find attached execution plan and post your suggestions here
June 9, 2017 at 1:49 am
Okay,
I have a table with out any indexes. If I am deleting & Inserting data continuously some space will be fragmented
How to recover the space.
June 6, 2017 at 5:31 am
We found some maleware in machine, so we removed it and rebooted the server.
June 6, 2017 at 3:52 am
I have been observing fragmentation when I check index properties.
Base on that I am going to rebuilding the indexes
June 5, 2017 at 9:55 pm
No, I am rebuilding indexes before deleting data.
After deleting We are inserting data through SSIS.
June 5, 2017 at 1:37 pm
Adding to the above replay.
I have a table, we are deleting data 90% of the data with in that table and inserting again.
Due to heavy deletion, We...
June 5, 2017 at 10:01 am
Viewing 15 posts - 1 through 15 (of 22 total)