407 reputation
315
bio website freetibet.org
location Varna, Bulgaria
age 25
visits member for 3 years
seen 2 days ago

Free Tibet From China Domination

http://freetibet.org/about/10-facts-about-tibet

enter image description here


2d
comment Table size is not changed after new column is added
@RemusRusanu are you sure? I have rebuild the clustered index and the size was not increased. Then I perform simple UPDATE .. SET [column] = '' and the size was increased. I believe rebuilding the index do not force the column to materialized the value.
Jan
29
awarded  Yearling
Jan
29
accepted Table size is not changed after new column is added
Jan
29
comment Table size is not changed after new column is added
That's really nice optimization. So, if I have created the column when the table was initially created, the table would be bigger now, because empty string would be truly inserted?
Jan
29
asked Table size is not changed after new column is added
Jan
23
comment Update SQL Server .net version
@PanagiotisKanavos Check the version - of this folder - it is 4.0
Jan
23
asked Update SQL Server .net version
Jan
23
comment Linked Servers security context and transaction logging
Thanks for the advice. I will check the SSIS solution either.
Jan
23
asked Linked Servers security context and transaction logging
Jan
17
accepted GZipStream/DeflateStream compressions alternatives
Jan
15
asked If “large value types out of row” table option is enabled, the table size is increased
Jan
15
asked GZipStream/DeflateStream compressions alternatives
Jan
12
comment How to optimize clustered index rebuild?
It is one of the main tables - used in a lot of places (both SQL and directly in the application). I am constantly checking the usage of the indexes and removed some of them. Some of them are updated daily, but used only for hundred of times each month - I am still not able to track where they are used (maybe some reporting service report) and to determine how critical are for the performance. You sound like it is a big issue that should be fixed ASAP? Do you think the delay is caused by them - I can check this tomorrow.
Jan
12
comment How to optimize clustered index rebuild?
It's very old design. I have reduced the indexes in fact(originally over 30). Is PARTITION = ALL option rebuilding all of them? If I rebuild only the clustered index aren't the non clustered indexes updated only? I can try this - disable or drop the non-clustered indexes, rebuild the clustered index and then recreated the non-clustered indexes.
Jan
12
comment How to optimize clustered index rebuild?
Yes, that is the main purpose. It is working. For now, I am testing this on local databases, and I want to reduce the execution time before doing this on produciton.
Jan
12
asked How to optimize clustered index rebuild?
Jan
7
asked What is the appropriate value for DBCC CLEANTABLE batch size?
Jan
2
comment Are “out of the row” fields read when a clustered index is used?
Thanks a lot. That's very nice. Seems, that using the sp_tableoption you are able to put out of the table everything that is not often used in order to reduce the size of the row, when a lot of clustered index seeks/scans are made.
Jan
2
comment Are “out of the row” fields read when a clustered index is used?
Thanks, I really did not know that you are able to control this.
Jan
2
accepted Are “out of the row” fields read when a clustered index is used?