SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

Featured Script

The Voice of the DBA

Is Your Data Relational?

When should you use MongoDB? I've asked that question a few times, and I haven't gotten a good answer I understand. I've read about a few of the NoSQL, document databases, and I think they do have a place in the world. There are domains of problems that they solve better than relational databases. I'm sure that streaming databases, graph databases, columnar databases, and more have places where we they shine, but I still believe that many, perhaps most, problems are best solved by relational databases.

I saw this piece about MongoDB being a poor choice by the Diaspora developers because they hadn't modeled their data well. It's a decent analysis of a real situation, and I think it's one that has probably been repeated many times by many developers that were intimidated, frustrated, or otherwise turned off by relational platforms.

There is a cost to using a relational platform, and it can require expensive developer time to map objects to relational structures. However the solution isn't to abandon the relational platform. The better solution is likely to train developers and hire a few DBAs that can help with the mapping and queries to solve problems.

Steve Jones from SQLServerCentral.com

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


Video and Audio versions

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.

Follow Steve Jones on Twitter to find links and database related items and announcements.

Steve Jones

Windows Media Video ( 14.6MB) feed

MP4 iPod Video ( 16.9MB) feed

MP3 Audio ( 3.6MB) feed

Feeds are available at iTunes and Mevio

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

ADVERTISEMENT
SQL DBA Bundle

Save 45% on our top SQL Server database administration tools.

Together they make up the SQL DBA Bundle, which supports your core tasks and helps your day run smoothly. Download a free trial now.

SQL Search

How do you search your database schema?

"I use SQL Search regularly and think it's great." Gregor Suttie, Senior Software Engineer, Pulsion Technology. Download Red Gate SQL Search while it's free.

SQL Monitor Hosted

New! SQL Monitor Hosted

Start monitoring your SQL Servers in under 5 minutes. Get clear insights into server performance, whilst we manage the monitoring software. Find out more.

Featured Contents

 

High-Performance Transact-SQL with Window Functions

Kamil Moscicki from SQLServerCentral.com

Window functions are more intuitive and simpler in many cases than alternative SQL methods. More »


 

Getting Ready for Big Data: Prepping the Data Warehouse

Additional Articles from Database Journal

Big Data implementations bring their own problems and issues, and will require database administrators and support staff to redesign the data warehouse architecture. Here's how. More »

Question of the Day

Today's Question (by Steve Jacobs):

Given you have the following table:

create table #temp1
(
i int identity(1,1),
a numeric(8,2)
)

Your values in this table are
1,11
2,42
3,31
4,NULL
5,10
6,10.5

What can be added to order column 'a' in ASC order (Select all that can be applied)? 

