A community of more than 1,500,000 database professionals and growing

Capturing Baselines on SQL Server: Wait Statistics

Erin Stellato from SQLServerCentral.com

By capturing baseline data, a well=prepared DBA should get a good idea of what potential issues they will face. In this article Erin Stellato looks at Wait Statistics and what they can tell you about your databases. More »

SQL Saturday #183 - Albuquerque

Press Release from SQLServerCentral.com

A free day of training in Albuquerque, New Mexico on Feb 9, 2013. More »

Using the Data Profiling SQL Server Integration Services SSIS task

Additional Articles from MSSQLTips.com

Have you ever had to write a bunch of TSQL to do some data analysis on the table data in your database. If you have you'll know that this can become a fairly time consuming and tedious task? SQL Server 2012 Integration Services has a feature called the Data Profiling task that can help you perform this analysis much easier and faster (this feature is also available in SQL Server 2008). This task can help you find potential issues with your existing data as well as help you become more familiar with the data in a database that you have just started managing.  More »

From the SQLServerCentral Blogs - How to Remove (Undo) Table Partitioning

Patrick Keisler from SQLServerCentral.com

I have seen plenty of articles and blog posts out there for how to setup and implement table partitioning, but... More »

I've been working at home for a decade, first for my own company and now for Red Gate Software. In that time, I've learned to manage myself, motivate myself, find work to do, and meet deadlines, all of which I've done without having anyone manage me. Over the last five years I've worked at Red Gate, I'd like to think that I was one of the easier people to manage since I work well on my own. I'm not sure if my various managers would agree, since I know that I can be particular about how I work and not necessarily work closely with others, but at least I haven't required much of their time.

A short while back I was talking with a friend that was under pressure to complete a deployment that was proceeding poorly and their manager stood next to their desk, watching, commenting, and asking how long each process would take. I've had to deal with that situation in the past, and it was  maddening to me. It's hard enough to focus and work on a task when there are problems with the technology. Having someone that can't contribute but is in a supervisory role nearby usually makes things worse.

Ultimately I think micro-management says more about the manager than the employee. There are trust issues or control issues, or perhaps pressure from the manager's boss. It can be hard to deal with micro-management, but if you plan to continue your employment, you need to find some way to deal with it.

There is no shortage of ideas. You can search for "dealing with micro-management" and you will get a wide variety of advice. I've tried different techniques in the past and some have worked, some haven't. The best way to handle micro-management seems to vary with the situation, but it's good to have a few things to try.

Steve Jones from SQLServerCentral.com

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

The Voice of the DBA Podcasts

We publish three versions of the podcast each day for you to enjoy.

• Watch the Windows Media Podcast - 22.7MB WMV
• Watch the iPod Video Podcast - 18.8MB MP4
• Listen to the MP3 Audio Podcast - 3.9MB MP3

The podcast feeds are available at sqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there. Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

You can also follow Steve Jones on Twitter:

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

Today's Question:

Will both of these queries will return the same result or not?

SELECT DATEADD(YY,114,0)

SELECT DATEADD(YY,0,114)

By Siddharth Tandon

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

This question is worth 1 point in this category: T-SQL. 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.

The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

As the most influential thought leaders in the data warehousing and business intelligence industry, the Kimball Group has developed pioneering techniques that serve as industry standards for DW/BI system design, development, and management. With this new edition of their bestseller, veteran experts from the Kimball Group get you up to speed with using the new Business Intelligence release of SQL Server: SQL Server 2008 R2. Covering the complete suite of data warehousing and BI tools that are part of SQL Server 2008 R2, the authors follow the full project lifecycle, including design, development, deployment, and maintenance. Get your copy today from Amazon.

--
-- Oops! SQL column swap or SQL column clobber?
--
create table #temp (PK int identity, c1 int, c2 int);

insert into #temp values (1,2);
insert into #temp values (3,2);
insert into #temp values (2,1);
insert into #temp values (5,2);
insert into #temp values (5,3);

select * from #temp order by PK;
--
-- Swap columns c1 and c2 on a
-- row-by-row basis if c1 > c2
--

