SqlServerKudos - Stories tagged with SQL

SQL

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, 22 minutes ago posted by pinaldavepinaldave 19 days, 9 hours, 58 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, 27 minutes ago posted by pinaldavepinaldave 21 days, 12 hours, 57 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, 12 minutes ago posted by pinaldavepinaldave 30 days, 18 hours, 2 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, 23 minutes ago posted by pinaldavepinaldave 33 days, 17 hours, 6 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

The SQL Server MasterClass Experience | AdaTheDev
published 31 days, 6 hours, 53 minutes ago posted by AdaTheDevAdaTheDev 40 days, 10 hours, 43 minutes ago
Wednesday, June 30, 2010 1:06:43 PM GMT Monday, June 21, 2010 9:16:06 AM GMT
The SQL Server MasterClass Experience | AdaTheDev
SQL Server MasterClass 2010 was a very high quality, one day event presented by Paul S. Randal and Kimberly L. Tripp - not that they need any introduction of course. In fact if you don't know of them, then perhaps you should close down your SSMS window and switch off your machine - after reading my blog of course :). Maybe uninstall SQL Server too... The A-Team With two of the best SQL Server trainers in the industry offering a packed schedule of sessions, it was an... (more)
category: Community | clicked: 0 | comment | | source: www.adathedev.co.uk
tags: DBA, SQL, SQL Server, 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, 6 hours, 53 minutes ago posted by pinaldavepinaldave 40 days, 16 hours, 26 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, 23 minutes ago posted by pinaldavepinaldave 46 days, 11 hours, 20 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, 48 minutes ago posted by pinaldavepinaldave 52 days, 16 hours, 8 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

TSQL Challenge 31 - Managing multiple overlapping date intervals. - TSQL Challenges
published 49 days, 8 hours, 14 minutes ago posted by jacobsebastianjacobsebastian 58 days, 13 hours, 55 minutes ago
Saturday, June 12, 2010 11:45:32 AM GMT Thursday, June 03, 2010 6:04:38 AM GMT
TSQL Challenge 31 - Managing multiple overlapping date intervals. - TSQL Challenges
This challenge is adapted from a budgeting system used in a large company to perform quarterly analysis of what kind of work will be done and where it will be done. Project Managers make plans and the estimated hours of work required from each employee each month end up in a central database. Top managers want to see a synthesis of this by department and profession. Your job is to provide this synthesis using all the other information in that database described below. In particular, we are interested in... (more)
category: Query | clicked: 0 | comment | | source: beyondrelational.com
tags: puzzles, SQL, SQLServer, TSQL, tsql challenges
1
kudos
spam Kudos Remove

SQL SERVER – Stored Procedure and Transactions « Journey to SQL Authority with Pinal Dave
published 50 days, 8 hours, 19 minutes ago posted by pinaldavepinaldave 58 days, 18 hours, 40 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

Optimising wildcard prefixed LIKE conditions | AdaTheDev
published 57 days, 8 hours, 50 minutes ago posted by AdaTheDevAdaTheDev 66 days, 11 hours, 44 minutes ago
Friday, June 04, 2010 11:09:34 AM GMT Wednesday, May 26, 2010 8:15:03 AM GMT
Optimising wildcard prefixed LIKE conditions | AdaTheDev
An overview on how to use indexed computed columns to optimise the performance wildcard prefixed LIKE conditions within an SQL query. (more)
category: Query | clicked: 2 | comment | | source: www.adathedev.co.uk
tags: Optimization, Performance, SQL, 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 ago posted by pinaldavepinaldave 66 days, 18 hours, 40 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, 38 minutes ago posted by pinaldavepinaldave 75 days, 9 hours, 7 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, 23 minutes ago posted by pinaldavepinaldave 86 days, 19 hours, 11 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, 10 hours, 53 minutes ago posted by pinaldavepinaldave 94 days, 16 hours, 41 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, 29 minutes ago posted by pinaldavepinaldave 100 days, 2 hours, 36 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, 11 hours, 54 minutes ago posted by pinaldavepinaldave 102 days, 8 hours, 1 minute 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, 15 minutes ago posted by pinaldavepinaldave 113 days, 10 hours, 3 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, 29 minutes ago posted by pinaldavepinaldave 115 days, 18 hours, 47 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, 14 minutes ago posted by pinaldavepinaldave 126 days, 13 hours, 8 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
Previous 1 2 Next