Index Rebuild VS Reorganize

SQL Server 2016 – whats new…lets see

Hey friends. I am here again with what’s new blog … Things are changing quite frequently and requirement is also changing....

Installation SQL Server 2016

Here is some of the installation processes(https://thakurvinay.wordpress.com/category/installation/) Below is very nice step-by -step installation  process for SQL Server 2016: http://www.databasejournal.com/features/mssql/installing-sql-server-2016.html

log reader uses single CPU

For replication even if you have multi core CPU it uses only one as log reader agent has single threaded...

Whats new in SQL Server 2016

While learning SQL Server 2014. looks like we need to swing on it as SQL Server 2016 is coming with...

hey its time for 2016!!!

Hi all Yeah its true microsoft announced SQL server 2016 and CP2 has been released to public also we can...

Whats New 2014

Hey all, Continue to my whats New series,  I am going through its new features and the more I am...

Re-initialize replication not working

For someone re-initialization is very simple, just go to publisher and right click and select re-initiallize and it will ask...

Sql Cluster Resource not comming online

when you check on the sql server services and sql agent services it’s getting started on windows cluster but on...

Cluster failover fails

you may get an error while trying to failover to another node cluster.   to resolve this issue create an alias...