DevSocial Blogs · SQL Server blogs

One more bulk insert technique.

Sivaraman DhamodaranAug 6, 20113,997250

Select data in the source and insert in the destination table.

Sivaraman DhamodaranAug 6, 20113,468250

Inserting data for a specific columns

Sivaraman DhamodaranAug 6, 20115,886250

Insert into a Table for all the columns.

Sivaraman DhamodaranAug 4, 20114,444250

Automating database migration from Oracle, Sybase, MySQL, and Access database to SQL Azure and SQL Server “Denali”.

Suthish NairJul 28, 20116,269250

Multidimensional Expressions (MDX) the native query language for SQL Server Analysis Services (SSAS).

Mukesh KumarJul 26, 20118,627250

The main difference between the Deadlock and the Livelock is as under:

Nipun TomarJul 20, 201134,083250

Let's discuss the Models of database replication.

Nipun TomarJul 20, 20115,178250

Replication is the process of copying/moving data between databases on the same or different servers.

Nipun TomarJul 20, 20116,073250

SQL Server constraints enable the RDBMS enforce the integrity of the database automatically, without needing you to create triggers, rule or defaults.

Nipun TomarJul 20, 20118,976250

Lock Escalation is the process of converting a lot of low level locks into higher level locks.

Nipun TomarJul 20, 20115,308250

Let's discuss the properties of ACID.

Nipun TomarJul 20, 201175,655250

By reading this blog you will know how to find out SQL Server parse and compile time of a SQL statement.

Hasibul HaqueJul 4, 20115,187250

A Scalar user-defined function returns one of the scalar data types

Sandeep ShekhawatJun 30, 20117,048250

Split String - SQL function.

Rachit PatelJun 25, 20115,268250

Get Range wise data from sql table.

Rachit PatelJun 24, 20115,101250

I have discuss some points references Sql Server 2005.

Sandeep ShekhawatJun 23, 20113,893250

There are three standard storage modes (MOLAP, ROLAP and HOLAP) in OLAP applications.

Mukesh KumarJun 22, 201111,670250