update #temp
 set c1 = c2, c2 = c1
 where c1 > c2;

--
-- Will column c2 clobber column c1
-- BEFORE column c1 can replace column c2?
-- Do we need a temporary column
-- or variable to correct this?
--
select * from #temp order by PK;
--

drop table #temp;

By Thomas Kovarik

Answer: No, column clobber will not occur

Explanation: SQL is a declarative language, even though it can also be used as a procedural language: However, its power lies in its declarative nature. In a procedural language, a column clobber would occur in the algorithm shown above, but not in a declarative language. This task will succeed as coded, because the database engine, behind the scenes and transparent to the SQL programmer, will create a temporary copy of the entire column c1 for later use replacing selective rows of column c2, after column c1 is ‘clobbered’. Hence the code succeeds.

Reference: http://technet.microsoft.com/en-us/library/ms177523(v=sql.110).aspx

» Discuss this question and answer on the forums

Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012

Create and Populate a Date Dimension Table

Joseph Morgan from SQLServerCentral.com

Creates and populates a date-dimension table suitable for OLTP or data warehouse purposes More »

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

SQL Server 2005 : Administering

Log file growing on principal server--log backups scheduled every 2 hrs. - Hi, The transaction log file is growing(currently 99%) and it is close to zero out the disk space. Tranasaction log backups are...

10 physical disks available - best configuration for data/log/backup? - I have 10 300GB SAS 15k rpm 6Gb disks available to me on a HP P2000 SAN. I have a...

SQL Server 2005 : Development

Create string using input values - Hi, I have a beginning Year and a End year and i have to compute/create a string based on the given...

SQL Server 2005 : SQL Server 2005 General Discussion

help needed for sql query - I am working on sql 2005. I have a table wherein it maintains the history of status Customer Status CreatedDate LastUpdateDate CustA...

Load data into excel file from table but each sheet allow 1000 records - Hi All, This is Vivekanand,i have one requirement in ssis that is load data into excel file from table.Table contain 10000...

SQL Server 2005 : T-SQL (SS2K5)

Selection Of Sql Server Version - I am starting a very big project from the scratch.Till now i was using sqlser2005 with Visual Studio.Net2008....Now as my...

Database Design question regarding Normalized Tables - Hey all, Got a theoretical question for you guys. Let's say I have a table that contains information about a store....

Help with SUM and Group By - [code="plain"][code="plain"] Hi! I have a table shown below (just a part of it) and need to aggregate the data as the example...

Problem with Full Text Searching - I have one table in sql server say example Table Name candidates Test table contains some columns cid , cname,c_resume cid in Int...

SQL Server 2005 : SQL Server Newbies

when i am removing user from the server it's promoting an error - Hi........ Any one can provide the solution for the below error in detail. Error Message in SQL SERVER 2005: "Deleting Server logins does...

SQL Server 7,2000 : General

Restore with TSM on a specific date? - Hello, I am trying to retore a database from the 01-29-2013: C:\Program Files\Tivoli\TSM\TDPSql>TDPSQLC RESTORE WSS_Team_Content /RELOCATE=WS S_Team_Content /to="E:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MS SQL\DATA\WSS_Team_Content.mdf" /RELOCATE=WSS_Team_Content_Log /to="E:\Program...

SQL Server 2008 : SQL Server 2008 - General

help on group by with Join - I have two tables. One has records for transactions, another has records for purchased products. Transaction table has TransactionID, TotalAmount,...

