Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 21, 2015 · Last modified September 24, 2015
1.1kviewsMicrosoft has introduced backup compression feature from SQL Server 2008. This feature is very useful to save the time, reduces device I/O and storage cost and it is also a good backup strategy option. You...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 20, 2015 · Last modified September 24, 2015
1.1kviewsYou can create database by SQL Server Management Studio (SSMS) or by T-SQL both methods are quite simple and takes very less time to create. But before creating any database you must analyse your...
Articles / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 19, 2015 · Last modified September 24, 2015
891viewsYou may have observed after installing SQL Server that some databases are automatically created under system databases node. These are five system databases as master, model, msdb, tempdb and resource. Resource database is hidden...
SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 18, 2015 · Last modified September 24, 2015
587viewsSQL Server Database is a combination of different data files and components as listed below. Here we will see how data is stored in database and we will discuss it’s components. Basically there are...
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.3kviewsPerformance 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
992viewsIf 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...
