DotNetShoutout

SQLServer

6
Shouts

Shout it

Display Total on top of Stacked Chart - Some Random Thoughts

published 1081 days, 6 hours, 42 minutes ago posted by

jacobsebastian 1081 days, 14 hours, 33 minutes ago

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: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQLServer, SSRS

6
Shouts

Shout it

TSQL Challenge 31 - Managing multiple overlapping date intervals.

published 1081 days, 6 hours, 42 minutes ago posted by

jacobsebastian 1082 days, 14 hours, 53 minutes ago

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: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: tsql challenges, TSQL, puzzles, SQLServer

10
Shouts

Shout it

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

published 1080 days, 9 hours, 14 minutes ago posted by

pinaldave 1082 days, 19 hours, 38 minutes ago

Learn the truth behind following statement - “I do not use Transactions in SQL as I use Stored Procedure“. (more)

category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

4
Shouts

Shout it

SELECT * FROM XML - Jacob's Blog

published 1082 days, 11 hours, 34 minutes ago posted by

jacobsebastian 1083 days, 6 hours, 44 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: Data | clicked: 2 | comment | | source: beyondrelational.com

tags: xquery, XML, SQLServer

5
Shouts

Shout it

EAV and the .NET Framework

published 1081 days, 6 hours, 42 minutes ago posted by

http://mahdi.mp/ 1083 days, 11 hours, 4 minutes ago

A wrapup on Entity-Attribute-Value pattern in databases and current .NET framework implementations available. (more)

category: Data | clicked: 17 | comment | | source: mahdi.mp

tags: .NET, eav, SQLServer

3
Shouts

Shout it

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

published 1084 days, 10 hours, 16 minutes ago posted by

jacobsebastian 1085 days, 14 hours, 28 minutes ago

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: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: XML, SQLServer

2
Shouts

Shout it

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

published 1086 days, 10 hours, 25 minutes ago posted by

jacobsebastian 1087 days, 9 hours, 6 minutes ago

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: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: tsql challenges, challenges, TSQL, puzzles, SQLServer

5
Shouts

Shout it

SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions « Journey to SQL Authority with Pinal Dave

published 1090 days, 10 hours, 39 minutes ago posted by

pinaldave 1090 days, 19 hours, 37 minutes ago

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: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

6
Shouts

Shout it

SQL SERVER – Find Most Expensive Queries Using DMV « Journey to SQL Authority with Pinal Dave

published 1098 days, 5 hours, 9 minutes ago posted by

pinaldave 1099 days, 10 hours, 5 minutes ago

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: Data | clicked: 2 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

3
Shouts

Shout it

Encrypt and Decrypt a Password using EncryptByPassPhrase and DecryptByPassPhrase

posted by

dotnetfunda 1099 days, 20 hours, 14 minutes ago

This Article explains you how to Encrypt and Decrypt a text in SQL Server. (more)

category: Data | clicked: 6 | comment | | source: www.dotnetfunda.com

| flag as spam

tags: SQLServer

4
Shouts

Shout it

Configuring the Data Access Application Block

published 1103 days, 11 hours, 33 minutes ago posted by

jacobsebastian 1103 days, 17 hours, 53 minutes ago

This post explains how to configure Microsoft Data Access Application Block on a .NET application. (more)

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

tags: SQLServer, Data Access Layer

5
Shouts

Shout it

SQL SERVER – Get Latest SQL Query for Sessions – DMV « Journey to SQL Authority with Pinal Dave

posted by

pinaldave 1110 days, 20 hours, 8 minutes ago

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: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

| flag as spam

tags: SQL, SQLServer, pinaldave, SQLAuthority

8
Shouts

Shout it

SQL SERVER – GUID vs INT – Your Opinion « Journey to SQL Authority with Pinal Dave

published 1117 days, 9 hours, 49 minutes ago posted by

pinaldave 1118 days, 17 hours, 38 minutes ago

Take your side. State your case. Learn the reality. (more)

category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

6
Shouts

Shout it

SQL SERVER – Create Primary Key with Specific Name when Creating Table « Journey to SQL Authority with Pinal Dave

published 1123 days, 9 hours, 48 minutes ago posted by

pinaldave 1124 days, 3 hours, 35 minutes ago

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: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

9
Shouts

Shout it

Free eBook Download – Introducing Microsoft SQL Server 2008 R2 « Journey to SQL Authority with Pinal Dave