Assumptions:

  1. column 'a' will allow duplicates.
  2. A select statement is used to return values (Select a from #temp1)

(Please choose 4)

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


We keep track of your score to give you bragging rights against your peers.
This question is worth 2 points in this category: T-SQL.

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

ADVERTISEMENT

SQL Server 2012 AlwaysOn Joes 2 Pros®: A Tutorial for Implementing High Availability and Disaster Recovery using AlwaysOn Availability Groups

SQL Server 2012 brought in some great new features and one of the important ones is scalability and performance via AlwaysOn. AlwaysOn is a superset feature and is a combination of many things you will learn about. As the language suggests, this technology achieves a SQL Server infrastructure that can be "always on". For businesses that run 24x7 downtime means the loss of business. This type of risk is out of the question for these businesses. This book discusses in detail the concepts of SQL Server AlwaysOn starting from the basics.

 

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

If I wanted to avoid matching a character, which wildcard would I use inside the square brackets? 

Answer: ^

Explanation:

The caret (^) is the wildcard that will avoid matching a single character. A couple examples: 

WITH    myCTE ( mychar )
          AS ( SELECT 'Steve'
               UNION ALL
               SELECT 'Andy'
               UNION ALL
               SELECT 'Adam'
               UNION ALL
               SELECT 'Bdam'
               UNION ALL
               SELECT 'Pteve'
               UNION ALL
               SELECT 'Billy'
             )
    SELECT mychar
        FROM myCTE
        WHERE mychar LIKE '[^a]dam';

WITH   myCTE ( mychar )
          AS ( SELECT 'Steve'
               UNION ALL
               SELECT 'Andy'
               UNION ALL
               SELECT 'Adam'
               UNION ALL
               SELECT 'Bdam'
               UNION ALL
               SELECT 'Pteve'
               UNION ALL
               SELECT 'Billy'
             )
    SELECT mychar
        FROM myCTE
        WHERE mychar LIKE '[^a-r]teve';

» Discuss this question and answer on the forums

Featured Script

Generate Trigger DDL

David Kranes from SQLServerCentral.com

Use this script to generate individual .sql files for each trigger in your database.

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 2014 : Development - SQL Server 2014

Query performance - Some of developers have made modifications to database structure like indexes and later observed that the performance of queries have...


SQL Server 2012 : SQL 2012 - General

SSRS Time Calculations/Query - Hi I'm working on a report in SSRS. I have a dataset that uses query 1 below and works fine....

what is the sql server edition for trial download - Hi, what is the sql server edition for trial download? at http://www.microsoft.com/en-us/sqlserver/get-sql-server/try-it.aspx#tab2 because different edition of sql server will different os requirements according...

Cannot restore database. Cannot get exclusive accesss - While restoring database in sql server 2012, i am getting the following error in sql server 2012 "Exclusive access could not...


SQL Server 2012 : SQL Server 2012 - T-SQL

Question About Trapping Attempt to Insert Duplicate Record in Stored Procedure - I have the following stored procedure (shown at the bottom of this posting). It attempts to do a simple insertion...

How can I use MAX() function in another DataBAse? - Hello I want to use max() function and I want to read the input of this function from another database(its name...


SQL Server 2008 : SQL Server 2008 - General

Need your help...SQL Developer interview questions..pls - Hi All, I am working in a small company having 2 years of experience .. But I am into Production Support..I am...

SSRS Time Calculations/Query - Hi I'm working on a report in SSRS. I have a dataset that uses query 1 below and works fine....

RCSI - Read Committed Snapshot Isolation - Hi, Our ERP is very badly design... We have long running transactions that block simple SELECT.. If I activate the RCSI on...

Need to fill the Gaps with previous value - Hi experts, I have a scenario to fill in the GAPS between the dates with previousdate+1 day. here is the table DDL...


SQL Server 2008 : T-SQL (SS2K8)

Identify Duplicate Records according to Multiple Criteria - Hi There! I have an Employee table with Columns: EmpID | FirstName | MiddleName | LastName | SSN | BirthDate | HireDate | City | Zip [b]Requirement:[/b] I have to identify...


SQL Server 2008 : SQL Server Newbies

Check Data exists or not - HI all, I have a scenario in which I have to transfer the data from tableA to tableB. But before inserting in...


SQL Server 2008 : Security (SS2K8)

Antivirus on large SQL Server instances - All, I'm having an issue where my current antivirus vendor is having issues when scanning my larger sql server machines....


SQL Server 2008 : SQL Server 2008 High Availability

Transactional Replication with growing commands and transactions - I have setup transactional replication at a customer site with SQL 2008 R1 SP1 Enterprise Edition residing on Windows 2008...


SQL Server 2008 : SQL Server 2008 Administration

server automatic restart - We have a windows 2008 server sp2 that hosts a SQl server 2008. Recently the server has an automatically restart at...


SQL Server 2005 : Administering

RESTORE Problem in log shipping - Hi All, I have restore Problem in Log Shipping, the copy job succeed but when i see the restore job status...


SQL Server 2005 : Business Intelligence

My Slow Changing Dimension Transform is NOT WORKING - I used the following from a CSV to test the SCD. I thought it would recognize the LocationIDs and update...


Reporting Services : Reporting Services 2008 Development

SSRS 2008 r2 pass paramater values from report to report - In a SSRS 2008 r2 dashboard, the user can click on various links to jump to various ssrs reports that...

ssrs 2008 r2 export to excel on report server problem - In an SSRS 2008 R2 report, I have the following expression on the 'Hidden' property on the Tablixes where I do...

ssrs 2008 r2 c hange server name location - In a new SSRS 2008 r2 report, I am using the 'action' option to point to a url. When the...


Programming : XML

updating rows with xml - Hi, I have a loop built which selects groups of records out based on different product groups. The results are returned as...


Data Warehousing : Integration Services

Easy Question: Organizing Data Flows - Since I'm new to this and data warehousing, I'm not sure what is the best way to do what I'm...


Data Warehousing : Analysis Services

MDX to exclude and filter sets - For several days, I've been trying to write mdx select correctly, but the result I get every time is either...


SQLServerCentral.com : Anything that is NOT about SQL!

Fantasy football 2013 - I renewed the league, you should be getting an email soon. At the moment, there are no open spots, but...

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

This email has been sent to {user_email}. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2013 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com