Viewing 15 posts - 1,036 through 1,050 (of 26,487 total)
Here is dynamic SQL that will generate the script you need. It will be initially displayed in a column in grid mode, left clink on the link and it will...
September 11, 2018 at 2:34 pm
Do we need to worry about filestream data in the indexes?
September 11, 2018 at 12:46 pm
Are the indexes create in non-standard location(s) such as different file groups from the tables?
September 11, 2018 at 12:45 pm
September 11, 2018 at 12:39 pm
Can we assume that the clustered index is not dropped? How about indexes supporting constraints like primary or unique indexes?
September 11, 2018 at 12:29 pm
Script each index while they exist in the database. Put each in their own stored procedure. Use a master procedure to call each individual procedure if the index is missing.
September 11, 2018 at 12:11 pm
Document everything, make sure all (ALL) changes are in writing. Keep your proposed design handy. At some point the data in the system will hit critical mass and performance will...
September 11, 2018 at 11:28 am
September 11, 2018 at 9:35 am
If you have to keep recreating the indexes I would look for the process(es) that are dropping the indexes and fix that so the indexes don't keep disappearing.
September 11, 2018 at 9:05 am
September 11, 2018 at 7:31 am
If you work regularly with Oracle I would also push for Toad for Oracle. It will provide tools for query performance tuning. Not free, but if I had to work...
September 10, 2018 at 1:46 pm
How much free space in the database now versus prior to the DACPAC being applied?
September 10, 2018 at 1:42 pm
September 10, 2018 at 1:41 pm
September 10, 2018 at 1:34 pm
Viewing 15 posts - 1,036 through 1,050 (of 26,487 total)