In this issue

Featured Contents

Editorial

Featured Script

 
 advertisement
 
SQL Toolbelt Want to work faster with SQL Server?
If you want to work faster try out the SQL Toolbelt. "The SQL Toolbelt provides tools that database developers as well as DBAs should not live without." William Van Orden. Download the SQL Toolbelt here.
 
SQL Monitor Custom metrics from SQL Server MVPs
SQL Monitor is the only tool with a free library of custom metrics from SQL Server MVPs. Find new metrics for your servers
 
SQL Compare Compare and sync databases with SQL Compare
“SQL Compare is fast, extremely easy to use, full-featured and affordable. I wouldn't bother messing around with anything else.” Adam Machanic, SQL Server MVP. Download a 14-day free trial.

In This Issue

Parallel Processing Using Jobs

Simple way to run uniform tasks in parallel using self-deleting jobs. More »


SQL Saturday #209 - Rochester

A free day of SQL Server training in upstate New York. More »


SQL Server 2012 Integration Services - Using PowerShell to Configure Package Execution Parameters

Marcin Policht explores some of PowerShell's SSIS-specific automation capabilities by demonstrating the process of configuring an already deployed package in order to carry out a parameterized package execution. More »


From the SQLServerCentral Blogs - Restoring Azure SQL Database to a Local Server

In last week’s post, I talked about the steps required to backup a Azure SQL Database.  That post leaves us... More »


Editorial - Factivism

I believe that we should all give back to the world outside of our families at some point in our lives. This might not be the time for you, and you might not have a cause right now. However I think at some point performing volunteer work to better the world will give each of a deep sense of purpose in our lives. I was reminded of this recently while watching a talk from Bono, on the state of hunger and poverty in the world. Bono has devoted considerable personal energy and resources in working with one.org to fight extreme poverty around the world. This may or may not be your cause, but it was an interesting talk, one worth watching.

The presentation wasn't what I expected, with Bono embracing his "inner nerd", as he put it. He talks not only about the state of his cause, but he uses data to present his case and inspire people to continue to work to make things better around the world. The term he used was not activism, but factivism. This is the idea of using facts and knowledge to further a cause. Whether you agree with Bono's vision, his case, or his goal, the idea of using data to make changes is something most of us embrace as data professionals.

The idea of using more data, more information to make decisions is something most of us do each day. However we don't have to limit ourselves to just the data and knowledge we have at work. I find many people looking to showcase their skills or improve their brand. This might be a way in which you choose to do this. With the availability of data from governments and organizations, you can present your own data analysis, or even a visualization that shows how you work with a set of data. It's the chance to make your own mark on the world, perhaps making the world better, or perhaps disputing the claims of others. Having data freely available allows us to check and verify someone's work or dispute their conclusions. Both of which are important for a healthy debate.

However you might tackle some data interpretation, you don't need to make a political or social statement. You could just provide a story on how you examine the data, perhaps learning along the way. By showcasing your knowledge of data in some way, perhaps even explaining how to load the data, you get experience and practice in both a technical area, as well as in communicating your knowledge to others. If you choose to do so in pursuit of a cause, perhaps the world may be a little better for your efforts.

» 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.

Everyday Jones

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


Question of the Day

Today's Question:

Which of the following hints require the word WITH?  (choose 3) Assume SQL Server 2012.

  • ROWLOCK
  • NOLOCK
  • FORCESCAN
  • FORCESEEK
  • XLOCK

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.


Yesterday's Question of the Day

---Statement 1
CREATE TABLE table1
(
ID int PRIMARY KEY,
Name varchar(20) 
CONSTRAINT UN_Name UNIQUE(Name)
);
--Statement 2
CREATE TABLE table2
(
 ID int PRIMARY KEY,
 PersonName varchar(10) REFERENCES table1(Name)
);
What will be the output of both queries?

Answer: The first statement will execute successfully and the second statement will throw an error

Explanation: Columns participating in a foreign key relationship must be defined with the same length and scale, otherwise the compiler will throw the error:

Column 'table1.Name' is not the same length or scale as referencing column 'table2.PersonName' in foreign key 'FK__table2__PersonNa__2F10007B'. 

Ref: http://msdn.microsoft.com/en-in/library/ms189862(v=sql.105).aspx

» Discuss this question and answer on the forums


Featured Script

Script to find username and corresponding loginname for all user DB

Script to find username and corresponding loginname for all user database in SQL Server 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

