In this issue

Featured Contents


Featured Script

SQL Doc Hate explaining your database in meetings?
SQL Doc quickly documents your entire database schema so that you can easily present it to others. "This tool is embarrassingly easy to use." David Hayden, Download a free trial now.
SQL DBA Bundle Hard Earned Lessons ‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now.
Deployment Manager How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial.

In This Issue

The Importance of Reading Comments

Read when you search for help on the internet. You might miss a very important part of what you must do. More »

Help us improve SQL Source Control

We've been working really hard on SQL Source Control, and need your input. We're currently working on suggestions from our user forum and on an updated migrations feature that supports all source control systems and works across branches. We'd love it if you could spare 10 minutes to complete this survey. If you complete the survey by Friday June 14, you could win a $100 Amazon voucher. There are two up for grabs!  More »

Extend SQL Server DDL Triggers for more functionality: Part 2

A previous tip, SQL Server DDL Triggers to Track All Database Changes, generated a lot of discussion involving ways to make the provided DDL trigger more useful. Check out this tip to expand your knowledge on DDL Triggers. More »

From the SQLServerCentral Blogs - Building a SharePoint 2013 BI Demo Environment Part 5 – Installing SharePoint

Let’s get started with the next step in the series: installing SharePoint. We will install only the software, but we... More »

Editorial - No R2

At least not for SQL Server. There was an announcement last week at TechEd that the next version of SQL Server will be coming in the next year and will be named SQL Server 2014. No SQL Server 2012 R2, which I think is a good decision. As much as I don't think naming much matters for many things, releasing a second product with it's own set of patches, under the moniker of a previous product, makes for confusion. No shortage of people have tried to restore databases from SQL Server 2008 R2 to SQL Server 2008, or apply patches built for one, on the other.

Three main products were announced: Windows Server 2012 R2System Center 2012 R2, and SQL Server 2014. I still don't understand why the branding for the other products hasn't changed, but as long as SQL Server is moving forward, I'm happy. All three products have lots of changes, but some of the biggest ones are in linking more features from the cloud platform, specifically Azure, to those products. I'm not sure what it means for the other products, but for SQL Server, I was surprised, and a little scared, by this quote:

 “there is no such thing as a SQL Server team anymore. There is, in fact, no code base called SQL Server. There’s only one code base, which is the Azure database code base.” 

It's been printed a few times that Microsoft is focused on Azure first, and their development will occur there first and slowly make its into the boxed product. I can understand that, even if I don't like it. I still think Azure needs competition outside of Microsoft, but we'll see what happens as development moves forward.

In terms of SQL Server 2014, there are lots of new items to be excited about. The in-memory "Hekaton" structures, updateable columnstore indexes, AlwaysOn expanded to 8 secondaries with online indexing and more. I am anxious to see how the sub-roles work for security, and if we can allow more administration without access to data, I'm very interested. The Resource Governor that handles IO is another one I've wanted for quite a few versions.

I don't know when we'll be able to test things, and I don't know when we'll get the RTM bits, but if you have instances you've been thinking about moving to SQL Server 2012, I might hold off and see how the first CTP shakes out.

» Join the debate, and respond to today's editorial on the forums

The Voice of the DBA Podcast

We publish three versions of our podcast daily. We do not have any podcasts today due to technical issues. The podcast will return tomorrow.

» To submit an article, rant or editorial, log in to the Contribution Center

Question of the Day

Today's Question:

Suppose I am upgrading SQLServer 2008 R2 to SQLServer 2012.In need to identify the deprecated features that will not be supported in feature releases. What are the event classes to identity the deprecated features.

Think you know the answer? Click here, and find out if you are right.

This question is worth 1 point in this category: SQLProfiler. We keep track of your score to give you bragging rights against your peers.

We'd love to give you credit for your own question and answer. To submit a QOD, simply log in to Contribution Center.

Expert Performance Indexing for SQL Server 2012

Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals.

Get your copy from Amazon today.

Yesterday's Question of the Day

What will be returned from the last 2 selects ?


SET @a = 0.115
SET @b = 0.075
SET @c = 0.04

 SELECT @b + @c


 WHERE N = 0.115

 WHERE N > 0.114
 AND N < 0.116

Answer: The first will return 1 record and the second will return 2 records.

Explanation: The results have to do with the floating point storage and calculation my Microsoft in SQL Server. I can't find any specific links to this issue but a quote from Microsoft "Approximate-number data types for use with floating point numeric data. Floating point data is approximate; therefore, not all values in the data type range can be represented exactly."


This may explain the inaccuracies.

» Discuss this question and answer on the forums

SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.

Get your copy from Amazon today.

Featured Script

What's changed recently?

Often when tracking down problems, you need to know if anything has changed recently, this script will tell you... More »

Database Pros Who Need Your Help!

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2005 : Administering

Linking between Oracle and Unisys DMS II - Can anyone help me with the query please..?? I just wanted to know if i can establish the link server from...

