SqlServerKudos - Stories tagged with pinaldave

pinaldave

atom rss
1
kudos
spam Kudos Remove

SQLAuthority News – FREE Microsoft Visual Studio 2010 Ultimate with MSDN « Journey to SQL Authority with Pinal Dave
published 11 days, 5 hours, 29 minutes ago posted by pinaldavepinaldave 19 days, 10 hours, 6 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 12 days, 5 hours, 34 minutes ago posted by pinaldavepinaldave 21 days, 13 hours, 4 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: 0 | 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 22 days, 6 hours, 19 minutes ago posted by pinaldavepinaldave 30 days, 18 hours, 9 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 25 days, 6 hours, 30 minutes ago posted by pinaldavepinaldave 33 days, 17 hours, 13 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: 2 | 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 32 days, 7 hours, 1 minute ago posted by pinaldavepinaldave 40 days, 16 hours, 33 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 38 days, 7 hours, 30 minutes ago posted by pinaldavepinaldave 46 days, 11 hours, 27 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 43 days, 7 hours, 55 minutes ago posted by pinaldavepinaldave 52 days, 16 hours, 15 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 50 days, 8 hours, 26 minutes ago posted by pinaldavepinaldave 58 days, 18 hours, 47 minutes 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
1
kudos
spam Kudos Remove

SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions « Journey to SQL Authority with Pinal Dave
published 59 days, 9 hours, 7 minutes ago posted by pinaldavepinaldave 66 days, 18 hours, 47 minutes 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 68 days, 9 hours, 45 minutes ago posted by pinaldavepinaldave 75 days, 9 hours, 14 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: 0 | 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 78 days, 10 hours, 30 minutes ago posted by pinaldavepinaldave 86 days, 19 hours, 18 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 85 days, 11 hours ago posted by pinaldavepinaldave 94 days, 16 hours, 48 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 93 days, 11 hours, 36 minutes ago posted by pinaldavepinaldave 100 days, 2 hours, 44 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
1
kudos
spam Kudos Remove

Free eBook Download – Introducing Microsoft SQL Server 2008 R2 « Journey to SQL Authority with Pinal Dave
published 98 days, 12 hours, 1 minute ago posted by pinaldavepinaldave 102 days, 8 hours, 8 minutes ago
Saturday, April 24, 2010 8:05:42 AM GMT Tuesday, April 20, 2010 11:58:48 AM GMT
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: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database « Journey to SQL Authority with Pinal Dave
published 103 days, 12 hours, 22 minutes ago posted by pinaldavepinaldave 113 days, 10 hours, 10 minutes ago
Monday, April 19, 2010 7:44:46 AM GMT Friday, April 09, 2010 9:56:55 AM GMT
SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database « Journey to SQL Authority with Pinal Dave
I recently downloaded Idera’s SQL virtual database, and tested it. There are a few things about this tool which caught my attention. My Scenario 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 ser... (more)
category: Management | clicked: 2 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot « Journey to SQL Authority with Pinal Dave
published 106 days, 12 hours, 37 minutes ago posted by pinaldavepinaldave 115 days, 18 hours, 54 minutes ago
Friday, April 16, 2010 7:29:56 AM GMT Wednesday, April 07, 2010 1:12:38 AM GMT
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot « Journey to SQL Authority with Pinal Dave
Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and can always reside on the same server instance as the database. Each database snapshot is consistent, in terms of transactions, with the source database as of the moment of the snapshot’s creation. A snapshot... (more)
category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Generate Report for Index Physical Statistics – SSMS « Journey to SQL Authority with Pinal Dave
published 116 days, 13 hours, 21 minutes ago posted by pinaldavepinaldave 126 days, 13 hours, 15 minutes ago
Tuesday, April 06, 2010 6:45:27 AM GMT Saturday, March 27, 2010 6:51:29 AM GMT
SQL SERVER – Generate Report for Index Physical Statistics – SSMS « Journey to SQL Authority with Pinal Dave
Few days ago, I wrote about SQL SERVER – Out of the Box – Activity and Performance Reports from SSSMS (Link). A user asked me a question regarding if we can use similar reports to get the detail about Indexes. Yes, it is possible to do the same. There are similar type of reports are available at Database level, just like those available at the Server Instance level. You can right click on Database name and click Reports. Under Standard Reports, you will find following reports. Disk Usage Disk Usage b... (more)
category: Query | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave
published 153 days, 15 hours ago posted by pinaldavepinaldave 163 days, 11 hours, 31 minutes ago
Sunday, February 28, 2010 5:06:08 AM GMT Thursday, February 18, 2010 8:35:26 AM GMT
SQL SERVER – Stored Procedure Optimization Tips – Best Practices « Journey to SQL Authority with Pinal Dave
We will go over how to optimize Stored Procedure with making simple changes in the code. Please note there are many more other tips, which we will cover in future articles. Include SET NOCOUNT ON statement: With every SELECT and DML statement, the SQL server returns a message that indicates the number of affected rows by that statement. This information is mostly helpful in debugging the code, but it is useless after that. By setting SET NOCOUNT ON, we can disable the feature of returning this extra i... (more)
category: Query | clicked: 1 | comment | | source: blog.sqlauthority.com
tags: database, pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate « Journey to SQL Authority with Pinal Dave
published 163 days, 15 hours, 42 minutes ago posted by pinaldavepinaldave 171 days, 6 hours, 54 minutes ago
Thursday, February 18, 2010 4:24:37 AM GMT Wednesday, February 10, 2010 1:12:09 PM GMT
SQL SERVER – Stream Aggregate Showplan Operator – Reason of Compute Scalar before Stream Aggregate « Journey to SQL Authority with Pinal Dave
I keep a check on the questions received from my readers; when any question crosses my threshold, I surely try to blog about it online. Stream Aggregate is a quite commonly encountered showplan operator. I have often found it in very simple COUNT(*) operation’s execution plan. If you like to read an official note on the subject, you can read the same on Book Online over here. The Stream Aggregate operator groups rows by one or more columns and then calculates one or more aggregate expressions returned by... (more)
category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer
1
kudos
spam Kudos Remove

SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2 « Journey to SQL Authority with Pinal Dave
published 197 days, 21 hours, 26 minutes ago posted by pinaldavepinaldave 204 days, 5 hours, 24 minutes ago
Thursday, January 14, 2010 10:40:40 PM GMT Friday, January 08, 2010 2:42:51 PM GMT
SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2 « Journey to SQL Authority with Pinal Dave
In my earlier post, I wrote about how one can use XML to convert table to string SQL SERVER – Comma Separated Values (CSV) from Table Column. The same article is also published on channel 9 SQLAuthority News – Featured on Channel 9. One of the very interesting points that was discussed on show was about the usage of function SUBSTRING. I found the following point very valid: SUBSTRING usage limits the length of the XML to be used. I have re-written the same function with function STUFF, and it removes a... (more)
category: Query | clicked: 0 | comment | | source: blog.sqlauthority.com
tags: pinaldave, SQL, SQLAuthority, SQLServer, XML
Previous 1 2 Next