Categories
Sql Server

Find Fragmentation Level by using Command Prompt SQL Server

Find Fragmentation Level by using Command Prompt SQL Server In this post we will learn how to Find Fragmentation Level by using Command Prompt SQL Server. Find fragmentation in SQL Server is so easy, and that much in command prompt too. Query: —–Find database id with this query—- select * from sys.sysdatabases —-Find Fragmentation Level by […]

Categories
Sql Server

SQL Server Interview Questions & Answers 3

SQL Server Interview Questions & Answers 3 In this post we will discuss some more SQL Server Interview Questions & Answers. 1.  What is SQL Server Architecture? Ans: 2.  What is page? Ans: The fundamental unit of data storage in SQL Server is the page. In SQL Server, the page size is 8 KB. This means […]

Categories
Sql Server

SQL Server Delete Duplicate Rows

SQL Server Delete Duplicate Rows Hi Friends in this tutorial we will learn SQL Server Delete Duplicate Rows or you can say how to delete duplicate rows in sql server. Sometime it is required to delete duplicate records from a table. We will delete duplicate rows using ROW_NUMBER() feature of SQL Server. Earlier we had discussed about How to […]

Categories
Asp, Asp.net

How to Connect MySQL Database in Asp.Net using C#

How to Connect MySQL Database in Asp.Net using C# In this post we will discuss How to Connect MySQL Database in Asp.Net using C#, or you can say how to establish connection with MySQL server and display data in GridView control. To connect with MySQL you have to use MySQL connector for .net from here. Install […]