Script to find the Fragmentation in Indexes In my previous articles, Fragmentation in SQL Server and Rebuild And Reorganization of Indexes , […]
Script to find the Fragmentation of indexes Read Post »
Below is the query to find out all the Queries and their details like SSID etc. running on the SQL
Script to find all the running queries/jobs on the Database Server Read Post »
Many times I was asked how to pass Microsoft certifications and how difficult it is. In my point of view,
How to pass Microsoft Certification Exams Read Post »
Technical Round Database Interview Questions 1) What are the different types of Trace flags which we used for detecting the
Interview questions for database developer Read Post »
Below is the list of linkedin articles which I liked most. These articles gives you lot of motivation. 7 Bad
My Best LinkedIn Articles Read Post »
Many times my friends ask me which technical sites they should refers for finding the solutions, so below is the
My Best Technical Sites and Blogs Read Post »
SQLTea – Our new SQL Tutorial App on Google Play Store We are happy to announce our new SQL tutorial
SQLTea – New SQL tutorial app in Google play store Read Post »
In this article, I am going to explain the process of Database restoration using the SQL Server Management Studio. In
How to restore database backup in SQL SERVER Read Post »
Introduction This article explain the simple way to take the database backup in SQL SERVER which can be easily understandable
How to take Database backup in SQL SERVER Read Post »
In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command.
Database Creation using SQL Sever Management Studio (SSMS) Read Post »
In SQL Server, database can be created by 2 ways:- Using Create Database command Using SQL Sever Management Studio (SSMS).
Database Creation using Create Database command Read Post »
With IN clause, we can specify multiple values in a WHERE clause. For example, in case of “IN”, one can
IN clause in SQL Server Read Post »
Avg():- This function is used to get the average value of a numeric column Syntax:- SELECT AVG(column_name) FROM table_name
AVG() function in SQL Server Read Post »
UPPER():- This function is used to convert the value of a column to upper case. Syntax: SELECT UPPER(string) OR
UPPER() function in SQL Server Read Post »
LEN():- This function is used to get the length of the given string value. Syntax:- Select len (stringvalue)
LEN() function in SQL Server Read Post »
The Perfect Mix of Technology & Knowledge