SQL SERVER – Find Most Expensive Queries Using DMV(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

The title of this post is what I can express here for this quick blog post. I was asked in recent query tuning consultation project, if I can share my script which I use to figure out which is the most expensive queries are running on SQL Server. This script is very basic and very simple, there are many different versions are available online. This basic script does do the job which I expect to do – find out the most expensive queries on SQL Server Box. read more...

add a comment |category: Database |Views: 484

tags: SQLAuthority pinaldave SQLServer Database SQL another

Find Most Expensive Queries Using DMV(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

Mystery Resolved - One Query to Find Most Expensive Database Query - DMV read more...

add a comment |category: Database |Views: 12

tags: SQLAuthority pinaldave SQLServer Database SQL another

Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

A Story of Disabled Index read more...

add a comment |category: Database |Views: 8

tags: SQLAuthority pinaldave SQLServer Database SQL another

Download Microsoft SQL Azure Frequently Asked Questions (FAQ)(beyondrelational.com)

submitted by jacobsebastian(3639) 2 years ago

If you are struggling with a SQL Azure problem, one of the first resource to refer is the Microsoft SQL Azure FAQ document which presents a number of commonly asked SQL Azure questions along with a very detailed answer to each of them. read more...

add a comment |category: Database |Views: 135

tags: SQLInjection SQLServer Database SQL another

Get Latest SQL Query for Sessions(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

This is number one request from any developer regarding how to see what was the latest query for that session. read more...

add a comment |category: Database |Views: 275

tags: SQLAuthority pinaldave SQLServer Database SQL another

Getting Started with LINQ(beyondrelational.com)

submitted by DPalkar(228) 2 years ago

In this we’ll continue to discuss how to go about the SQL Server Data Access using various technologies. This post will discuss Microsoft Language Integrated Query, otherwise known as LINQ. I will discuss how it can be used to accomplish the same tasks we have discussed in previous posts. But before that it surely requires a good introduction to start with. LINQ was introduced with .net 3.0 as one of the language enhancements. It uses generics, which was introduced in .net 2.0, thoroughly to accomplish what it was designed to do. LINQ is designed to query virtually any kind of data source which implements IEnumerable<T> interface. It allows you to query the data by emulating the SQL query expressions using any .net language you are comfortable with. Isn’t that amazing!! read more...

add a comment |category: Linq |Views: 346

tags: SQL Query getting Expressions Started another

Getting Started with LINQ(beyondrelational.com)

submitted by DPalkar(228) 2 years ago

In this we’ll continue to discuss how to go about the SQL Server Data Access using various technologies. This post will discuss Microsoft Language Integrated Query, otherwise known as LINQ. I will discuss how it can be used to accomplish the same tasks we have discussed in previous posts. But before that it surely requires a good introduction to start with. LINQ was introduced with .net 3.0 as one of the language enhancements. It uses generics, which was introduced in .net 2.0, thoroughly to accomplish what it was designed to do. LINQ is designed to query virtually any kind of data source which implements IEnumerable<T> interface. It allows you to query the data by emulating the SQL query expressions using any .net language you are comfortable with. Isn’t that amazing!! read more...

add a comment |category: Linq |Views: 346

tags: SQL Query LINQ Server Started another

What is AdventureWorks? - The known and the Unknown Story(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

The known and the Unknown Story read more...

add a comment |category: Database |Views: 49

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL SERVER – GUID vs INT – Your Opinion(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

Take your side. State your case. Learn the reality. read more...

1 comment |category: Database |Views: 773

tags: SQLAuthority int pinaldave GUID Database another

Create Primary Key with Specific Name when Creating Table(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 1 month ago

Does your PK has big long not readable name? Well this is quick post to save the day! read more...

add a comment |category: Database |Views: 273

tags: SQLAuthority pinaldave SQLServer Database SQL another

SELECT INTO is faster than CREATE and INSERT(beyondrelational.com)

submitted by ashish.gilhotra(354) 2 years, 1 month ago

This article explain Why SELECT.. INTO is faster than CREATE &amp;amp; INSERT... read more...

add a comment |category: Database |Views: 466

tags: SQL Database another

SQL XML Bulk Load - more XSD syntax(www.sqlstuff.dk)

submitted by Svelmoe(45) 2 years, 1 month ago

Schema (XSD) syntax for SQL XML Bulk Load importing XML files. read more...

add a comment |category: XML |Views: 46

tags: XML SQL another

Configure Management Data Collection - A Quick Tip for Every Developer(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 1 month ago

The three most important components of any computer and server are the CPU, Memory, and Hard disk specification. This post talks about how to get more details about these three most important components using the Management Data Collection. Management Data Collection generates the reports for the three said components by default. Configuring Data Collection is a very easy task and can be done very quickly. read more...

add a comment |category: Database |Views: 182

tags: SQLAuthority pinaldave SQLServer Database SQL another

virtual database - A Unique Tool for Testers, DBA, Developers(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 1 month ago

It is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database backup was 40 GB in size, and, to restore it on our production server, it usually takes around 16 to 22 minutes, depending on the load server that is usually present. This range in time varies from one server to another as per the configuration of the computer. Some other issues we used to have are the following: 1. When we try to restore a large 40-GB database, we needed at least that much space on our production server. 2. Once in a while, we even had to make changes in the restored database, and use the said changed and restored database for our purpose, making it more time-consuming. read more...

1 comment |category: Database |Views: 330

tags: SQLAuthority pinaldave SQLServer Database SQL another

Snapshot Databases - A Wonderful Gift to Testers(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 1 month ago

If you do not know how Snapshot database work, here is a quick note on the subject. However, please refer to the official description on Book-on-Line for accuracy. Snapshot database is a read-only database created from an original database called the “source database”. read more...

add a comment |category: Database |Views: 314

tags: SQLAuthority pinaldave SQLServer Database SQL another

Michael DeFehr explains his winning solution to TSQL Challenge 14(beyondrelational.com)

submitted by jacobsebastian(3639) 2 years, 1 month ago

Michael DeFehr has written an excellent explanation of his winning solution to TSQL Challenge 14. read more...

add a comment |category: Database |Views: 18

tags: TSQL beyondrelational TSQLChallenges Server Database another