Error!
Success!

By tag: Kadiyala

showing:  of
0
kicks

Get Database Traffic Report in SQL Server  (Unpublished)

My Database team is working on, to find the database traffic on the server. The database is heavily used by the Online appllication and it is 24/7. We would like to see when the database is heavily loaded and see if there are any processes blocking each other which results in slower performance. One...


Kicked By:
Drop Kicked By:
0
kicks

String Functions in SQL Server Part 1  (Unpublished)

In this article I would like to give you an overview on various string functions that are available in SQL Server and are widley used at work. In this IT world 50% of the databases consist of CHAR, NCHAR, VARCHAR, and NVARCHAR as data types to store the values. When you are joining the tables bas...


Kicked By:
Drop Kicked By:
0
kicks

Useful Stored procedures in SQL Server Part 1  (Unpublished)

There are several predefined stored procedures are available in SQL Server which we are using in our day-to-day life to resolve some of the issues like below. 1) I want to see the all columns of the tables. 2) I want to see who are all logged into Database. 3) I want to see the Constraint infor...


Kicked By:
Drop Kicked By:
0
kicks

60 Seconds with Pinal Dave  (Unpublished)

60 seconds with Pinal Dave: MVP award played an important role in helping me chase my passion to make a difference. VJ caught up with Pinal Dave, MVP in SQL Server, to get his view on the Microsoft Most Valuable Professional Program(MVP).


Kicked By:
Drop Kicked By:
0
kicks

How to find Check Constraints definition and how to drop them  (Unpublished)

In this article I would like to show you on how to find the check constraints defined on a table. In my previous articles I explained about on Check Constraint creation at the Table Level and also at the Column Level.


Kicked By:
Drop Kicked By:
0
kicks

Defining Check Constraints at the Table Level or on multiple Columns  (Unpublished)

In this article I will talk about Table Level Constraints in SQL Server. These are very useful if you want to have rules based on multiple columns with in a table. Lets say busines says "I want to set is if a person opens check-in account and savings account then minimum balance should not be l...


Kicked By:
Drop Kicked By:
0
kicks

Defining Check Constraints at the Column Level  (Unpublished)

In this article I would like to explain about “Constraints”. Constrains are one of the key factor in designing a table. Before I explain what is the use of constrains lets take one real world example. When you are opening a bank account bank says, you need to maintain minimum balance of 1000 in your...


Kicked By:
Drop Kicked By:
0
kicks

Rename Table in SQL Server  (Unpublished)

In this article I would like to explain about how to rename a table using SQL Server Management Studio (SSMS). This is very simple step. There are several ways to do it but i would like to show very simple process.


Kicked By:
Drop Kicked By:
0
kicks

SQL Server Beginer Articles Part 1  (Unpublished)

This link contains list of SQL Server Beginer Articles to start with. Starting from creating a table to Bulk Insert to copy data from text file.


Kicked By:
Drop Kicked By:
0
kicks

MERGE in SQL Server 2005  (Unpublished)

In my previous section I explained about OUTPUT feature in SQL Server. In this section I will go one step ahead and will tell you, how you can use this feature to implement MERGE in SQL Server 2005.


Kicked By:
Drop Kicked By:
0
kicks

Create Table Using Select in Sql Server  (Unpublished)

In this section i would like to give you a small tip about creating a table in SQL Server with out using CREATE TABLE statement.


Kicked By:
Drop Kicked By:
0
kicks

OUTPUT in SQL Server 2005  (Unpublished)

In this session, I would like to talk about one very interesting feature of SQL Server 2005. Before I say anything about this feature let me ask you some simple question.


Kicked By:
Drop Kicked By:
0
kicks

Load text or csv file data into SQL Server  (Unpublished)

Today I will talk about loading a CSV or comma or txt file into SQL Server using BULK INSERT. Using BULK INSERT, in few steps you can load the file into database.


Kicked By:
Drop Kicked By:
0
kicks

Drop table in SQL Server  (Unpublished)

One of common query that we execute on day-to-day to basis is Dropping and re-creating a table when you are as beginner.


Kicked By:
Drop Kicked By:
0
kicks

Computed Columns in SQL Server  (Unpublished)

Today I will talk about one of the very interesting feature called "Computed Columns" in SQL Server. This is a column in table but you will not assign any specific data type to this as you do it in regular CREATE TABLE statement.


Kicked By:
Drop Kicked By: