DevSocial Blogs · SQL Server blogs

I'll show you how to create linked server for remote access in sql server 2008 r2.

In this blog I am determining the Schema of a objects and How to change the schema of a objects in SQL Server using below given Query. This query show all Schema of a objects in Existing database and we can change the schema of a objects of any database.

Om AgarwalJul 26, 20134,511250

If you want to directly stops SQL Server by T-SQL (without execution Checkpoint Databases).

Om AgarwalJul 22, 20133,329250

In this blog, Today I am determining all database files (data, logs) size and growth in SQL Server below given Query.

Om AgarwalJul 22, 20135,604250

Today I discuss Reindexing and Reorganized in SQL Server 2008.

Om AgarwalJul 17, 201312,226250

How to trim all the spaces from all character type field of the tables of the database.

Amit TiwariJul 16, 20133,849250

Today I am determining the owner of the Database and change the owner of a database in SQL Server below given Query.

Om AgarwalJul 12, 20135,120250

This blog defines how to create a new jobs in SQL Server.

Arun kumarJul 11, 20134,977250

This blog defines how to copy SQL table into excel and other formats.

Arun kumarJul 11, 20134,029250

This blog defines new user creation and admin user creation in SQL Server.

Arun kumarJul 11, 20134,036250

This blog defines scheduling auto backup in SQL Server 2012.

Arun kumarJul 9, 20136,032250

This blog defines current and previous Week, Month, Quarter, Year in SQL Server.

Gohil JayendrasinhJun 21, 201319,426250

Here I am explaining four stored procedures to show use of different type of like in SQL Server.

Pankaj PandeyJun 4, 201337,087250

Change any keyword(variable) into all stored procedures in two steps.

Pankaj PandeyJun 4, 20133,381250

How to see columns from sql server query.

Pankaj PandeyMay 31, 20133,368250

How to compare two column values which are comma separated values.

Gaurav GuptaMay 31, 201352,170250

How to compare single valued variable with comma separated values in a columns.

Gaurav GuptaMay 30, 201323,203250

Some times we need to apply switch case in sql query when we retrieved the data. At that time this blog may help you.

Pankaj PandeyMay 30, 20135,351250

In this blog, I described how to calculate the maximum range of integer data types in SQL Server.

Rohatash KumarMay 28, 201391,229250

Gets The first letter of each word separated by delimiter of string in SQL Server.

Kumar SambhavMay 22, 201310,228250

SQL Server 2012 introduced a new feature Columnstore Index which can be used to improve query performance. It is used in data warehousing.

Seema ChaudharyMay 10, 20136,444250

Put multiple column fields in Order by syntax.

Pankaj PandeyMay 10, 20132,794250

Show and insert data in linked server from mysql to SQL server. Linked server created for using two database servers for one application, like my sql and sqlserver.

Pankaj PandeyMay 6, 201314,460250