Technology with Vivek Johari: SQL Tips

Technology with Vivek Johari

Learn database in a simple and easy way.

Pages

Home
Author Profile
Articles Index
Interview Questions
SQL Tips
Readers Feedback
Disclaimer & Copyright
Contact Me
SQL Puzzles
BI- SSIS, SSRS, SSAS

SQL Tips

How to remane a Table in Sql Server?

How to change the database collation?

How to find duplicate values in a table?

How to make database offline or online?

Renaming a column in Sql Server?

Email This BlogThis!Share to Twitter Share to Facebook

1 comment:

Obaidullah KhanJanuary 24, 2013 at 5:18 PM
Nice Post sir,,,,,,,,
ReplyDelete

Subscribe to: Posts (Atom)

Facebook Share

UpTweet

Translate

Follow @vivekjohari

Wizpert

Top Comments

NEWS

Become one of the contributor at SQLServerPedia

SQLServerPedia

Find my blog on NOKIA OVI Store too.

Link to NOKIA OVI store

Proud to be an INDIAN

About Me

Vivek Johari: Vivek JohariI am currently working as a Analyst and have around 6 years of experience in database. I have the degree in Master Degree in Computer(MCA). My work experience includes Designing of the database,Database Optimization,Writing Complex Stored Procedures,Functions,Triggers etc., Designing and developing SSIS and DTS packages, Designing SQL Reports using SSRS,Database Server Maintenance. Currently, I am working in Magic Software Pvt.Ltd. in Noida.My certifications inclues Microsoft certified Sql DBA in Sql server 2008 (MCTS), Microsoft certified BI professional in Sql server 2008 (MCTS), Oracle certified profession DBA in ORACLE 10g (OCP),certified profession DBA in ORACLE 9i (OCP). Guest author at Sqlservercentral.com, BeyondRelational.com.

View my complete profile

MCTS(SQL Server 2008 DBA)

MCTS ( SQL Server 2008 BI)

Page Rank

Oracle Certified Professional

My Certification

My Sql Server Central Profile

My CodeProject Profile

Code Project Profile

Beyondrelational.com Scorecard

Popular Posts

Difference between Subquery, Nested Subquery and Correlated Subquery

Query: - Query can be defined as a way to inquire the data from the database. It is used to extract the data from one table or multi...
SQL Triggers - An Introduction

Introduction Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do ...
Difference between Clustered Index and Non clustered Index

Indexes -Indexing is way to sort and search records in the table. It will improve the speed of locating and retrieval of records from the t...
Difference Between Having and Where Clause in Sql Server

Both Having Clause and Where clause is used to filter the data coming from the Select statement, but still there are some differences betwe...
Boyce - Codd Normal Form (BCNF)

Boyce - Codd Normal Form (BCNF) :- A normal form is said to be a Boyce - Codd Normal Form if it is in 3NF and there is not a possibility ...

Search This Blog

Loading...

Articles Category

Acid Property in Sql Server (1)
Acid Rules (1)
Adding (1)
Alter table (1)
BCNF (1)
Boyce - Codd Normal Form (1)
Check Constraints (1)
Clustered Index (2)
CodeProject (12)
Common table expression (1)
CTE command In Sql Server (1)
Cursor in sql server (1)
Database Normalization (1)
DCL (1)
DDL (1)
Deleting and Updating a Column in a table (1)
Derived table (1)
Derived Table In Sql Server (1)
Difference between Clustered Index and Non clustered Index (1)
Difference between Delete and Truncate Command (1)
Difference Between Having and Where Clause (1)
Difference between Primary key and Unique key (1)
Difference Between Stored Procedure and Function (1)
DML (1)
Duplicate Values (1)
First Normal form (INF) (1)
Foreign Key (1)
Fragmentation in SQL Server (1)
Global temporary tables in SQL Server (1)
Group By (1)
Happy New Year (1)
Having Clause (3)
How to change the database collation (1)
How to find duplicate values in a table (1)
How to make database offline or online (1)
How to remane a Table in Sql Server (1)
IDENTITY Property (1)
Identity Column (1)
Indexes in sql server (1)
Insertion of data in table (1)
Interview Questions on sql server (3)
Interview Questions On sql server -Part 2 (1)
Interview Questions on Sql Server -Part 3 (1)
Interview Questions on sql server -Part-1 (1)
Isolation levels in SQL Server (1)
Local temporary table in SQL Server (1)
Log Shipping in SQL Server (1)
Merge Command In Sql Server (1)
Merger statement (1)
Nested Subquery and Correlated Subquery (1)
Non clustered Index (2)
Normalization (1)
Not Null (1)
output Clause in SQL Server (1)
Pivot and Unpivot table in SQL SERVER (1)
Pivot table (1)
Primary key (2)
Rebuild And Reorganization of Indexes (1)
Renaming a column (1)
Replication in SQL Server (1)
Second Normal Form (2NF) (1)
SQL Functions (1)
Sql Server (5)
Sql Server - Difference between Union and Union All (1)
SQL Server - Global temporary tables (1)
SQL Server - Local temporary table (1)
Sql server Constraints - Primary Key (1)
Sql Server Cross Joins (1)
Sql Server Inner Joins (1)
Sql Server Joins (1)
Sql Server Outer Joins (1)
Sql Server Self Joins (1)
Sql Server View (1)
SQL Server- Output clause (1)
SQL Server-Table Variable (1)
Sql Triggers (1)
SQLServerPediaSyndication (6)
Stored Procedures in Sql Server (1)
Subquery (1)
Table Creation (1)
TCL (1)
Temp Variable (1)
Thanks letter (1)
Third Normal Form (3NF) (1)
Unique Key (2)
Unpivot table (1)
User defined functions in SQL (1)
Views (1)

