SQL Blogs

SQL

Learn SQL, a language to query and manipulate relational database management systems.

Blogs

Take SQL Backup Using SP

One of these tasks may be the need to backup all databases on your server. This is not a big deal if you have a handful of databases, but using T-SQL is a much simpler and faster approach.
Manoj Sevda Dec 29, 2011
owns a schema in the database, and cannot be dropped

The database principal owns a schema in the database, and cannot be dropped. Fix error no 15138
Manoj Sevda Dec 26, 2011
Script for Point in Time Recovery – Back Up and Restore

Here is one of the script which I refer whenever I faced situation about restoring the database at point in time
Manoj Sevda Dec 22, 2011
Vivek C# Notes

This blog will contains articles on many technologies specially on database and c#
vivek Johari Dec 16, 2011
List of dates between two dates

List of dates between two dates.
Manoj Sevda Dec 14, 2011
COUNT of Rows and Columns in selected database for all tables

COUNT of Rows and Columns in selected database for all tables
Manoj Sevda Dec 12, 2011
Find last day, First day, Current, Prevoius, Next month in SQl Server

SQL SERVER – Find Last Day of Any Month – Current Previous Next
Manoj Sevda Dec 05, 2011
Cluster Indexing and Non-Cluster in SQL Server

The clustered index IS the data. The KEY to the clustered index defines the way that the data is ordered. A nonclustered index is duplicated data. This duplicated data can be used to help reference...
Manoj Sevda Nov 23, 2011
Programmatically Accessing All Databases and Database Tables

The blog illustrates how to access all databases and the Tables on a SQL Server programmatically.
Mayur Dighe Nov 07, 2011
PARSE() function in SQL Server

Here you will learn about PARSE() function in SQL Server.
Manoj Sevda Oct 22, 2011
Split Function in Sql Server to break Comma-Separated Strings into Table

Split a String into more then one value by using any delimiters.
Prabhu Raja Sep 01, 2011
ALTER TABLE ALL Foreign Keys to add ON DELETE CASCADE

FOR ALL TABLE SET Foreign Keys to add ON DELETE CASCADE
Gohil Jayendrasinh Aug 18, 2011
Connecting SQL Server Analaysis Services Engine

Connecting SQL Server Analaysis Services Engine
Venkatesan Jayakantham Aug 12, 2011
Adventure Works deployment issue in SQL Server Analysis Services

Adventure Works deployment issue in SQL Server Analysis Services
Venkatesan Jayakantham Aug 12, 2011
Deployment issue in SQL Server Analysis Services

Deployment issue in SQL Server Analysis Services
Venkatesan Jayakantham Aug 12, 2011
Installing AdventureWorks database for SQL Server 2008R2 version

Installing AdventureWorks database for SQL Server 2008R2 version
Venkatesan Jayakantham Aug 12, 2011
SQL Tips

SQL Tips
Rachit Patel Jun 24, 2011
Trigger in Sql Server

Triggers are fire by the database when specific types of data manipulation commands are performed on specific table or tables.
Sandeep Shekhawat Jun 01, 2011
Paging in SQL SERVER 2005 / 2008

Paging Can improve your performance in ASP.NET application.
Gohil Jayendrasinh May 07, 2011
Difference between stored procedure and Functions

What is difference between Stored procedure and Functions? Stored procedures:
Vishal Nayan Apr 30, 2011

401 - 420 of 498

Alchemy