In this issue

Featured Contents

Editorial

Featured Script

 
 advertisement
 
SQL Compare Wish you had more contingency time?
Save hours deploying database schema changes with SQL Compare. "I could do the job by hand in hours, or use SQL Compare in seconds." Tim Kummer. Download SQL Compare now.
 
SQl Storage Compress Compress live data by 73% 
Red Gate's SQL Storage Compress reduces the size of live SQL Server databases, saving you disk space and storage costs. Learn more.
 
SQL Connect Does your database ever get out of sync?
SQL Connect is a Visual Studio add-in that brings your databases into your solution. It then makes it easy to keep your database in sync, and commit to your existing source control system. Find out more.

In This Issue

Using the Konesans File Watcher Task in SSIS to Process Data Files

With the Konesans File Watcher Task for SSIS we can import files as soon as they arrive. More »


SQL Saturday #156 - Providence, RI

Come visit Rhode Island and meet fellow SQL Server professionals from all over New England as SQL Saturday comes on Sept 15, 2012. More »


Using DELETE CASCADE Option for Foreign Keys

Referential integrity is a very important thing to consider when designing a database. In my years as a DBA I've seen database designs that sit on both ends of the spectrum, none at all and cases where every table is linked to multiple tables. While the later certainly can be a little more difficult to work with it ensures the integrity of your data stays intact. The other end provides much more flexibility when it comes to updating and deleting data from your database, whether it's being done through the application or directly on the backend, but has the issue of possible orphan records if things are not done properly. This tip will look at the DELETE CASCADE option when creating foreign key constraints and how it helps keep the referential integrity of your database intact. More »


Tell Us What You Think

Red Gate needs your help! Fill in our quick survey to help us improve our products – as a thank-you, you'll have the chance to win a Kindle Touch. More »


Editorial - No Limits

We've had Amazon Web Services (AWS) available for some time, and used for some interesting projects that wouldn't be possible if groups had to purchase their own equipment. From password cracking to cancer research, there are some amazing possibilities. Windows Azure works as well, and there are customers such as banks, using the cloud to perform complex analysis of data. Not to be left out, Google announced recently they were provide their Google Compute Engine to anyone, without any limits on scale. You have to pay for it, but if you want 770,000 cores to solve a problem, they'll provide them if you can pay for the resources. It's US$2m/day, but it's there.

I don't know what that means for us as data professionals, but I suspect there will be any number of companies that will consider using these types of resources to work on complex analysis of problems. Running a simulation might be something that costs a few hundred dollars a day, using resources for minutes at a time. Looking over some of the different projects people have used cloud computing engines for, it seems that many businesses might find this to be a cost effective way to perform data mining or BI type workloads.

If you can get the data to the engine. I still wonder how challenging this is, apart from all the security concerns. Just moving that much data around, refreshing it, removing the stale data, could be very complex. It concerns me that as more people attempt this type of work, we will have more and more poor decisions made because of data quality, age, or accuracy. After all, garbage in, garbage out has been a tenet of data professionals for decades.

If you're using cloud resources for computation, I'd love to know about it. I know many of the data professionals out there have reservations, and that's healthy. It shouldn't blind you to the possibilities that this is a most cost effective way of actually getting analysis and answers for your users.

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

What is the output of the following statement:

SELECT DATEADD(s,0,0)

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.

Delivering Business Intelligence with Microsoft SQL Server 2012

Equip your organization for informed, timely decision making using the expert tips and best practices in this practical guide. Delivering Business Intelligence with Microsoft SQL Server 2012, Third Edition explains how to effectively develop, customize, and distribute meaningful information to users enterprise-wide. Learn how to build data marts and create BI Semantic Models, work with the MDX and DAX languages, and share insights using Microsoft client tools. Data mining and forecasting are also covered in this comprehensive resource.

Get your copy from Amazon today.


Yesterday's Question of the Day

Which of the following is true about the maximum database size in the SQL Server Express editions? Tick both correct answers.

Answer:

  • There maximum database size in SQL Server 2005 Express and SQL Server 2008 Express is 4GB.
  • There maximum database size in SQL Server 2005 Express and SQL Server 2008 Express R2 is 4GB and 10GB respectively.

Explanation: Answers: There maximum database size in SQL server 2005 Express and SQL server 2008 Express is 4 gig. There maximum database size in SQL server 2005 Express and SQL server 2008 Express R2 is 4 gig and 10 gig respectively. Database size for the express engine increased to 10 gig for SQL server Express R2.

Ref: http://blogs.msdn.com/b/sqlexpress/archive/2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx

» Discuss this question and answer on the forums

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.


Featured Script

List of objects from particular schemas

This helps to get list of all objects in a particular schemas. 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

NEED to Reduce the space from the Drive in which Transactional log backups generates for every 10 mins - NEED to Reduce the space from the Drive in which Transactional log backups generates for every 10 mins in Tlbackup...

SQL Server 2005 : Backups

One restore or many, many restores - So, let me first preface this by saying, I've been a SQL Server DBA for 13 years. I've performed some...

SQL Server 2005 : Business Intelligence

SSIS package change source from Oracle 9i to Oracle 11g - ORA-12154 error - I am trying to change our source database Oracle 9i to new database 11g. I pass the credentials through configuration...

SQL Server 2005 : Development

Pivot query - I have the following data... [code] uid fieldid vaue 1172 5000 1172 5001 Development,support,management 1172 5002 1172 5003 Other 1172 5004 Computing 1172 5004 Medical 1172 5005 Networking 1172 5005 Consulting Projects 1172 5006 Chicago 1172 5009 [/code] The following code... [code] select userid, [5001] as...