facing a diffrent problem alltogether - working on indexed views and facing a tough time getting the query optimizer to pick the resultset from Indexed view... :) - SELECT DT.MO_OF_YR_NM [Month], DT.MO_OF_YR [month_No], DT.YR [Year], DT.MIC_WK_OF_MO_NM [Week], DT.DT [Date], CD.CSTMR_NM [Organisation], PD.BS_LN_NM [Business Line], ED.EMPE_NM [Sales Executive], COUNT( CDBF.CSTM

Convert varbinary to integers and insert - Hi, I have a 28 integers stored in a varbinary that is passed to a stored procedure. The SP needs to...

Execute task based on INSERT - but without triggers - Let me try with first defining what I want to achieve, as I'm very new to SQL I don't know...

Error while creating stored procedure from SQLCMD - Must declare the scalar variable - Hello, I'm Getting the following error when I run the below SQLCMD command and not sure how to resolve this issue: [quote]C:\Test>sqlcmd...

my queries are too slow when SET FORCEPLAN OFF - Hi All, I am using an reporting tool for my dwh system. My tool are generating queries and those queries are too...

Query to sum only few values in a same column - Hello all, I am kind of new to sql server and I am stuck on this. It may sound stupid and...

Full & Simple Recovery Model - what is the standard way to put the database Full recovery model OR Simple recovery model?

Fragmentation does not reduce for some tables - I am defragmenting the database as a maintenance work. But i found that some of the databases avg_fragmentation_in_percent does not...

Design Question - I seem to be struggling with something that I thought was fairly straight-forward originally when I started designing the database...

using replication in sql server 2008 r2 SE (OS: windows server 2008 R2 SE) - We are implementing a new architecture for one our modules. There are 100 tables in the database and out of...

like to install the failover cluster in pc - HI, all like to install the fail-over cluster in pc but there is no cluster group and MSDTC Group is not...

Calculating Running Totals for Today and Today Last Year - I'm trying to calculate a running total for today and today last year. Here's what I use for today last...

SQL Server 2008 : T-SQL (SS2K8)

Error while creating stored procedure from SQLCMD - Must declare the scalar variable - Hello, I'm Getting the following error when I run the below SQLCMD command and not sure how to resolve this issue: [quote]C:\Test>sqlcmd...

NOT makes query never complete? - I understand it may be difficult to assist me without knowing my underlying schema and all the details. Let me...

split string to three parts - I have a comma delimited string that's made up of 3 parts: Word1, Word2, Word3 I want to spli the string and...

Searching through text field - I have a text field (nvarchar max) that contains a chat transcript. I need to find the first chat entry...

SQL Server 2008 : SQL Server Newbies

What forum best for question about replication on SQL Server 2012? - Hello, I've looked through the forums to see if I could figure out the forum that would be the best for...

SQL Server 2008 : SQL Server 2008 High Availability

Need suggestions on replication - We are implementing a new architecture for one our modules. There are 100 tables in the database and out of...

SQL Server 2008 : SQL Server 2008 Administration

Creating a new Management Data Warehouse and removing the old one - When I took on the Role of DBA, i inherited some leftovers from the previous DBA. One such leftover was...

SQL monitoring - CURSORUPDATE - i have a procedure that runs it is cursorupdate, but thats about all i can see, anyway to determine what...

what is pending io count - Is someone able to explain what pending_io_count is in sys.dm_os_tasks please. The description on bol suggests it is io done...

Database Mail Stopped Working - Database Mail on our production server was working fine until about mid-morning today. Nothing has changed on the server that...

Career : Certification

Microsoft Certified Master - There's been a lot of debate recently about whether certifications are worth doing and whether they provide you or your...

Programming : Connecting

Port 56731? - We were having an issue where SSMS was unable to connect to a named instance of SQL Server 2008 R2....

SQLServerCentral.com : Anything that is NOT about SQL!

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...

Reporting Services : Reporting Services

SSRS 2008R2 Data set Properties Error - I have a stored procedure which i have to design the report for this i have connected to the datasource...

SSRS 2008R2 GROUPING - I have add multiple goups in ssrs 2008 r2.My problem is when i try to add a group 1 extra...

Data Warehousing : Analysis Services

MDX and VB FUNCTIONS --- - Hi to all. I write this topic because i need an help about MDX and how to use VB Functions to...

Simple MDX query - Hi, I'm trying to something that I think should be straight forward in MDX but i'm struggling. I'm new to MDX...

Article Discussions by Author : Discuss Content Posted by Michael Coles

Java & SSRS - I am trying to implement bar codes in Java application. Also want to integrate with SSRS reports, how to achieve...