While studying through statistics and its impact on Plan cache, I have got the following question If all my tables in a database (Assume Instance has only one DB) have some modifications every day, and every night I run update statistics with Full scan, is that same as executing DBCC FREEPROCCAHE or clearing the plan cache?
Hello sir thanks for your response - I have another q - How to handle situation where in Source table one column had been added without knowledge and our DWH SP/Project/Package should be able to handle without any failure, considering very less down time.
Hi Sir, recently i notice that in our database, clustered index column is also added in non clustered index with some other column. could you please suggest on this.
Sir I have production db server of version 2016 standars running on windows os. Its running in UTC. I need to change this time zone to Eastern standard rime zone. Can I change it directly from os time zone settings ??
as usual, very educational and useful
Glad you think so!
Glad you think so!
While studying through statistics and its impact on Plan cache, I have got the following question
If all my tables in a database (Assume Instance has only one DB) have some modifications every day, and every night I run update statistics with Full scan, is that same as executing DBCC FREEPROCCAHE or clearing the plan cache?
Great thought. Some plans will be removed ans some will stay. Partial free proc cache
Hello Sir, I have a Q, What happened in background when you applying UNIQUE Constraints on Heap table having billions of rows ??
It will take a lots of time to insert.
@@PinalDaveSQLAuthority Thank you so much Sir
Hello sir thanks for your response - I have another q - How to handle situation where in Source table one column had been added without knowledge and our DWH SP/Project/Package should be able to handle without any failure, considering very less down time.
Sorry, I do not know answer of this one.
@@PinalDaveSQLAuthority I am happy that at least responded ...... thanks a lot
Very useful, Thank you
Glad it was helpful!
Hi Sir, recently i notice that in our database, clustered index column is also added in non clustered index with some other column. could you please suggest on this.
I personally see no reason for doing it.
Thanks for sharing Pinal 👍
Welcome
Sir I have production db server of version 2016 standars running on windows os.
Its running in UTC. I need to change this time zone to Eastern standard rime zone. Can I change it directly from os time
zone settings ??
SQL depends on the server time so by changing time zone there may be some process might be missed.
How to find differences between IST and server time
Function datediff
Nice 👍
Thank you! Cheers!
Watch which you had shown is showing 25 second not 35 second 😘
That is true. Thanks for watching :-)