Following are links to my blog post on SQLServerGeeks.com.
Hope you find them useful
Does Parallel Plan for rebuild index impact the fragmentation of index?
Parikshit Savjani
Premier Field Engineer
Following are links to my blog post on SQLServerGeeks.com.
Hope you find them useful
Does Parallel Plan for rebuild index impact the fragmentation of index?
Parikshit Savjani
Premier Field Engineer
Kerberos is a network authentication protocol which can be used only with TCP/IP protocol. So if the client connects to the sql server with the Named Pipe Alias Kerberos is not used. Every service that will use Kerberos authentication needs to have an SPN set for it so that clients can identify the service on…
Have you ever wondered how to change the keys for the encryption for an already encrypted database. For this you can use “Key Rotation”. Key rotation is the process of decrypting data with the old encryption key and encrypting the data with the new encryption key. But how to use the Key Rotation with SQL…
Cross post from https://blogs.msdn.microsoft.com/sql_server_team/boosting-update-statistics-performance-with-sql-2014-sp1cu6/ With SQL 2005 end of life, many customers are planning their upgrades to SQL 2014. One of the recommended post upgrade tasks is updating the statistics of all the tables and databases in latest compatibility level. The updated statistics ensures the new optimizer in the latest release has most up to…
Recently there was a requirement from one of my customers to query Active Directory and load the data into a table in sql server. To be honest I am not developer so I started researching on the topics over the net and took help of some of the internal resources which I had access to….
We have observed a few cases now where sql server has started performing slow after changing the Cost Threshold Of Parallelism server option of the sql server. Ironically in such cases we observe that sql server is performing slow even when there is no high CPU utilization and no high I/O operations on the server….
Last week in of the SQL Community Forum, one of my friend asked the following question If I have 2 Tlog files for one database, how will these files fillup? A) File 1 will be filled first and then File 2 B) Both the files will be filled together. If B is true then how…