May I know what do you mean by different SQL Statemets?
Really appreciate the advice and knowledge sharing.
If we create non-clustered index for those smaller column, will there be a...
Could anybody advice on my second part of the stored procedure?
As described in my previous post, this table consists of 27 millions records....
Then the creation of the clustered index will result a big increment for the table size [data and index]?
I think I had mistakenly put into the wrong thread, sincerely apologize.
Thanks for the script.
I did execute below scripts in one of the test environment with SQL 2000
1) select dpages*8 as INDEX_SIZE from sysindexes...
Thanks for the suggestion.
If I do not create the look up table, I still need to stick with those non-clustered index in the original table?
I think there are some misunderstanding there..
What i trying to say is..
There are a lot of drop down list such as
There are around 20 columns in the table. Due to the drop down list, we created non-clustered index on around 8 to 9 columns , appreciate...
Sorry for the very late reply.
We found the problem maybe due to some problem in linked server and caused some internal sql jobs to be...
I have a archive table with 27+ millions records, recently we would like to make an archive records report.
Since there are drop down list...
I have a db that hit a very high CPU usage this morning.
Before that, the DB was performing well.
However,since yesterday night, the...
Separate names with a comma.