Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published July 12, 2015 · Last modified September 24, 2015
If 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...
Interview Q&A / SQL Developer Interview Q&A
by Manzoor Siddiqui · Published July 11, 2015 · Last modified September 24, 2015
Following are SQL Developers Interview Questions and Answers for Freshers. 1. What is a Database? A database is a collection of meaningful information organised in a manner that can be used whenever there is a requirement...
SQL Error Messages / SQL Server / SQL Tips and Tricks / SQL Troubleshooting
by Manzoor Siddiqui · Published July 10, 2015 · Last modified September 24, 2015
If you are a database users then you may have observed while executing any query when it gives error and error message shows that on particular line number there is some issue. So we...
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
501viewsWhen 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
Today 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...
Database Administration / Interview Q&A / SQL DBA Interview Q&A / SQL Server
by Manzoor Siddiqui · Published July 7, 2015 · Last modified September 24, 2015
323viewsFollowing are SQL DBA Interview Questions and Answers for Freshers – Part 1 1. What are the different components in SQL Server? Database Engine, Analysis Services, Reporting Services, Integration Services, Master Data Services, Data...
