Keep it Simple and Smart
We can launch any Microsoft Windows or Microsoft .NET Framework application from SQL Server Management Studio. External applications can be added to, and run from, the Tools menu. To add an external tool to the Tools menu On the Tools menu, click External Tools. In the Title text box, type the name you
» Read moreI have seen many different reasons and point of view on the use of cursors. Some people never used, some used at last resort and some used regularly. In each of these, they must have different reasons for their stand on cursor usage. There must have a reason or place
» Read moreHere is an example – Import CSV file to SQL table using Bulk-Insert CSV file means Comma Separated Values file. USE testdb GO CREATE TABLE table1 ( id INT, name VARCHAR(255), address VARCHAR(255) ) GO Create CSV file in Shared folder on any remote location with name csv.txt Suppose location
» Read moreHere is new feature of SQL Server 2008 – “Comma Separated INSERT Option” In this feature using a single INSERT statement you can pass multiple value for the table using comma separated option. USE testdb GO CREATE TABLE table1 ( id INT IDENTITY(1,1), name VARCHAR(255), address VARCHAR(255) ) SELECT
» Read moreHere is an example: Inserting same value multiple time in SQL table USE testdb GO CREATE TABLE table1 ( id INT IDENTITY(1,1), name VARCHAR(255), address VARCHAR(255) ) SELECT * FROM testdb..table1 INSERT INTO testdb..table1 VALUES (‘Varinder’,’ABC Street’) go 5 Result :
» Read moreThe primary purpose of replication is to distribute data from a master database to one or more secondary databases. Because Replication maintains a duplicate copy of data in synchronization with the master copy, the technology can be used to provide availability for application. Type of Replication Snapshot Transactional Merge Snapshot
» Read moreMicrosoft Webcast topic: “Introduction to SQL Azure (Level 100)” Sharing with brief introduction and difference between SQL Servers and SQL Azure SQL Azure is a highly available and scalable cloud database service built on SQL Server technologies. With SQL Azure, developers do not have to install, setup, and patch or
» Read moreKey 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
» Read moreWe 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
» Read moreIdentity 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
» Read moreVarinder Sandhu is using WP-Gravatar