SQL Server Interview Q&A (Database Programming)
Top 50 SQL Server Interview Questions & Answers SQL Server database developer interview questions and answers 24 Essential SQL Interview Questions and Answers
Windows Server 2008R2 – Tips
1. How to show hidden files/folders Open File Explorer and press ALT to show the menu Go to Tools > Folder Optsions 2. Start RDP Client command line: mstsc 3. File System Checking fcs /scannow System File Checker is a
How to Read Music
1. HOW TO READ MUSIC IN 15 MINUTES
SQL Server DBA Interview Questions (1)
Some Interview questions Question 1. What are the different types of Indexes available in SQL Server? Answer: The simplest answer to this is “Clustered and Non-Clustered Indexes”. There are other types of Indexes what can be mentioned such as Unique,
DBA Basics Part 1
Shrink Database DBCC SHRINKDATABASE (UserDB, 10); (shrink database to 10% of free space)Rename a database EXEC sp_renamedb N’Accounting’, N’Financial’; (old and new name)Check file group associated with a database Sp_helpfilegroupChange the database state Check the state (user_access_desc, state_desc) select *
DBCC CHECKDB
DBCC CHECKDB Checks the logical and physical integrity of all the objects in the specified database by performing the following operations: 1. Runs DBCC CHECKALLOC on the database. 2. Runs DBCC CHECKTABLE on every table and view in the database.
Program Compatibility Issues Error during SQL Server 2008 Installation
Description When attempting to install Microsoft SQL Server 2008 under Windows Server 2012, you are presented with a warning dialog stating “this program has compatibility issues.” You are then given the option to choose to “Get help online” or “Run
