pinaldave

pinaldave
Name: pinaldave
Score: 1,935.01
Last Seen: 184 days, 10 hours, 34 minutes ago
Member Since: 27 July, 2009
SqlServerKudos
atom rss
1
kudos
spam Kudos Remove

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy – Day 4 of 35 « Journey to SQLAuthority
published 178 days, 10 hours, 34 minutes ago posted by pinaldavepinaldave 184 days, 10 hours, 34 minutes ago
Wednesday, August 10, 2011 5:46:18 PM GMT Thursday, August 04, 2011 5:46:28 PM GMT
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy – Day 4 of 35 « Journey to SQLAuthority
Answer simple quiz at the end of the blog post and - Every day one winner from India will get Joes 2 Pros Volume 1. Every day one winner from United States will get Joes 2 Pros Volume 1.Query Writing Strategy Some people may push back on this next technique or misunderstand until getting to the very end. The goal is to have fewer errors as you write complex queries more quickly by making sure the easy stuff works first. If you are a SQL expert who only works on the same database for the rest of you... (more)
category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com
1
kudos
spam Kudos Remove

SQL SERVER – Copy Statistics from One Server to Another Server
published 387 days, 23 minutes ago posted by pinaldavepinaldave 395 days, 49 minutes ago
Friday, January 14, 2011 3:57:45 AM GMT Thursday, January 06, 2011 3:31:23 AM GMT
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
spam Kudos Remove

Known Unknown of System Stored Procedure of sys.sp_tables
published 466 days, 6 hours, 52 minutes ago posted by pinaldavepinaldave 475 days, 11 hours, 30 minutes ago
Tuesday, October 26, 2010 9:28:39 PM GMT Sunday, October 17, 2010 4:49:54 PM GMT
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: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
2
kudos
spam Kudos Remove

SQL SERVER – Soft Delete – IsDelete Column – Your Opinion « Journey to SQL Authority with Pinal Dave
published 510 days, 9 hours, 52 minutes ago posted by pinaldavepinaldave 517 days, 22 hours, 37 minutes ago
Sunday, September 12, 2010 6:28:30 PM GMT Sunday, September 05, 2010 5:43:40 AM GMT
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
spam Kudos Remove

Why SQL Server is better than any other RDBMS Applications?
published 530 days, 11 hours, 17 minutes ago posted by pinaldavepinaldave 539 days, 16 hours, 40 minutes ago
Monday, August 23, 2010 5:03:47 PM GMT Saturday, August 14, 2010 11:39:56 AM GMT
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
spam Kudos Remove

SHRINKDATABASE For Every Database in the SQL Server
published 532 days, 11 hours, 26 minutes ago posted by pinaldavepinaldave 542 days, 1 hour, 19 minutes ago
Saturday, August 21, 2010 4:53:56 PM GMT Thursday, August 12, 2010 3:01:43 AM GMT
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
spam Kudos Remove

SQL SERVER – Computed Column – PERSISTED and Performance
published 541 days, 12 hours, 7 minutes ago posted by pinaldavepinaldave 550 days, 13 hours, 22 minutes ago
Thursday, August 12, 2010 4:13:38 PM GMT Tuesday, August 03, 2010 2:58:10 PM GMT
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
spam Kudos Remove

SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN « Journey to SQL Authority with Pinal Dave
published 564 days, 13 hours, 43 minutes ago posted by pinaldavepinaldave 572 days, 18 hours, 19 minutes ago
Tuesday, July 20, 2010 2:37:27 PM GMT Monday, July 12, 2010 10:00:59 AM GMT
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
spam Kudos Remove

The Self Join – Inner Join and Outer Join - An Example
published 565 days, 13 hours, 48 minutes ago posted by pinaldavepinaldave 574 days, 21 hours, 18 minutes ago
Monday, July 19, 2010 2:32:31 PM GMT Saturday, July 10, 2010 7:02:19 AM GMT
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
spam Kudos Remove

SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial « Journey to SQL Authority with Pinal Dave
published 575 days, 14 hours, 33 minutes ago posted by pinaldavepinaldave 584 days, 2 hours, 23 minutes ago
Friday, July 09, 2010 1:47:01 PM GMT Thursday, July 01, 2010 1:57:13 AM GMT
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
spam Kudos Remove

Statistics without Index - Possible and Helpful
published 578 days, 14 hours, 44 minutes ago posted by pinaldavepinaldave 587 days, 1 hour, 27 minutes ago
Tuesday, July 06, 2010 1:36:26 PM GMT Monday, June 28, 2010 2:53:17 AM GMT
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
spam Kudos Remove

SQL SERVER – Data Pages in Buffer Pool – Data Stored in Memory Cache « Journey to SQL Authority with Pinal Dave
published 585 days, 15 hours, 14 minutes ago posted by pinaldavepinaldave 594 days, 47 minutes ago
Tuesday, June 29, 2010 1:05:59 PM GMT Monday, June 21, 2010 3:32:59 AM GMT
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
spam Kudos Remove

SQL SERVER – Shrinking NDF and MDF Files – Readers’ Opinion « Journey to SQL Authority with Pinal Dave
published 591 days, 15 hours, 44 minutes ago posted by pinaldavepinaldave 599 days, 19 hours, 41 minutes ago
Wednesday, June 23, 2010 12:36:16 PM GMT Tuesday, June 15, 2010 8:39:04 AM GMT
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
spam Kudos Remove

SQL SERVER – Fastest Way to Restore the Database « Journey to SQL Authority with Pinal Dave
published 596 days, 16 hours, 9 minutes ago posted by pinaldavepinaldave 606 days, 29 minutes ago
Friday, June 18, 2010 12:11:40 PM GMT Wednesday, June 09, 2010 3:51:09 AM GMT
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
spam Kudos Remove

SQL SERVER – Stored Procedure and Transactions « Journey to SQL Authority with Pinal Dave
published 603 days, 16 hours, 40 minutes ago posted by pinaldavepinaldave 612 days, 3 hours, 1 minute ago
Friday, June 11, 2010 11:40:35 AM GMT Thursday, June 03, 2010 1:19:41 AM GMT
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
spam Kudos Remove

SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions « Journey to SQL Authority with Pinal Dave
published 612 days, 17 hours, 21 minutes ago posted by pinaldavepinaldave 620 days, 3 hours, 1 minute ago
Wednesday, June 02, 2010 10:59:41 AM GMT Wednesday, May 26, 2010 1:19:51 AM GMT
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
spam Kudos Remove

SQL SERVER – Find Most Expensive Queries Using DMV « Journey to SQL Authority with Pinal Dave
published 621 days, 17 hours, 59 minutes ago posted by pinaldavepinaldave 628 days, 17 hours, 28 minutes ago
Monday, May 24, 2010 10:21:16 AM GMT Monday, May 17, 2010 10:52:25 AM GMT
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
spam Kudos Remove

SQL SERVER – Get Latest SQL Query for Sessions – DMV « Journey to SQL Authority with Pinal Dave
published 631 days, 18 hours, 44 minutes ago posted by pinaldavepinaldave 640 days, 3 hours, 32 minutes ago
Friday, May 14, 2010 9:36:43 AM GMT Thursday, May 06, 2010 12:48:27 AM GMT
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
spam Kudos Remove

SQL SERVER – GUID vs INT – Your Opinion « Journey to SQL Authority with Pinal Dave
published 638 days, 19 hours, 14 minutes ago posted by pinaldavepinaldave 648 days, 1 hour, 2 minutes ago
Friday, May 07, 2010 9:06:17 AM GMT Wednesday, April 28, 2010 3:18:39 AM GMT
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
spam Kudos Remove

SQL SERVER – Create Primary Key with Specific Name when Creating Table « Journey to SQL Authority with Pinal Dave
published 646 days, 19 hours, 50 minutes ago posted by pinaldavepinaldave 653 days, 10 hours, 57 minutes ago
Thursday, April 29, 2010 8:30:15 AM GMT Thursday, April 22, 2010 5:22:57 PM GMT
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
Previous 1 2 Next