Articles / Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks / SQL Tools / Tutorials
by Manzoor Siddiqui · Published July 13, 2015 · Last modified September 24, 2015
1.2kviewsPerformance monitor is a free tool provided by Microsoft windows and is very useful to analyse real time and historical performance information of your database servers and windows servers. So if you don’t have...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 12, 2015 · Last modified September 24, 2015
987viewsIf you have a requirement to import large size text file into SQL Server database then you can use BULK INSERT statement. In previous articles we have seen Bulk Copy Program (BCP) utility, BULK...
Articles / Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks / SQL Troubleshooting / Tutorials
by Manzoor Siddiqui · Published July 9, 2015 · Last modified September 24, 2015
1.6kviewsWhen users are reporting slowness in applications then as a database administrator what is your first step, you will try to find some blocking from current active processes. Most of the DBA’s first step is...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 8, 2015 · Last modified September 24, 2015
862viewsToday I was going through recovery models so thought to share different ways how we can find recovery models in SQL Server 2012. Option 1: Execute below query in query editor and find the...
Articles / Database Administration / Performance Tuning / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 6, 2015 · Last modified September 24, 2015
1.8kviewsIt is a big challenge for database administrators to trace performance issues, tune and maintain database server effectively. I receive many queries regarding database performance issues, some issues come after migration, some issues are...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 4, 2015 · Last modified September 24, 2015
1.1kviewsSQL Server maintenance plan is a very useful and simple way to create automated maintenance plans to optimise and backup your database regularly. You can perform database maintenance and optimised your database by creating...