What is 'available physical memory' in DBCC MEMORYUSAGE - Hi, Am new to SQL Server. Am trying to query the total memory in the system that runs the SQL...

Access Control of SQL Login - Dear, I have created several logins such as ACC, SALES, HR, DIST, ADT and IT. Now I want that the respective...

Sorting Rows - [size="1"]Dear, I have a product table containing columns ProdID, ProdName and ... The data type of [b]ProdID[/b] is [b]varchar(10)[/b]. It contains data...

SQL Server 2005 : SS2K5 Replication

View Synchronization Status Error - Hi Experts I have added a new publisher to my Publication database but the process is just looping and in...

Removing a corrupted merge subscription... - Hello to all, Thanks for all your time and assistence and any input is greatly appreciated. I currently have a server that...

SQL Server 2005 : T-SQL (SS2K5)

SQL Report formatting with UNION Clause - I have an sql like this: SELECT 1 AS GROUPID, 'A' AS GROUPNAME, ''GROUPID, ''GROUPNAME UNION SELECT 2 AS GROUPID, 'D' AS GROUPNAME,...

DBCC Shrinkfile issues - First of all, I know I shouldn't do a shrink file because it causes fragmentation. however, I am working with...

SQL Server 2008 : SQL Server 2008 - General

Using MERGE tsql for FACT loading - Hi All, I m using the below tsql MERGE statement for loading data to one of the fact table in DWH...

Inserts are slow - I have a stored procedure that requires reading transactions one by one and then creating a few inserts per transaction....

Rebuild or DBREINDEX - Hi I have a table with a clustered index and 6 non clustered indexes.The size of the table is 400G...

Resizing the log file in Simple recovery mode - Hi - A brief description of the problem and how it came to be..... We have a nightly data load into a...

Exclude Specific Index From Query - This is driving me crazy! I want to exclude a specific index from a query but I can not remember...

Reg:History of maintenance plan - Hi, i went to maintenance plan s and want to view the history of that plan. when i opened the...

Renaming system databases - Can I rename the physical name of both mdf and ldf files of system databases such as msdb,model and master?

concerns using linked server -security. - We are designing of an application that using backend SQL database. When records are inserted into a SQL table, we...

Result of dynamic sql with parameteres into a variable - Edit 25.4.2013::: Problem was solved, but I have question about view, my last reply... thx for response //////// Hello, i have problem with...

SQL Server 2008 : T-SQL (SS2K8)

get max - CREATE TABLE [dbo].[Table_A]( [id] [smallint] NULL, [name] [varchar](50) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Table_B]( [ID] [smallint] NULL, [DATE] [date] NULL, [ORDER] [varchar](50) NULL ) ON [PRIMARY] GO INSERT INTO...

Table variable is not automatically dropped in TempDB - hi, I have created procedure like . USE [master] GO /****** Object: StoredProcedure [dbo].[b] Script Date: 04/28/2013 01:09:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc...

output understanding for most memory reads? - Hi.. Top procedures memory consumption per execution as below capture script [code="sql"]SELECT TOP 100 * FROM ( SELECT DatabaseName = DB_NAME(qt.dbid) ,ObjectName = OBJECT_SCHEMA_NAME(qt.objectid,dbid) + '.' + OBJECT_NAME(qt.objectid, qt.dbid) ...

SQL Server 2008 : SQL Server Newbies

Troubleshooting Web Application Performance - Hello, One of my clients has a few web applications using SQL Server as a backend. One of those applications...

deletion of db taking long time - Dear All I was doing bcpin with 20 million records. I stoped it in between. Then tries to delete the table...

Selecting/Deleting rows with the same column information - I need to delete some rows from our system that have the same transaction id based on an accounting date....

How to merge two sql select statement results I tried it but it not get please see it in detailed explination with my query - Hi All, My Query Goes Like This, Select TT.ID,TT.NAME,ROUND((CAST((Sum(TJA.MINS)) as FLOAT)/60),0) AS HOURS From MYTABLE1 as TT INNER JOIN MYTABLE2 as TB On...

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

How to link Main dashboard to other dashboards via a dropdown list - Hello, I have created a Main dashboard using SSRS. It consists of a report with graphs etc called Dashboard.rdl I have...

Database Design : Design Ideas and Questions

NoSQL and Attribute Value Pairs - Any suggestions? - Hi All I'm not really sure this is the right sub forum but since the question is sort of design related...

Data Warehousing : Strategies and Ideas

Geography Dimension - I am currently working on a warehouse project that includes a dimension for geography. It includes Zip Code, City and...