Boosting Update Statistics performance with SQL 2014 SP1/CU6

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… Continue reading Boosting Update Statistics performance with SQL 2014 SP1/CU6

Considerations for Configuring Log Shipping for a cross-domain clustered instance of SQL Server over a Firewall

Last week, one of my customers had engaged me for consulting to configure Log Shipping on clustered instance of SQL Servers which are running in different domains. In other words, the primary and secondary servers are in different domains. While Log Shipping is pretty easy to configure but configuring log-shipping for a cross-domain clustered instance… Continue reading Considerations for Configuring Log Shipping for a cross-domain clustered instance of SQL Server over a Firewall

SQL Server Predeployment IO Stress Testing using sqlio

While there are some really good in-depth whitepapers and blogs (specifically by CSS Team and Brent Ozar & his team) to address this topic. However the information in these blogs,whitepapers is kind-off scattered and for a novice the information in some these whitepapers can be overwhelming.In this blog post I would like to explain you… Continue reading SQL Server Predeployment IO Stress Testing using sqlio

Blogs on SQLServerGeeks

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? http://sqlservergeeks.com/blogs/Parikshit/personal/427/does-parallel-plan-for-rebuild-index-impact-the-fragmentation-of-index Parikshit Savjani Premier Field Engineer

A failure was detected for a previous installation, patch, or repair during configuration for features

Recently I was trying to apply a security update for one of my SQL instance and I encountered the following error in my summary log Note: For those who are not aware, summary.txt is located in C:Program FilesMicrosoft SQL Server100Setup BootstrapLog A failure was detected for a previous installation, patch, or repair during configuration for… Continue reading A failure was detected for a previous installation, patch, or repair during configuration for features

Steps to Failover and Failback a Log Shipping Database in SQL 2000

Recently for one of our customers we had to perform a DR drill activity. To give a background on the environment, they were using SQL 2000 Database as a backend of SAP Application and the SQL Database was log shipped to Remote DR server. We had also customized the Log Shipping to add compression/decompression logic… Continue reading Steps to Failover and Failback a Log Shipping Database in SQL 2000

How to query Active Directory to fetch more than 1000 rows using Sql Server–Part I

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.… Continue reading How to query Active Directory to fetch more than 1000 rows using Sql Server–Part I

How to query Active Directory to Fetch more than 1000 rows using Sql Server–Part II

Continuing from where I left in my previous post.  The Stored Procedure mentioned in my previous post cannot be used to query pwdlastset from AD since it is stored in Integer8Date format which cannot be interpreted by sql server. So when there is a requirement to query pwdlastset from AD we need to use a… Continue reading How to query Active Directory to Fetch more than 1000 rows using Sql Server–Part II

Sql server performing slow after changing the Cost Threshold for parallelism

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.… Continue reading Sql server performing slow after changing the Cost Threshold for parallelism

Did you know… The applications like Infopath may fail to submit data into table in SQL Server if the table is included in Merge replication

You are able to submit the data in the table using the application like InfoPath 2007 but when you go ahead and add the table in the Merge Replication Publication, the insert into the table using the InfoPath form starts to fail. This issue occurs when we have the application designed to insert data into… Continue reading Did you know… The applications like Infopath may fail to submit data into table in SQL Server if the table is included in Merge replication