SqlServerKudos

Query

1
kudos

Kudos

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

published 11 days, 5 hours, 20 minutes ago posted by

pinaldave 19 days, 9 hours, 57 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 12 days, 5 hours, 25 minutes ago posted by

pinaldave 21 days, 12 hours, 55 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: 0 | comment | | source: blog.sqlauthority.com

tags: pinaldave, SQL, SQLAuthority, SQLServer

1
kudos

Kudos

Download SQL Server Developers Training Kit for free | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP

published 13 days, 5 hours, 30 minutes ago posted by

http://ghemant.myopenid.com/ 22 days, 10 hours, 53 minutes ago

Download SQL Server Developers Training Kit for free | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP

Share There are tons of useful resources available for SQL Server but the link I am going to share with all of you today is really the greatest amongst - it's a SQL Server Developers Training Kit. Yes, MS has made the updated version available for we all and the best part is - it's free. The key benefits are: How to build applications with unique and new features available in SQL Server 2008 and SQL Server 2008 R2It contains #55 videos, # 32 presentations, #39 demos and #24 hands-on-labsContent for ... (more)

category: Query | clicked: 2 | comment | | source: www.sql-server-citation.com

tags: developers training kit, download training kit, sql presentations, sql server articles, sql videos, sql-server-citation.com

1
kudos

Kudos

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

published 22 days, 6 hours, 11 minutes ago posted by

pinaldave 30 days, 18 hours, 1 minute 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 25 days, 6 hours, 21 minutes ago posted by

pinaldave 33 days, 17 hours, 4 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: 2 | 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 32 days, 6 hours, 52 minutes ago posted by

pinaldave 40 days, 16 hours, 25 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

FILESTREAM directory structure - where do the GUIDs come from? - Jacob's Blog

published 36 days, 7 hours, 12 minutes ago posted by

jacobsebastian 44 days, 9 hours, 17 minutes ago

FILESTREAM directory structure - where do the GUIDs come from? - Jacob's Blog

SQL Server uses GUID values to name the FILESTREAM folders and you might find it really hard to relate a folder to a table or column. This post explains how you can do it. (more)

category: Query | clicked: 0 | comment | | source: beyondrelational.com

tags: BLOB, DAC, database, DBA, filestream, SQLServer

1
kudos

Kudos

TSQL Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges

published 37 days, 7 hours, 17 minutes ago posted by

jacobsebastian 45 days, 14 hours, 4 minutes ago

TSQL Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges

The idea of this challenge is to clean up the phrase from the words identified as noise words, but only when these words appear at the begining or the end of the string, not in the middle of the string. Your job is to read each row from the source table and remove any noise words from it. The noise words that you need to remove are stored in another table. You should remove the noice words only if they appear at the beginning or end of the sentences. (more)

category: Query | clicked: 1 | comment | | source: beyondrelational.com

tags: Challenge, DBA, Developer, Puzzle, SQL Server, TSQL, tsql challenges

1
kudos

Kudos

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

published 38 days, 7 hours, 22 minutes ago posted by

pinaldave 46 days, 11 hours, 19 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

XQuery Lab 56 – Inserting elements with UNICODE values - Jacob's Blog

published 38 days, 7 hours, 22 minutes ago posted by

jacobsebastian 47 days, 6 hours, 55 minutes ago

XQuery Lab 56 – Inserting elements with UNICODE values - Jacob's Blog

This post explains how to write XML DML queries uisng XQuery in TSQL that deals with UNICODE character strings. (more)

category: Query | clicked: 0 | comment | | source: beyondrelational.com

tags: database, SQLServer, unicode, XML, xml dml, xquery

1
kudos

Kudos

T-SQL Enhancements in SQL 2008

published 41 days, 7 hours, 36 minutes ago posted by

jacobsebastian 50 days, 10 hours, 4 minutes ago

Seth Phelabaum explains his favorite TSQL programmability enhancements added in SQL Server 2008. (more)

category: Query | clicked: 3 | comment | | source: beyondrelational.com

tags: database, Developer, Programmability, SQL Server, TSQL

1
kudos

Kudos

Calculating visit length by first and last visit time in SSRS - Some Random Thoughts

published 42 days, 7 hours, 41 minutes ago posted by

jacobsebastian 51 days, 9 hours, 28 minutes ago

Calculating visit length by first and last visit time in SSRS - Some Random Thoughts

beyondrelational.comSign in | Join | Help HomeBlogsForumsBIXMLTCSQL Tools Visit the new SQL Server Tools and Utilities section and see the products that can make your database administration and development lives easier! First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login. Some Random ThoughtsHomeContactRSS for PostsRecent Blog PostsCalculat... (more)

