SqlServerKudos

jacobsebastian

Name:	jacobsebastian
Score:	2,437
Last Seen:	83 days, 19 hours, 7 minutes ago
Member Since:	22 April, 2010

1
kudos

Kudos

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

published 76 days, 14 hours, 32 minutes ago posted by

jacobsebastian 84 days, 16 hours, 38 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 77 days, 14 hours, 37 minutes ago posted by

jacobsebastian 85 days, 21 hours, 25 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

2
kudos

Kudos

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

published 77 days, 14 hours, 37 minutes ago posted by

jacobsebastian 86 days, 14 hours, 15 minutes ago

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

In this post, Jason provides a quick overview of SSAS Dimension Attribute properties and provides a wonderful explanation of each property. (more)

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

tags: analysis, Cube, Data Mining, Data Warehousing, database, Dimension, SQLServer, SSAS

1
kudos

Kudos

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

published 78 days, 14 hours, 42 minutes ago posted by

jacobsebastian 87 days, 14 hours, 16 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 81 days, 14 hours, 57 minutes ago posted by

jacobsebastian 90 days, 17 hours, 25 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 82 days, 15 hours, 2 minutes ago posted by

jacobsebastian 91 days, 16 hours, 48 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 83 days, 15 hours, 7 minutes ago posted by

jacobsebastian 92 days, 22 hours, 19 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

Understanding SQL Server Datetime column - Part II

published 84 days, 15 hours, 12 minutes ago posted by

jacobsebastian 93 days, 20 hours, 21 minutes 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

Calculating ROI on Performance Tuning - Never Say Never

published 85 days, 15 hours, 16 minutes ago posted by

jacobsebastian 94 days, 21 hours, 38 minutes ago

Calculating ROI on Performance Tuning - Never Say Never

Recently on the SSC forums, someone asked about how to measure the money in an actual dollar figure that they have saved the company with their performance tuning. I've often struggled with this myself, and so I started thinking about it a bit deeper. I started to respond in the thread; then decided I was going to be a bit too long winded so I moved it here. The following are some of my thoughts/opinions on the subject. I think everyone will agree that it's probably not worth the time to optimize a ... (more)

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

tags: roi, SQLServer

2
kudos

Kudos

Display Total on top of Stacked Chart - Some Random Thoughts

published 88 days, 15 hours, 28 minutes ago posted by

jacobsebastian 97 days, 20 hours, 56 minutes ago

Display Total on top of Stacked Chart - Some Random Thoughts

It is a normal phenomenon that human beings take most of the simple things for granted. Take this case, one of my blog readers sent me a mail asking how to display the total on top of a stacked chart in SSRS. The first time I read it, I was almost going to blurt - just enable some property to display subtotals. But the more I thought about it, the more elusive the property became and that is when I realized there is no such property. So for the benefit of all, I thought about posting the workaround that ... (more)

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

tags: SQLServer, SSRS

1
kudos

Kudos

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

published 89 days, 15 hours, 33 minutes ago posted by

jacobsebastian 98 days, 21 hours, 14 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

SELECT * FROM XML - Jacob's Blog

published 90 days, 15 hours, 38 minutes ago posted by

jacobsebastian 99 days, 13 hours, 29 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

2
kudos

Kudos

Auto-update of parameter datasets in SSRS 2008 - Some Random Thoughts

published 91 days, 15 hours, 43 minutes ago posted by

jacobsebastian 100 days, 17 hours, 14 minutes ago

Auto-update of parameter datasets in SSRS 2008 - Some Random Thoughts

The times I have spent with SSRS 2008 can be likened to that of a married couple’s life story. The moment I first laid my eyes on her during the Microsoft seminars and community previews, I knew that she was going to be the one. I secretly started collecting details about her, as much as possible and awaited her arrival. Needless to say, I was one of the very first to have the trial version installed and in the dates that followed, I was just astounded at her potential – she seemed so full and promising.... (more)

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

1
kudos

Kudos

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

published 92 days, 15 hours, 48 minutes ago posted by

jacobsebastian 101 days, 20 hours, 48 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 93 days, 15 hours, 49 minutes ago posted by

jacobsebastian 103 days, 15 hours, 28 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

