Convert Rows to Columns with aggregate functions (dotnetvj.com)

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

In todays post i would like to show you a simple way to convert rows into columns with aggregate functions. You can also use PIVOT feature to do the same. read more...

add a comment |category: Database |Views: 55

tags: kadiyalavj dotnetvj Database another

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

Enable SQL Full-text Filter daemon Launcher Process (dotnetvj.com)

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

In this post I would like to give you simple tip to enable SQL Full-text Filter daemon Launcher (MSSQLSERVER): read more...

add a comment |category: Database |Views: 119

tags: Vijaya_Kadiyala dotnetvj Database another

How to find whether Full Text is Installed or not(dotnetvj.com)

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

In this post I would like to give you simple tip to find out whether Full Text is installed or not. read more...

add a comment |category: Database |Views: 6

tags: Vijaya_Kadiyala dotnetvj Database another

Why we should avoid * in SELECT Clause to improve query performance (dotnetvj.com)

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

Why SQL Server experts say don’t use * in SELECT clause. Always use the columns what you need. In this article I am going to list out the points with examples on why we should avoid * in the SELECT clause. read more...

add a comment |category: Database |Views: 33

tags: Vijaya_Kadiyala dotnetvj Database another

What to do when SELECT query is Running Slowly? (dotnetvj.com)

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

What to do when SELECT query is Running Slowly? Just follow 10 simple tips to find out. read more...

add a comment |category: Database |Views: 16

tags: Vijaya_Kadiyala dotnetvj Database another

3 simple tips to design a table(dotnetvj.com)

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

Check out the 3 simple tips to design a table. read more...

add a comment |category: Database |Views: 11

tags: Vijaya_Kadiyala dotnetvj Database another

Find out the objects on which the view depends either directly or indi(dotnetvj.com)

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

I would like to give you a simple query to find out objects where view depends on either directly or in-directly. read more...

add a comment |category: Database |Views: 1

tags: Vijaya_Kadiyala dotnetvj Database another

Generate DDL of a Table Using SQL Server Management Studio (dotnetvj.com)

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

Today I would like to give you simple tip to generate the DDL of a table using SQL Server Management Studio. read more...

add a comment |category: Database |Views: 40

tags: Vijaya_Kadiyala dotnetvj Database another

Format Date in SQL Server(dotnetvj.com)

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

In this section you are going to explore various ways to format date using CONVERT function. read more...

add a comment |category: Database |Views: 20

tags: Vijaya_Kadiyala dotnetvj Database another

Most Widley used SQL Server System Tables(dotnetvj.com)

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

In this article, I would like to list out most widely used SQL Server System tables/views which we need in our day-to-day work. read more...

add a comment |category: Database |Views: 91

tags: Vijaya_Kadiyala dotnetvj Database another

The Execution Process of an INSERT statement (dotnetvj.com)

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

Today I was in the interview panel, and there was one very basic question. The question is “What happens when you execute INSERT statement on table which has Identity column, Primary Key, Check constraint, Not Null Constraint, Foreign key, Instead Of Trigger and After Trigger.” Which one gets executed first? read more...

add a comment |category: Database |Views: 14

tags: Vijaya_Kadiyala dotnetvj Database another

Insert Multiple Rows with Single INSERT statement in SQL Server (dotnetvj.com)

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

Today, I am going to give you simple and efficient TIP to insert multiple records with single INSERT statement. read more...

add a comment |category: Database |Views: 181

tags: Vijaya_Kadiyala dotnetvj Database another

Filtering Sensitive Text in SQL Server -- From Raul Garcia(dotnetvj.com)

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

I came accross a very good article on filtering sensitive data such as password and make sure this is data is not exposed in SQL Server Traces. read more...

add a comment |category: Database |Views: 7

tags: Vijaya_Kadiyala dotnetvj Database another

Most Power Full commands in PowerShell (dotnetvj.com)

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

Today I am going to talk about the 3 most power full commands you need to know to get started on PowerShell. read more...

add a comment |category: Other |Views: 7

tags: Vijaya_Kadiyala dotnetvj another

Changing Prompt And Execution Policy in PowerShell (dotnetvj.com)

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

In this article I am going to show you, how to change the prompt of your PowerShell and few lines about Execution Policy in PowerShell. read more...

add a comment |category: Other |Views: 6

tags: Vijaya_Kadiyala dotnetvj another