category: Query | clicked: 0 | comment | | source: beyondrelational.com

tags: Custom Functions, reporting, SQL Server, SSRS

1
kudos

Kudos

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners

published 43 days, 7 hours, 46 minutes ago posted by

jacobsebastian 52 days, 14 hours, 59 minutes ago

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners

This challenge refers to a real-world problem I came across recently. The requirement was to identify all 'direct' or 'indirect' parents of a given child node and all its siblings. (more)

category: Query | clicked: 1 | comment | | source: beyondrelational.com

tags: Challenge, database, Developer, Puzzle, SQL Server, TSQL

1
kudos

Kudos

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

published 43 days, 7 hours, 46 minutes ago posted by

pinaldave 52 days, 16 hours, 7 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

Understanding SQL Server Datetime column - Part II

published 44 days, 7 hours, 51 minutes ago posted by

jacobsebastian 53 days, 13 hours, 1 minute ago

Understanding SQL Server Datetime column - Part II

SQL Server MVP, Madhivanan has come up with the second installment of his DateTime tutorial where he explains the problems of using ambiguous date formats. He also demonstrates a number of TSQL datetime processing tricks. (more)

category: Query | clicked: 1 | comment | | source: beyondrelational.com

tags: DataTypes, date, DateTime, SQL Server, time, TSQL

1
kudos

Kudos

TSQL Challenge 31 - Managing multiple overlapping date intervals. - TSQL Challenges

published 49 days, 8 hours, 12 minutes ago posted by

jacobsebastian 58 days, 13 hours, 53 minutes ago

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

Kudos

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

published 50 days, 8 hours, 17 minutes ago posted by

pinaldave 58 days, 18 hours, 38 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

1
kudos

Kudos

SELECT * FROM XML - Jacob's Blog

published 50 days, 8 hours, 17 minutes ago posted by

jacobsebastian 59 days, 6 hours, 9 minutes ago

This post shows how to run a SELECT * kind of query on an XML document to see the elements, attributes, values and the XPath Expression of each element and attribute in the document. (more)

category: Query | clicked: 1 | comment | | source: beyondrelational.com

tags: SQL Server, XML

1
kudos

Kudos

Delimited String Tennis (Again)… The Final Volley? - SQL Server Community Blogs

published 52 days, 8 hours, 27 minutes ago posted by

jacobsebastian 61 days, 13 hours, 28 minutes ago

Delimited String Tennis (Again)… The Final Volley? - SQL Server Community Blogs

This is a continuation of my previous blog post, Delimited String Tennis Anyone?, which playfully talked about a virtual T-SQL Tennis match… a friendly rally back and forth between SQL Server MVP Adam Haines and myself in discussing methods of shredding comma-delimited strings in our blogs. (more)

category: Query | clicked: 1 | comment | | source: beyondrelational.com

tags: SQLServer, XML

1
kudos

Kudos

Explanation of my winning solution to TSQL Challenge 19 - Dave Ballantyne's Blog

published 53 days, 8 hours, 28 minutes ago posted by

jacobsebastian 63 days, 8 hours, 7 minutes ago

Explanation of my winning solution to TSQL Challenge 19 - Dave Ballantyne's Blog

I have received a number of requests for an explanation of my winning query of TSQL Challenge 19. This involved traversing a hierarchy of employees and rolling a count of orders from subordinates up to superiors. The first concept I shall address is the hierarchyId , which is constructed within the CTE called cteTree. cteTree is a recursive cte that will expand the parent-child hierarchy of the personnel in the table @emp. One useful feature with a recursive cte is that data can be ‘passed’ from the... (more)

category: Query | clicked: 0 | comment | | source: beyondrelational.com

Welcome!

Query

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

Download SQL Server Developers Training Kit for free | SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP

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

FILESTREAM directory structure - where do the GUIDs come from? - Jacob's Blog

TSQL Challenge 32 - Clean up phrases by removing noise words - TSQL Challenges

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

XQuery Lab 56 – Inserting elements with UNICODE values - Jacob's Blog

T-SQL Enhancements in SQL 2008

Calculating visit length by first and last visit time in SSRS - Some Random Thoughts

TSQL Beginners Challenge 9 - Find the Parents and Adjacent Members of the Node - TSQL Challenges for Beginners

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

Understanding SQL Server Datetime column - Part II

TSQL Challenge 31 - Managing multiple overlapping date intervals. - TSQL Challenges

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

SELECT * FROM XML - Jacob's Blog

Delimited String Tennis (Again)… The Final Volley? - SQL Server Community Blogs

Explanation of my winning solution to TSQL Challenge 19 - Dave Ballantyne's Blog

Open ID Login

Standard Login

Forgot Password?

Sign up