1
kudos

Kudos

Understanding Datetime column - Part I - Madhivanan's TSQL Blog

published 94 days, 15 hours, 54 minutes ago posted by

jacobsebastian 103 days, 20 hours, 24 minutes ago

Understanding Datetime column - Part I - Madhivanan's TSQL Blog

There are N number of questions asked in the forums about handling dates in query Most of the people who ask questions dont understand how datetime column works in SQL Server Some of the questions frequently asked are about 1 using dates in the WHERE caluse 2 formatting dates using SQL 3 inserting dates to the table with specific date format etc In this series of blog posts, I would explain them with examples These example are for versions prior to 2008 (more)

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

1
kudos

Kudos

Create Indexes from the Missing Indexes DMV - Never Say Never

published 95 days, 15 hours, 59 minutes ago posted by

jacobsebastian 104 days, 17 hours, 55 minutes ago

Create Indexes from the Missing Indexes DMV - Never Say Never

Glenn Berry (Blog) writes a lot of queries to extract information from the system DMV’s. One of them in particular I found extremely helpful in fixing some of the issues in my system. I took his query (the CTE at the top) and added some text manipulation to actually generate the create statements for you to save you some time. I had much grander plans for this, but unfortunately I’ve been meaning to post this for over a month now and simply haven’t had time to get back to it, so rather than just let i... (more)

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

2
kudos

Kudos

Static Named Sets v/s Dynamic Named Sets - Some Random Thoughts

published 95 days, 15 hours, 59 minutes ago posted by

jacobsebastian 104 days, 19 hours, 28 minutes ago

Static Named Sets v/s Dynamic Named Sets - Some Random Thoughts

Many times, it can happen that we end up writing very complex MDX expressions revolving sets. To simplify such expressions or to improve the performance of some queries, we can extract the definitions of some sets into a separate named set expression which are called named sets. A named set can be created either using a CREATE SET statement or a WITH SET statement (For syntax, refer Building Named Sets in MDX). In SQL Server 2005, there was only the Static named sets feature but in SQL Server 2008, both ... (more)

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

tags: MDX, SSAS

1
kudos

Kudos

TSQL Beginners Challenge 8 - Identify the release dates of movies on different cities - TSQL Challenges for Beginners

published 95 days, 15 hours, 59 minutes ago posted by

jacobsebastian 105 days, 13 hours, 47 minutes ago

TSQL Beginners Challenge 8 - Identify the release dates of movies on different cities - TSQL Challenges for Beginners

Let us one again play with a date related problem. The challenge is to identify the various movies released in cities. There are two tables involved in this challenge. The first table is MovieReleaseDates which will contain the names of movies along with their release dates. The second table will hold the details of releases that happened in different cities. (more)

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

1
kudos

Kudos

SQL Server XML - Un-Making a List (or Shredding of Evidence) - SQL Server Community Blogs

published 96 days, 16 hours, 4 minutes ago posted by

jacobsebastian 105 days, 23 hours, 49 minutes ago

SQL Server XML - Un-Making a List (or Shredding of Evidence) - SQL Server Community Blogs

In my previous blog entry, I described in detail how you could use the FOR XML clause to create a column with a comma-separated list of entries acquired from rows in a table somewhere. In this article, we will do the opposite… We will take a comma-separated list and “shred” the individual items into rows. (more)

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

Welcome!

jacobsebastian

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

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

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts

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

Understanding SQL Server Datetime column - Part II

Calculating ROI on Performance Tuning - Never Say Never

Display Total on top of Stacked Chart - Some Random Thoughts

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

SELECT * FROM XML - Jacob's Blog

Auto-update of parameter datasets in SSRS 2008 - Some Random Thoughts

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

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

Understanding Datetime column - Part I - Madhivanan's TSQL Blog

Create Indexes from the Missing Indexes DMV - Never Say Never

Static Named Sets v/s Dynamic Named Sets - Some Random Thoughts

TSQL Beginners Challenge 8 - Identify the release dates of movies on different cities - TSQL Challenges for Beginners

SQL Server XML - Un-Making a List (or Shredding of Evidence) - SQL Server Community Blogs

Open ID Login

Standard Login

Forgot Password?

Sign up