published 1125 days, 9 hours, 32 minutes ago posted by

pinaldave 1126 days, 9 hours, 1 minute ago

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: Data | clicked: 2 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

7
Shouts

Shout it

SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database « Journey to SQL Authority with Pinal Dave

published 1135 days, 10 hours, 40 minutes ago posted by

pinaldave 1137 days, 11 hours ago

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: Data | clicked: 1 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

5
Shouts

Shout it

SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot « Journey to SQL Authority with Pinal Dave

published 1139 days, 9 hours, 42 minutes ago posted by

pinaldave 1139 days, 19 hours, 47 minutes ago

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: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: SQLServer, pinaldave, SQLAuthority

4
Shouts

Shout it

Download SQL Server 2008 R2 Developers Training Kit

published 1144 days, 6 hours, 30 minutes ago posted by

eralper 1145 days, 6 hours, 53 minutes ago

With the t-sql enhancements and t-sql improvements introduced with MS SQL Server 2005 and with MS SQL Server 2008, coding in t-sql is enabling many difficult tasks to be implemented easier in less code. (more)

category: Data | clicked: 0 | comment | | source: www.kodyaz.com

tags: Training, SQL, SQLSERVER2008, SQLServer

7
Shouts

Shout it

SQL SERVER – Interview Questions & Answers Needs Your Help « Journey to SQL Authority with Pinal Dave

published 1158 days, 7 hours, 53 minutes ago posted by

pinaldave 1158 days, 16 hours, 26 minutes ago

About an year ago, I had posted SQL Server related Interview Questions and Answers. It was very well received in community. I have received many comments, suggestions and emails on this subject. I am planning to upgrade the Interview Questions and Answers and take it to next level. Here, I need your help. Please your comments, suggestions, expectation or potential interview Question (along with answer) here. Your input will be very valuable. As time goes by we all learn and get better. There were few th... (more)

category: Data | clicked: 0 | 1 comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

7
Shouts

Shout it

SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE « Journey to SQL Authority with Pinal Dave

published 1159 days, 8 hours, 16 minutes ago posted by

pinaldave 1160 days, 8 hours, 57 minutes ago

Today, we are going to discuss about something very simple, but quite commonly confused two options of ALTER DATABASE. The first one is ALTER DATABASE …ROLLBACK IMMEDIATE and the second one is WITH NO_WAIT. Many people think they are the same or are not sure of the difference between these two options. Before we continue our explaination, let us go through the explanation given by Book On Line. ROLLBACK AFTER integer [SECONDS] | ROLLBACK IMMEDIATE Specifies whether to roll back after a specified numb... (more)

category: Data | clicked: 0 | comment | | source: blog.sqlauthority.com

tags: SQL, SQLServer, pinaldave, SQLAuthority

Welcome!

SQLServer

Display Total on top of Stacked Chart - Some Random Thoughts

TSQL Challenge 31 - Managing multiple overlapping date intervals.

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

SELECT * FROM XML - Jacob's Blog

EAV and the .NET Framework

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

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

SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions « Journey to SQL Authority with Pinal Dave

SQL SERVER – Find Most Expensive Queries Using DMV « Journey to SQL Authority with Pinal Dave

Encrypt and Decrypt a Password using EncryptByPassPhrase and DecryptByPassPhrase

Configuring the Data Access Application Block

SQL SERVER – Get Latest SQL Query for Sessions – DMV « Journey to SQL Authority with Pinal Dave

SQL SERVER – GUID vs INT – Your Opinion « Journey to SQL Authority with Pinal Dave

SQL SERVER – Create Primary Key with Specific Name when Creating Table « Journey to SQL Authority with Pinal Dave

Free eBook Download – Introducing Microsoft SQL Server 2008 R2 « Journey to SQL Authority with Pinal Dave

SQL SERVER – Retrieve and Explore Database Backup without Restoring Database – Idera virtual database « Journey to SQL Authority with Pinal Dave

SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot « Journey to SQL Authority with Pinal Dave

Download SQL Server 2008 R2 Developers Training Kit

SQL SERVER – Interview Questions & Answers Needs Your Help « Journey to SQL Authority with Pinal Dave

SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE « Journey to SQL Authority with Pinal Dave

Open ID Login

Standard Login

Forgot Password?

Sign up