Get Database Traffic Report in SQL Server (dotnetvj.com)

submitted by Kadiyalavj(580) 2 years, 5 months ago

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 option which came to my mind is setting up a server side trace and capture rpc complete and sql batch complete events along with other events. read more...

add a comment |category: Database |Views: 13

tags: dotnetvj Kadiyala Database another

String Functions in SQL Server Part 1 (dotnetvj.com)

submitted by Kadiyalavj(580) 3 years ago

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 based on the string family columns then you need to use string functions in order to return right output from your queries or modify t he out put to make it more meaningful. read more...

add a comment |category: Database |Views: 12

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

Useful Stored procedures in SQL Server Part 1 (dotnetvj.com)

submitted by Kadiyalavj(580) 3 years ago

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 information. 4) I want to see all the indexes which are created on a table. 5) I want to rename the objects etc. read more...

add a comment |category: Database |Views: 15

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

60 Seconds with Pinal Dave (dotnetvj.com)

submitted by Kadiyalavj(580) 3 years, 1 month ago

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). read more...

add a comment |category: Other |Views: 54

tags: dotnetvj Vijaya_Kadiyala Vijaya Kadiyala another

How to find Check Constraints definition and how to drop them(dotnetvj.com)

submitted by Kadiyalavj(580) 3 years, 1 month ago

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. read more...

add a comment |category: Database |Views: 16

tags: dotnetvj Vijaya_Kadiyala Database Kadiyala another

Defining Check Constraints at the Table Level or on multiple Columns(dotnetvj.com)

submitted by Kadiyalavj(580) 3 years, 1 month ago

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 less than 800 by combining both" read more...

add a comment |category: Database |Views: 7

tags: dotnetvj Vijaya_Kadiyala Database Kadiyala another

Defining Check Constraints at the Column Level(dotnetvj.com)

submitted by Kadiyalavj(580) 3 years, 1 month ago

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 account. This is a business rule. There are several places to implement this rule. We can implement this in Front-End application or in the Back-end code. read more...

add a comment |category: Database |Views: 4

tags: dotnetvj Vijaya_Kadiyala Database Kadiyala another

Rename Table in SQL Server(dotnetvj.com)

submitted by Kadiyalavj(580) 3 years, 1 month ago

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. read more...

add a comment |category: Database |Views: 150

tags: dotnetvj Vijaya_Kadiyala Database Kadiyala another

SQL Server Beginer Articles Part 1(dotnetvj.com)

submitted by Kadiyalavj(580) 3 years, 1 month ago

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. read more...

add a comment |category: Database |Views: 1

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

MERGE in SQL Server 2005 (dotnetvj.com)

submitted by Kadiyalavj(580) 3 years, 1 month ago

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. read more...

add a comment |category: Database |Views: 15

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

Create Table Using Select in Sql Server (dotnetvj.com)

submitted by Kadiyalavj(580) 3 years, 1 month ago

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. read more...

add a comment |category: Database |Views: 178

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

OUTPUT in SQL Server 2005 (dotnetvj.com)

submitted by Kadiyalavj(580) 3 years, 1 month ago

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. read more...

add a comment |category: Database |Views: 10

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

Load text or csv file data into SQL Server(dotnetvj.com)

submitted by Kadiyalavj(580) 3 years, 1 month ago

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. read more...

add a comment |category: Database |Views: 56

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

Drop table in SQL Server (dotnetvj.com)

submitted by Kadiyalavj(580) 3 years, 1 month ago

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. read more...

add a comment |category: Database |Views: 10

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

Computed Columns in SQL Server (dotnetvj.com)

submitted by Kadiyalavj(580) 3 years, 1 month ago

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. read more...

add a comment |category: Database |Views: 15

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another

Foreign Key and Primary Key in SQL Server (dotnetvj.com)

submitted by Kadiyalavj(580) 3 years, 1 month ago

Check out the below script to find out the Foreign Key information like Name of the Foreign Key , Name of the Table which has foreign Key and List of columns in that Foreign Key definition. In addition to this the foreign key which is referencing the Primary Key and Primary key table or Parent table. read more...

add a comment |category: Database |Views: 33

tags: dotnetvj Vijaya_Kadiyala Kadiyala Database Vijaya another