Currently browsing tag

Server

CLR Integration with MS SQL Server

CLR Integration with MS SQL Server Introduction My friend told me that the CLR Integration is quite complex. I think that nothing is complex if we understand it properly. So in this article I am trying to discuss about MS SQL server CLR integration. I try to demonstrate it as …

Blocking in SQL Server

Blocking in SQL Server In this article I am trying to explain the Blocking. What is it Blocking in SQL Server is a scenario where one connection to SQL Server locks one or more records, and a second connection to SQL Server requires a conflicting lock type on the record …

SQL Server AGENT

SQL Server AGENT I have collected some general facts related to SQL Server Agent and how you configure it. Hope it will help you. SQL Server Agent is the service SQL Server uses to perform administrative tasks called jobs. Jobs are made up of one or more steps to accomplish …

Understanding about LINKED SERVER In SQL

Understanding about LINKED SERVER In SQL Linked Server in nothing but combining two different Server database together and perform a single query or joining table objects from different database of different server. For Example: You have Server-A with Database-A and Server-B with Database-B in different geographical locations. Now you want …

How the Data Stores in SQL Server

How the Data Stores in SQL Server Data Page Data pages are the fundamental area to store data in SQL server. The data pages contains Pages header Data Row Row Offset or pointers. The maximum size of a data page is 8 KB Extents Extents are basic units in which …

Authentication mode of SQL server

Authentication mode of SQL server I am collecting some interesting facts related to Authentication mode of SQL server. When we are going to install the SQL server, it’s asked about the Authentication mode. We have to choose between 2 options. 1.    Windows Authentication mode. 2.    Windows and SQL Authentication mode. …

Server Busy Who is there

Server Busy? Who is there? To see the connected session in your database use this SQL statement SELECT HOSTNAME,                  PROGRAM_NAME,                 STATUS,                  SPID FROM    MASTER..SYSPROCESSES WHERE DBID= DB_ID(‘TestDB’)                 AND SPID != @@SPID It provide you the information like Hose Name        — The name of computer in …

Physical defragmentation NOT Needed After SQL Server defragmentation

Physical defragmentation NOT Needed After SQL Server defragmentation   May of us doing physical defragmentation to get the performance of SQL server and think that physical defragmentation after SQL server defragmentation. This is a absolutely wrong concept and to illustrate my points I have collected some facts.     Physical …