How to make SQL Server Wildcard Searches Faster
In this tip we look at one approach that can help make SQL Server wildcard searches using % faster.
Susantha Bathige was born in Matara, Sri Lanka and is currently working in the United States for Pearson North America as a Senior DBA III, production DBA. He has over a decade of experience in the IT industry in full scale software companies including local and international. He has completed all the levels of British Computer Society (BCS) examinations and earned a PGD (Professional Graduate Diploma) which is the academic equivalent to a university honors degree in England. He earned his Master of Science degree from Sri Lanka Institute of Information Technology (SLIIT). Since 2000 his entire career has been data based. He has worked with SQL Server from version 6.5 and specialize in many areas of SQL Server including its internals, optimization, troubleshooting, replication, and more.
Run SQL Server vNext (CTP1) as a Docker Container on a Mac
Microsoft released SQL Server vNext which allows you to install SQL Server on Linux. In this tip, we look at how to install SQL Server vNext CTP1 as a Docker container on Mac OS.
Collect SQL Server Performance Counter Sets Using Logman
Learn how to use the Logman tool to collection performance monitor counters to help troubleshoot performance issues for your SQL Server instances.
Understand how SQL Server works to write better T-SQL queries
There are many ways to write a SQL query and in this tip we look at how to break down a query and different ways of resolving the query.
SQL Server Change Tracking Performance Troubleshooting
Learn how to use SQL Server Change Tracking as well as ways performance troubleshooting and management.
Troubleshooting transactional replication latency issues in SQL Server
I have several clustered SQL Server 2012 instances installed and I am having issues with replication latency. The environment has a dedicated SQL Server instance for the distributor. One instance has publisher database(s) and another instance has subscrib
Registry Check Pointing a Windows Cluster to Bring SQL Server Online
The SQL Server service for our cluster could not be brought online during a recent failover due to registry not found error(s). How can we correct this issue?