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
, ,

Query Optimization with Linked Server

SQL, SQL-Linked Server, Varinder Sandhu

Hello Friends, I have faced a problem in SQL queries with Linked server; I just want to share with you all. Let me explain with example as below Say, we have set of applications which are running on SQL 2000, due to some reason we need to migrate sub set of applications to SQL 2008. Now the few applications running on SQL 2008 and few on SQL 2000, applications running on SQL 2008 using some of databases which lie on

» Read more
, ,

Add the value into an Identity Column in SQL Server

SQL, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Identity columns are commonly used as primary keys in database tables. These columns automatically assign a value for each new row inserted. But sometime Identity columns  missed the value, we want to insert missed value into the column. For that we need to enable IDENTITY_INSERT for the table. USE mytempDB GO CREATE TABLE myTable ( myIdentity INT NOT NULL IDENTITY(1,1) PRIMARY KEY, myValue NVARCHAR(30) NOT NULL ) GO INSERT myTable(myIdentity, myValue) VALUES (5, ‘Varinder Sandhu’) –Result =  Error because IDENTITY

» Read more
, , ,

Find EDITION, VERSION and SERVICEPACK information of SQL Server

SQL, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Hello Friends Generally, we choose the  @@VERSION to get the version information for SQL Server, but using this function we can’t get the Service Pack information installed… Alternative way Get Editions of SQL Server SELECT SERVERPROPERTY(‘EDITION‘) AS EDITION Get Version Detail of SQL Server SELECT SERVERPROPERTY(‘PRODUCTVERSION‘) AS VERSION Get the Service Pack installed on SQL Server SELECT SERVERPROPERTY(‘PRODUCTLEVEL‘) AS SERVICEPACK

» Read more
, , , ,

SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY not working with Linked Server or Remote server ???

SQL, SQL-Linked Server, Varinder Sandhu

Hello Friends, I have faced a problem using SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY with Linked server Let me explain with example as below Question: We have set of applications which are running on SQL 2000, due to some reason we need to migrate sub set of applications to SQL 2008. Now the few applications running on SQL 2008 and few on SQL 2000, applications running on SQL 2008 using some of databases which lie on SQL 2000 with Linked server Now

» Read more
, , , ,

Bullzip FREE PDF Printer

Utilities, Varinder Sandhu

Hello Friends, I have tried the Utility Bullzip PDF Printer, it really helpful for me…. That’s why I am sharing with you all … Introduction The Bullzip PDF Printer works as a Microsoft Windows printer and allows you to write PDF documents from virtually any Microsoft Windows application. This program is FREEWARE with limitations, which means that it is FREE for personal and commercial use up to 10 users. It does not contain any advertising or popups. For commercial applications

» Read more
, ,

SQL SERVER 2008 – Enable xp_cmdshell

SQL, SQL-Query, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

—  To allow advanced options to be changed EXEC sp_configure ‘show advanced options’, 1 GO —- To update the currently configured value for advanced options. RECONFIGURE GO —- To enable the feature. EXEC sp_configure ‘xp_cmdshell’, 1 GO —- To update the currently configured value for this feature. RECONFIGURE GO Alternative way 1. Click the Start button. 2. Select All Programs. 3. Navigate to the Microsoft SQL Server 2008 folder. 4. Right Click on Server name then click facets options 5. In the Facets Option choose Surface Area Configuration in dropdown 6. At the bottom of the window, mark True for xp_cmdshell. 7. Click OK.

» Read more
, ,

Happy New Year 2011

Others, Varinder Sandhu

                        The beginning of the new year is a great time to start fresh and work toward the things that you want from life. Pretty much everyone sets goals and objectives for the new year whether privately in their head or publicly to their friends and family. New Year is a time for celebration, countdown parties, champagne, dancing and fireworks. It’s probably the biggest celebration of the year seeing

» Read more
,

Varinder Sandhu – Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development.

Blog-News, Varinder Sandhu

Dear and Respected All, I am pleased to announce that Yesterday (27-December-2010) I have passed the examination of Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development. For more details about this exam 70-433: http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-433&locale=en-us

» 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
, ,
1 … 20 21 22 23 24 … 26