SqlServerKudos

pinaldave

1
kudos

Kudos

SQL SERVER – Copy Statistics from One Server to Another Server

published 496 days, 2 hours, 32 minutes ago posted by

pinaldave 504 days, 2 hours, 58 minutes ago

SQL SERVER – Copy Statistics from One Server to Another Server

A very efficient way of copying database statistics from one server to another server without moving data. (more)

category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

Known Unknown of System Stored Procedure of sys.sp_tables

published 575 days, 9 hours, 1 minute ago posted by

pinaldave 584 days, 13 hours, 40 minutes ago

Known Unknown of System Stored Procedure of sys.sp_tables

Do you know even simple query like sys.tables can kill the performance of your system. There are better thing to use: Read more... (more)

category: Query | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

2
kudos

Kudos

SQL SERVER – Soft Delete – IsDelete Column – Your Opinion « Journey to SQL Authority with Pinal Dave

published 619 days, 12 hours, 1 minute ago posted by

pinaldave 627 days, 46 minutes ago

SQL SERVER – Soft Delete – IsDelete Column – Your Opinion « Journey to SQL Authority with Pinal Dave

Just a day ago, I was reading the blog post of Michale J Swart. If you are a regular reader of this blog, I am sure you will be familiar with him. He is a very interesting blogger for sure. He recently wrote an article about Ten Things I hate to See in T-SQL; it was really fun, but the thing which caught my eyes was the subject of isDeleted Column. First of all, let me say that I totally agree with his view point. Let me re-produce what Michale exactly suggests. “Deleted records aren’t deleted. Look, th... (more)

category: Query | clicked: 3 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

Why SQL Server is better than any other RDBMS Applications?

published 639 days, 13 hours, 26 minutes ago posted by

pinaldave 648 days, 18 hours, 50 minutes ago

Why SQL Server is better than any other RDBMS Applications?

I strongly suggest that you bookmark this post as this post can be used in future when you might want to write why SQL Server is better than any other RDBMS application. (more)

category: Query | clicked: 3 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SHRINKDATABASE For Every Database in the SQL Server

published 641 days, 13 hours, 36 minutes ago posted by

pinaldave 651 days, 3 hours, 28 minutes ago

SHRINKDATABASE For Every Database in the SQL Server

This article is an interesting story of Shrinking the Database. Do you Shrink your database - learn the story today! (more)

category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SQL SERVER – Computed Column – PERSISTED and Performance

published 650 days, 14 hours, 16 minutes ago posted by

pinaldave 659 days, 15 hours, 32 minutes ago

SQL SERVER – Computed Column – PERSISTED and Performance

Did you know computed columns are computed at run time? Yes or No? If yes, you know the answer of following question: Is it better with performance or not? If no, go on and read it... (more)

category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN « Journey to SQL Authority with Pinal Dave

published 673 days, 15 hours, 52 minutes ago posted by

pinaldave 681 days, 20 hours, 29 minutes ago

SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN « Journey to SQL Authority with Pinal Dave

I just received following “NOT FOR SALE” subscription of Microsoft Visual Studio 2010 Ultimate with MSDN. As a MVP, MCT I already have free subscription to MSDN and TechNet. I plan to give away this free subscription to someone who is need of the same or can use it the best. You can win the subscription. I will pick the winner of the subscription on 25th of the July. Which means you have 10 days to take part. I will decide the winner with the help of fellow MVPs and subject matter experts. You need to ... (more)

category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

The Self Join – Inner Join and Outer Join - An Example

published 674 days, 15 hours, 57 minutes ago posted by

pinaldave 683 days, 23 hours, 27 minutes ago

The Self Join – Inner Join and Outer Join - An Example

Self Join has always been an note-worthy case. It is interesting to ask questions on self join in a room full of developers. I often ask – if there are three kind of joins, i.e.- Inner Join, Outer Join and Cross Join; what type of join is Self Join? The usual answer is that it is an Inner Join. In fact, it can be classified under any type of join. Read more for example. (more)

category: Query | clicked: 3 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial « Journey to SQL Authority with Pinal Dave

published 684 days, 16 hours, 43 minutes ago posted by

pinaldave 693 days, 4 hours, 32 minutes ago

SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial « Journey to SQL Authority with Pinal Dave