Follow by Email

Followers

Subscribe To

Posts

Posts

All Comments

All Comments

Google+ Followers

Visitors to this blogs

Feedjit

Share It

Total Pageviews

FeedBurner FeedCount

Subscribe To

Posts

Posts

All Comments

All Comments

Subscribe To My Podcast

Blogs follows

SQL Server Solutions & Information
Mera Jahaan !!

BlogCatalog

Proud to be an IndiBlogger

Labels

Acid Property in Sql Server (1)
Acid Rules (1)
Adding (1)
Alter table (1)
BCNF (1)
Boyce - Codd Normal Form (1)
Check Constraints (1)
Clustered Index (2)
CodeProject (12)
Common table expression (1)
CTE command In Sql Server (1)
Cursor in sql server (1)
Database Normalization (1)
DCL (1)
DDL (1)
Deleting and Updating a Column in a table (1)
Derived table (1)
Derived Table In Sql Server (1)
Difference between Clustered Index and Non clustered Index (1)
Difference between Delete and Truncate Command (1)
Difference Between Having and Where Clause (1)
Difference between Primary key and Unique key (1)
Difference Between Stored Procedure and Function (1)
DML (1)
Duplicate Values (1)
First Normal form (INF) (1)
Foreign Key (1)
Fragmentation in SQL Server (1)
Global temporary tables in SQL Server (1)
Group By (1)
Happy New Year (1)
Having Clause (3)
How to change the database collation (1)
How to find duplicate values in a table (1)
How to make database offline or online (1)
How to remane a Table in Sql Server (1)
IDENTITY Property (1)
Identity Column (1)
Indexes in sql server (1)
Insertion of data in table (1)
Interview Questions on sql server (3)
Interview Questions On sql server -Part 2 (1)
Interview Questions on Sql Server -Part 3 (1)
Interview Questions on sql server -Part-1 (1)
Isolation levels in SQL Server (1)
Local temporary table in SQL Server (1)
Log Shipping in SQL Server (1)
Merge Command In Sql Server (1)
Merger statement (1)
Nested Subquery and Correlated Subquery (1)
Non clustered Index (2)
Normalization (1)
Not Null (1)
output Clause in SQL Server (1)
Pivot and Unpivot table in SQL SERVER (1)
Pivot table (1)
Primary key (2)
Rebuild And Reorganization of Indexes (1)
Renaming a column (1)
Replication in SQL Server (1)
Second Normal Form (2NF) (1)
SQL Functions (1)
Sql Server (5)
Sql Server - Difference between Union and Union All (1)
SQL Server - Global temporary tables (1)
SQL Server - Local temporary table (1)
Sql server Constraints - Primary Key (1)
Sql Server Cross Joins (1)
Sql Server Inner Joins (1)
Sql Server Joins (1)
Sql Server Outer Joins (1)
Sql Server Self Joins (1)
Sql Server View (1)
SQL Server- Output clause (1)
SQL Server-Table Variable (1)
Sql Triggers (1)
SQLServerPediaSyndication (6)
Stored Procedures in Sql Server (1)
Subquery (1)
Table Creation (1)
TCL (1)
Temp Variable (1)
Thanks letter (1)
Third Normal Form (3NF) (1)
Unique Key (2)
Unpivot table (1)
User defined functions in SQL (1)
Views (1)

Technology with Vivek Johari

Subscribe in a reader

counter for blogspot

Simple template. Powered by Blogger.