Whether Always on is enabled between Clusters? - Hello all! I really hope that it's a right place to public my question. I try to find whether Always on of...

SQL agent configured to call a SP - All, My problem scenarion is: "I have a SQL agent job setup that calls a SP which collects all data and sends...

"Sql server error 5120" while attaching database - HI, I am trying to attach few databases to sql server 2005.I have my .mdf files in "D:\MSSQL\Data" and my .ldf...

SQL Server 2005 : Backups

Restore existing database failed due to space issue - All, I have two data servers S1 and S2. I have a database D1. D1 exists in both S1 and S2....

SQL Server 2005 : Business Intelligence

SSRS - DateTime parameter issue - I have deployed a report which has DateTime parameter on sharepoint server. The server is located in india. When i...

to display my report (rsWindowsIntegratedSecurityDisabled) - Hii all; I deployed my report successfully (SSRS) , but when I click on it in the manager report to display it...

Import Dynamic File Name with a Date/Time as the file type (YYYYMMDDHRMMSS) - For some unknown reason, the creator of this file set the naming convention to something I can't begin to fathom......

SSAS - how to view cubes - I come from Cognos, and try to understand how users can view and manipulate cubes once they are created? do...

Proactive caching scheduled notification not working - Hi can anyone tell me how scheduled notification works.I tried to work on it but did not understand polling query...

SQL Server 2005 : Development

Convert Column into rows depending on Date. - Hi All, Please suggest me an idea on the below scenario. I am having table which contain studentid,studentname,startdate,enddate. Sample data is...

SQL Server 2008 : SQL Server 2008 - General

SQL Server Startup Options - Hi All, Can anyone tell me what the -F startup option does? I can't seem to find anything online for...

SSIS - Component which will pass the data to dataset or inline memory location - Which Component which will pass the data to dataset or inline memory location ? a) Source b) Destination c) Path d) Transformation

SQl Server R2 Enterprise Evaluation link anyone? - Hi, Anyone got a link or is hosting the older 2008 R2 enterprise evaluation version, I need to load up an...

Column update - this is my select query [size="1"] select CalDate, Timein, Timeout , CONVERT(varchar(8),DATEADD(ss,DATEDIFF(ss,[Timein],[Timeout]),0),108) AS SpendTime_runtime, CAST (ABS( 540 - DATEDIFF (MINUTE, Timein, timeout ) ) / 60 as varchar ) + ':' +-- Hours ( + ':' separator ) CAST...

Backup with transaction log?? - Hi, I want to do a backup of a db and restore to another for testing purposes. The db is 100G with...

linked server issue - Hello, I have setup a linked server between SQL Server 2008 R2 and MAS90 server and I am able to...

creating logon & logoff triggers in MSSQL - We have several database that we track user logons for, until now all these databases resided in Oracle. For Oracle...

SQL Server 2008 : T-SQL (SS2K8)

Odd Conversion Error - Hello Everyone I would like to remove the '(999)' from the phone number that someone that did not know what they...

SQL Server 2008 : Security (SS2K8)

Sql Serer Data Protection Tool - Hi, We are looking any Data Security tool for out existing Data for Protection, we would like to do the Data...

SQL Server 2008 : SQL Server 2008 High Availability

Clustering Question - Hope I can be pointed in the right direction and clustering isn't my strongest point. Had a scenario given to me...

SQL Server 2008 : SQL Server 2008 Administration

sp_executesql -- can produce very wrong execution plan - A front end app sends a query to SQL 2008 using sp_executesql. The query returns a count as the final result. The...

Questions on Index Rebuilding (not reorganize) - Hi Guys, Need some information on Index Rebuilding. (sort_in_tempdb = off) When performing index rebulding (for indexes > 30% fragmented), will we expect...

Career : Certification

SQL 2012 BI MCSA - 70-462 or 70-463 - Which to take next - Passed 70-461 today. Have a project to establish a BI warehouse. What would make sense to take as the next...

Programming : General

Counting weekdays within a date range and grouping them by month - Hi Folks, I was hoping I can get some help and your expertise on below reuirement. I have this data where first...

Programming : XML

import and shred xml file to sql 2008 table (openrowset) - Hello, I'm also trying to import certain fields of an xml-file into an existing sql table (neutc_import). Problem is: I get '0... : Anything that is NOT about SQL!

The Beer Cooler Thread - On popular request - at least one! - a dedicated topic about beer. I shall start with my favorite beer: Duvel. It is...

Reporting Services : Reporting Services

Client side function error - I am trying to add a function to a subreport but continually get the error 'subreport could not be shown'. I...

Database Design : Disaster Recovery

Whether Always on is enabled between Clusters? - Hello all! I really hope that it's a right place to public my question. I try to find whether Always on of...

Database Design : Design Ideas and Questions

What normal form would this be considered? 2NF or 3NF? - Lets say I have a table with four columns named PersonID1, PersonID2, JobTitle, and PreviousJobTitle. There is a composite primary...