I previously wrote about SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer earlier and since then I have received many emails requesting to explain how it works. I assume that you can download and install the tool successfully. Once done just follow the steps listed below. You will be successfully able to test multiple instances of SQL Server using this tool. Once the tool is launched, select the product you wish to analysis. Click on Start Scan will take few minut... (more)

category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

Statistics without Index - Possible and Helpful

published 687 days, 16 hours, 53 minutes ago posted by

pinaldave 696 days, 3 hours, 36 minutes ago

Statistics without Index - Possible and Helpful

A Simple note about the subject, how statistics can be helpful and how they are created. (more)

category: Query | clicked: 3 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache « Journey to SQL Authority with Pinal Dave

published 694 days, 17 hours, 24 minutes ago posted by

pinaldave 703 days, 2 hours, 57 minutes ago

SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache « Journey to SQL Authority with Pinal Dave

This will drop all the clean buffers so we will be able to start again from there. Now, run the following script and check the execution plan of the query. Have you ever wondered what types of data are there in your cache? During SQL Server Trainings, I am usually asked if thereis any way one can know how much data in a table is stored in the memory cache? The more detailed question I usually get is if there are multiple indexes on table (and used in a query), were the data of the single table stored mu... (more)

category: Query | clicked: 2 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SQL SERVER – Shrinking NDF and MDF Files – Readers’ Opinion « Journey to SQL Authority with Pinal Dave

published 700 days, 17 hours, 53 minutes ago posted by

pinaldave 708 days, 21 hours, 51 minutes ago

SQL SERVER – Shrinking NDF and MDF Files – Readers’ Opinion « Journey to SQL Authority with Pinal Dave

Previously, I had written a blog post about SQL SERVER – Shrinking NDF and MDF Files – A Safe Operation. After that, I have written the following blog post that talks about the advantage and disadvantage of Shrinking and why one should not be Shrinking a file SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008. On this subject, SQL Server Expert Imran Mohammed left an excellent comment. I just feel that his comment is worth a big article itself. For everybody to read his wonderful explanatio... (more)

category: Query | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SQL SERVER – Fastest Way to Restore the Database « Journey to SQL Authority with Pinal Dave

published 705 days, 18 hours, 18 minutes ago posted by

pinaldave 715 days, 2 hours, 39 minutes ago

SQL SERVER – Fastest Way to Restore the Database « Journey to SQL Authority with Pinal Dave

A few days ago, I received following email: “Pinal, We are in an emergency situation. We have a large database of around 80+ GB and its backup is of 50+ GB in size. We need to restore this database ASAP and use it; however, restoring the database takes forever. Do you think a compressed backup would solve our problem? Any other ideas you got?” First of all, the asker has already answered his own question. Yes; I have seen that if you are using a compressed backup, it takes lesser time when you try to ... (more)

category: Query | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SQL SERVER – Stored Procedure and Transactions « Journey to SQL Authority with Pinal Dave

published 712 days, 18 hours, 49 minutes ago posted by

pinaldave 721 days, 5 hours, 10 minutes ago

SQL SERVER – Stored Procedure and Transactions « Journey to SQL Authority with Pinal Dave

http://blog.sqlauthority.com/2010/06/02/sql-server-stored-procedure-and-transactions/ (more)

category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

2
kudos

Kudos

SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions « Journey to SQL Authority with Pinal Dave

published 721 days, 19 hours, 30 minutes ago posted by

pinaldave 729 days, 5 hours, 10 minutes ago

SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions « Journey to SQL Authority with Pinal Dave

To learn any technology and move to a more advanced level, it is very important to understand the fundamentals of the subject first. Today, we will be talking about something which has been quite introduced a long time ago but not properly explored when it comes to the isolation level. Snapshot Isolation was introduced in SQL Server in 2005. However, the reality is that there are still many software shops which are using the SQL Server 2000, and therefore cannot be able to maintain the Snapshot Isolatio... (more)

category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SQL SERVER – Find Most Expensive Queries Using DMV « Journey to SQL Authority with Pinal Dave

published 730 days, 20 hours, 8 minutes ago posted by

pinaldave 737 days, 19 hours, 37 minutes ago

