Category: SQL-General

SQL Server – Distributing and Partitioning

SQL, SQL-Advanced, SQL-General, Varinder Sandhu

Key Points of Distributing and Partitioning Partition allow you to divide a table or index into multiple filegroups. Table and index are partition horizontally, based on rows by specifying a partitioning column. To create a portioned table or index you need to perform the following actions: Create a partition function Create a partition schema mapped to partition function Create a table or index on the partition schema SPLIT function to add a new boundary point and hence partition. MERGE function

» Read more
, , ,

SQL Server – Backup Type for Each Recovery Model

SQL, SQL-Advanced, SQL-Backup & Restore, SQL-General, Varinder Sandhu

Before looking about Backup type for each Model, sharing with brief information about Recovery and Recovery Model Recovery Recovery options determine the behavior of transaction log and how damaged pages are handled. Recovery Model Every database within a SQL server a SQL server instance has a property setting called recovery model. The recovery model determines the types of backups you can perform against a database. The recovery models available in SQL server 2008 are: Full Bulk-Logged Simple

» Read more
, , , ,

SQL Server – Understanding the System Databases of SQL Server

SQL, SQL-Advanced, SQL-General, Varinder Sandhu

We all know there are some system databases available in SQL Server. But we should have understanding about system databases. Here just try to give you understanding of system databases very briefly. There are four system databases available in SQL Server 2008 Master Model msdb tempdb Master Database The master database records all the system-level information for a SQL Server system. The master is the database that records the existence of all other databases and the location of those database

» Read more
, , , , , , ,

SQL Server – Linked Server – Mapped all users with one statement

SQL, SQL-General, SQL-Linked Server, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Hello Friends, I have setup the Linked server with the help of script here. My one of colleague helps me to write the script with we can map all user with one statement. This script will map all local SQL server users with remote user that you provide in the script. You don’t need to map all user manually. Script: EXEC master.dbo.sp_addlinkedserver @server = N‘dsql2k’, @srvproduct=N”, @provider=N‘SQLOLEDB’, @datasrc=N‘servername’ EXEC master.dbo.sp_addlinkedsrvlogin@rmtsrvname=N‘dsql2k’,@useself=N‘False’, @locallogin=NULL,@rmtuser=N‘sa’,@rmtpassword=‘XXXXXX’ if anybody have any other experience, please share as

» Read more
, ,

SQL Server Editions

SQL, SQL-General, Varinder Sandhu

Dear friends Most of time we have a question about difference between the SQL server editions, Lot of detailed stuff available over the internet but here sharing with you the brief information about the each SQL server editions so that we can understand easily about all the editions. SQL server 2008 is available in the following editions Enterprise: Designed for largest organizations and those needing to leverage the full power of SQL server 2008 platform. Learn More Standard: Designed for

» Read more
, , , , , , ,

Welcome SQL Server 2011-Denali – CTP1

SQL, SQL-General, SQL-Server 2011, Varinder Sandhu

Dear friends, A new release of SQL Server is available, and if you follow blogs or tweets or check Microsoft’s SQL Server website. You might have seen mention of the new version, code-named “Denali” SQL Server 2011 – CTP1 Released. CTP stands for Community Technology Preview It’s available in both 32-bit and 64-bit version. May you are getting excited about the new version. So that‘s why I am sharing with you all… What‘s New SQL 2011 Microsoft SQL Server 2011

» Read more
, ,

SQL – Index

SQL, SQL-General, SQL-Index, Varinder Sandhu

UNIQUE Creates a unique index on a table or view. A unique index is one in which no two rows are permitted to have the same index key value. A clustered index on a view must be unique. The Database Engine does not allow creating a unique index on columns that already include duplicate values, whether or not IGNORE_DUP_KEY is set to ON. If this is tried, the Database Engine displays an error message. Duplicate values must be removed before

» Read more
, ,

The partner transaction manager has disabled its support for remote/network transactions

SQL, SQL-Advanced, SQL-General, Varinder Sandhu

First verify the “Distribute Transaction Coordinator” Service is running on both database server computer and client computers Go to “Administrative Tools > Services” Turn on the “Distribute Transaction Coordinator” Service if it is not running If  it is running and client application is not on the same computer as the database server, on the computer running database server Go to “Administrative Tools > Component Services” On the left navigation tree, go to “Component Services > Computers > My Computer” (you

» Read more
, ,

ASP.NET SQL Server Registration Tool – Aspnet_regsql.exe

ASP.Net, SQL, SQL-General, SQL-Tips and Tricks, SQL-Utilities, Varinder Sandhu

This tool is a part of Microsoft .Net framework and like other tools this tool is also located in [drive:]%windir%Microsoft.NETFrameworkversion folder on your Web server.The ASP.NET SQL Server Registration tool is used to create a Microsoft SQL Server database for use by the SQL Server providers in ASP.NET, or to add or remove options from an existing database. You can run Aspnet_regsql.exe without any command-line arguments to run a wizard that will walk you through specifying connection information for your

» Read more
, , ,

SQL Server 2011-Denali

SQL, SQL-General, SQL-Server 2011, Varinder Sandhu

SQL Server code-named “Denali” Microsoft SQL Server code-named “Denali” empowers organizations to be more agile in today’s competitive market. Customers can efficiently deliver mission-critical solutions through a highly scalable and available platform. Industry-leading tools help developers quickly build innovative applications while data integration and management tools help deliver credible data reliably to the right users and new user experiences expand the reach of BI to enable meaningful insights. With SQL Server code-named “Denali” customers will benefit from the following added

» Read more
, ,
1 … 3 4 5 6