SQL Server 2005 : SQL Server 2005 Integration Services

HOW TO READ A ZIP FILE WITH THE SAME NAME FROM MULTIPLE FOLDERS AND UNZIP THEM - Hi, Iam relatively new to bids.Following is the scenario where i need help. c:\archive has 3 sub folders c:\archive\1 c:\archive\2 c:\archive\3 1 ,2,...

SQL Server 2005 : T-SQL (SS2K5)

SELECT - CASE - GROUP BY - Hi I am new to this forum, so hopefully im in the right place and thank you in advance. Overview: An error...

Inserting data in one table as selecting from other tables - Hi all! I have a simple question. I've made a simple database in Access and upsized it in my SQL Server...

SQL Server 2008 : SQL Server 2008 - General

Comma Field Parsing - Two questions. #1 How can I select without using the LIKE? #2 How can I get this type of output? Thanks 101 1 101 2 101...

SQL Tool that integrates into Notepad++ - I found a tool a year or so ago that integrated with Notepad++ and allowed the user to run queries...

compressing 3 distinct records to 1 - I'm not even sure how to ask this question so don't know how to search for this in this forum,...

sql server max_lenght returns double the actual size - Hi all, I am retrieving column properties of a table with the following query [code="sql"] select c.name as ColumnName, type_name(c.system_type_id) as ColumnType, c.is_nullable...

Interview Logic Question - LOGIC PROBLEM -- There are three boxes. One labeled “Nickels” another “Quarters” another “Nickels and Quarters”. They are all mislabeled. How...

How to write this SQL ? - I can't figure this out, Please help... SQL Problem -- We have a table of orders. CREATE TABLE Orders (ordernumber INT, rownumber...

SUM with condition in query - How is this type of query written? Id, SUM(Cost) SUM(Cost) WHERE Code = 0 COUNT(*) COUNT(*) WHERE Code = 0 (SUM(Cost) WHERE Code = 0) / COUNT(*) (COUNT(*) WHERE Code...

Stored Procedure with a loop or something? - I need to make a stored procedure that looks at table 1 and if there is a row set that...

Sql Server Database is not responding in random manner - Hello everyone, I've created a database in MS-SQL and used it in my application. But sometimes it doesn't responds randomly and throws...

Getting errors when using linked server queries in SSIS packages - Hi All, I am trying to use linked server queries in my SSIS packages and getting the following errors: Description: SSIS Error...

How to shrink the log file? - Hello! I have a database with 29 GB log file on the FULL recovery modell. I want to shrink the log file,...

SQL Server 2008 : T-SQL (SS2K8)

UPDATE when the values are the same - Does an UPDATE query overwrite existing values if the already existing value is the same as the one your updating...

Using data set to pivot table - Ii have an urgent problem and I am thankful for any help. I do a query based on user-selected parameters and...

comma in SQL - I just found out we have a sql script to create a table. CREATE TABLE [dbo].[DayList]( [DateID] [int] NOT NULL, [EnrDate] [int] NOT...

unique constraint - I have a new table. The unique value is PersonID+lateDate, it can be used as primary key. But we would like...

SQL Server 2008 : Working with Oracle

DB-Link SQL Server to Oracle OpenQuery Retuns a single row - Hi, I'm having an issue with getting openquery to work correctly. Im Using: SQL server 2008 connecting to Oracle 11g. Microsoft OLE...

BIT datatype and Oracle - Hi, As per the business requirement, any SQL script that I make should follow ANSI standard, so that it should successfully...

SQL Server 2008 : SQL Server Newbies

Deleting temporary table from asp.net VB - I created a query to pivot some data as below. And that works fine. But I delete the temp table...

Split one row into two rows using CTE?? - Dear All, thanks for help me from my previous problem. Now i have the second problem. I've search in this forum,...

Just starting first job - SSIS & SSAS - I graduated recently from college and will by starting my first job in Business Intelligence in October. I'm currently going through...

SQL Server - GROUP BY clause - SQL Server - GROUP BY clause Hi there, I need your help. Here is my problem. I tried this query in dbms SQL Server...

Landing The First SQL Job.... - Hello All! I currently am a plumber by trade, been in that industry courtesy of my father in law since graduating...

SQL Server 2008 : SQL Server 2008 High Availability

unable to reconfigure mirroring - We are seeing the following error message when we are trying to reconfigure mirroring. We backed up the principal database,...

SQL Server 2008 : SQL Server 2008 Administration

Control_M for SSIS - Anyone here in this forum use Control-m software to excute SQl agent jobs? We currently use SQL agent to run SSIS...

what is the Best way to run huge script on production server ? - what is the Best way to run huge script on production server ? (code drops) The script has several alter procedures to...

Index Fragmentation and Performance - Hi All I understand that External Fragmentation exists when the Index pages are not in a logical order for SQL Server...

SQLServerCentral.com : Anything that is NOT about SQL!

Fiction aping reality? - I was watching the Mars landing yesterday morning (and boy was it tense) when I noticed one of the scientists...

Talking baseball - Okay, a topic that has NOTHING to do with SQL . . . Came across [url=http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx]this link[/url] describing the SSC point scoring descriptions,...

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

Article Discussions by Author : Discuss content posted by Divya Agrawal

Kindly solve this querry urgent - there is table suppose temp table, in this table there are 2 colume i.e name and value there are record like: name...