SQL SERVER – Find Most Expensive Queries Using DMV « Journey to SQL Authority with Pinal Dave

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. SELECT TOP 10 SUBSTRING(qt.TEXT, (qs.statement_sta... (more)

category: Query | clicked: 5 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SQL SERVER – Get Latest SQL Query for Sessions – DMV « Journey to SQL Authority with Pinal Dave

published 740 days, 20 hours, 53 minutes ago posted by

pinaldave 749 days, 5 hours, 41 minutes ago

SQL SERVER – Get Latest SQL Query for Sessions – DMV « Journey to SQL Authority with Pinal Dave

In recent SQL Training I was asked, how can one figure out what was the last SQL Statement executed in sessions. The query for this is very simple. It uses two DMVs and created following quick script for the same. SELECT session_id, TEXT FROM sys.dmexecconnections CROSS APPLY sys.dmexecsqltext(mostrecentsqlhandle) AS ST While working with DMVs if you ever find any DMV has column with name sqlhandle you can right away join that DMV with another DMV sys.dmexecsqltext and can get the tex... (more)

category: Community | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SQL SERVER – GUID vs INT – Your Opinion « Journey to SQL Authority with Pinal Dave

published 747 days, 21 hours, 23 minutes ago posted by

pinaldave 757 days, 3 hours, 11 minutes ago

SQL SERVER – GUID vs INT – Your Opinion « Journey to SQL Authority with Pinal Dave

Take your side. State your case. Learn the reality. (more)

category: Query | clicked: 3 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

SQL SERVER – Create Primary Key with Specific Name when Creating Table « Journey to SQL Authority with Pinal Dave

published 755 days, 21 hours, 59 minutes ago posted by

pinaldave 762 days, 13 hours, 7 minutes ago

SQL SERVER – Create Primary Key with Specific Name when Creating Table « Journey to SQL Authority with Pinal Dave

It is interesting how sometimes the documentation of simple concepts is not available online. I had received email from one of the reader where he has asked how to create Primary key with a specific name when creating the table itself. He said, he knows the method where he can create the table and then apply the primary key with specific name. The attached code was as follows: (more)

category: Query | clicked: 3 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

Free eBook Download – Introducing Microsoft SQL Server 2008 R2 « Journey to SQL Authority with Pinal Dave

published 760 days, 22 hours, 24 minutes ago posted by

pinaldave 764 days, 18 hours, 31 minutes ago

Free eBook Download – Introducing Microsoft SQL Server 2008 R2 « Journey to SQL Authority with Pinal Dave

Microsoft Press has published FREE eBook on the most awaiting release of SQL Server 2008 R2. The book is written by Ross Mistry (@rossmistry) and Stacia Misner. Ross is my personal friend and one of the most active book writer in SQL Server Domain. When I see his name on any book, I am sure that it will be high quality and easy to read book. Ross has written many other books, which I am big fan of as well. The details about the book is here: Introducing Microsoft SQL Server 2008 R2, by Ross Mistry and... (more)

category: News | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

Welcome!

pinaldave

SQL SERVER – Copy Statistics from One Server to Another Server

Known Unknown of System Stored Procedure of sys.sp_tables

SQL SERVER – Soft Delete – IsDelete Column – Your Opinion « Journey to SQL Authority with Pinal Dave

Why SQL Server is better than any other RDBMS Applications?

SHRINKDATABASE For Every Database in the SQL Server

SQL SERVER – Computed Column – PERSISTED and Performance

SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN « Journey to SQL Authority with Pinal Dave

The Self Join – Inner Join and Outer Join - An Example

SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial « Journey to SQL Authority with Pinal Dave

Statistics without Index - Possible and Helpful

SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache « Journey to SQL Authority with Pinal Dave

SQL SERVER – Shrinking NDF and MDF Files – Readers’ Opinion « Journey to SQL Authority with Pinal Dave

SQL SERVER – Fastest Way to Restore the Database « Journey to SQL Authority with Pinal Dave

SQL SERVER – Stored Procedure and Transactions « Journey to SQL Authority with Pinal Dave

SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions « Journey to SQL Authority with Pinal Dave

SQL SERVER – Find Most Expensive Queries Using DMV « Journey to SQL Authority with Pinal Dave

SQL SERVER – Get Latest SQL Query for Sessions – DMV « Journey to SQL Authority with Pinal Dave

SQL SERVER – GUID vs INT – Your Opinion « Journey to SQL Authority with Pinal Dave

SQL SERVER – Create Primary Key with Specific Name when Creating Table « Journey to SQL Authority with Pinal Dave

Free eBook Download – Introducing Microsoft SQL Server 2008 R2 « Journey to SQL Authority with Pinal Dave

Open ID Login

Standard Login

Forgot Password?

Sign up