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

Better, Faster, and Cheaper

Today we have a guest editorial as Steve is out on vacation.

You’ve probably all heard the mantra of “good, fast, or cheap – pick two”. It’s sometimes called the project management triangle or the iron triangle. It’s a saying used to force clients to make decisions (tradeoffs) and it works on managers too. It works because it’s a great visual, who can argue with it? Yet, for reasons that possibly defy common sense, it’s a saying that I’ve never quite believed in it. Do you?

Even if you do, I challenge you to stop and re-think it.

I was talking with a friend yesterday who had purchased a 15” laptop with a 1TB drive, 16g of memory, I7 processor, for about $800. Isn’t that better, faster, and cheaper than most anything you could have bought five years ago? Imagine the one before was not quite as good, not quite as fast (yes, maybe not the kind of fast we mean here) and cost $1000. The design team was told to build something better, faster, and cheaper. Did they do it? Where did they not do it?

Does the triangle only apply to new products and new problems rather than iteratively evolving ones? Does it only apply to work we do in IT (or perhaps don’t want to do)? Does the triangle perhaps only apply to average teams? What happens if you have a superstar – could they possibly do it better, faster, and cheaper?

My goal here isn’t to suggest miracles are always possible. Hard problems take time. Building quality solutions and testing them takes more time than coding a hack, and if nothing else, time almost always equates to more cost in our world. No, what I’m challenging you to do is to avoid reducing conversations to “pick two” when sometimes the right person with the right idea might well be able to see a way to achieve all three.

Andy Warren from SQLServerCentral.com

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

ADVERTISEMENT

8 Steps to Effective
SQL Server Monitoring

Discovery

Auditing

Backups

Capacity

Memory

Errors

Tuning

Evaluation

Pick up your free guide to effective SQL Server monitoring

Featured Contents

 

Index Utilization Tending

Edward Pollack from SQLServerCentral.com

An important part of regular database maintenance is to monitor index usage and make adjustments as needed. How can we monitor, store, and trend this data effectively over time? More »


 

Write for SQLServerCentral

Site Owners from SQLServerCentral.com

We are looking for new content here for the site, based on your experiences in the real world. Submit something and get yourself published. More »


 

SQL Server Reporting Services Basics: Building SSRS Reports

Additional Articles from SimpleTalk

Kathi Kellenberger describes the basics of SSRS before showing you how to build quick, simple reports. More »


 

From the SQLServerCentral Blogs - Where are my 32-bit Perfmon Counters?

@DBA_ANDY from SQLServerCentral Blogs

I have run into this before, but not in this same way, so I decided it would be worth writing... More »


 

From the SQLServerCentral Blogs - SSMS Add-ons

David Postlethwaite from SQLServerCentral Blogs

At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on... More »

Question of the Day

Today's Question (by Mounika Parsi):

Assume you have a table "Transactions" in the database "Test". The table "Transactions" has CDC enabled on it. Now we shall create a DDL Trigger on DROP_TABLE event. The trigger code is as follows:

USE Test
CREATE TRIGGER PreventDrop ON DATABASE
    FOR DROP_TABLE
AS
    BEGIN
        IF EXISTS ( SELECT *
                        FROM sys.tables
                        WHERE name = EVENTDATA().value('(/EVENT_INSTANCE/ObjectName)[1]',
                                                       'varchar(100)')
                            AND is_tracked_by_cdc = 1 )
            ROLLBACK
    END
What happens if you drop the table "Transactions" ?

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

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

Microsoft® SQL Server® 2012 Step by Step

Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

If you have the results of your query sent to a grid, how do you hide the results pane?

Answer: CTRL+R

Explanation:

The answer is CTRL+R. Clicking this key combination will toggle hiding and showing the results from a query if the results are being sent to a grid.

Ref: SSMS Keyboard Shortcuts - http://technet.microsoft.com/en-us/library/ms174205.aspx


» Discuss this question and answer on the forums

Featured Script

Find database where table is located

Trevor Makoni from SQLServerCentral.com

declare @TableName varchar(500) = 'partofmytablename';

exec master.dbo.proc_FindTable @TableName;

go

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

Upgrade from SQL 2008 R2 Dev to 2014 didn't go well. - I have SQL Server 2008 R2 Developer Edition installed on my development box. I purchased SQL Server 2014 Developer Edition...


SQL Server 2014 : Development - SQL Server 2014

Changed behavior or am I missing something? - Hi all, when porting and testing code from 2008/2012 to 2014 I noticed that some queries where significantly slower. Digging into...

Database and its Objects Naming Standards - I am trying to establish the standards for naming convention in my new project. Can you please provide me the...


SQL Server 2012 : SQL 2012 - General

Mercedes was not ready to the fact - Mercedes was not ready to the fact Almost all of this was about relationship insecurity in some way, in between Arties...

How to I add the SSC Addins to SSMS - I installed Red Gate's SQL Search and now I have an Add-ins icon. From the Icon I got to a...

Encrypting data from Oracle to MS SQL over WAN - I have been tasked to find a solution for Encrypting data being transferred from an Oracle database in one state...


SQL Server 2012 : SQL Server 2012 - T-SQL

complicated sql syntax - looking for explanation for working query - About six months ago, one of the regular SSC forum experts gave me this query to use to build a...

How to get Primary Key Value if not Present in Foreign Key via Join? - I've following query which display the result as required, but I need to get the missing Primary Key Values which...

Querying XML data - Hi I hope someone is able to help me with following query: [code="sql"] --LOAD TEST XML TO SQL SERVER XML COLUMN declare @xml table...

If I understand Views VS Functions correctly...I should use views to enapsulated commonly used where clauses? - Some background to my question. I am working with healthcare data and my datasource for Charges is one big transaction...


SQL Server 2008 : SQL Server 2008 - General

shrinklog fle - how to shrink the logfile of the database who is configured in replication?

Large database migration best practices - We are planning to move 3-4TB of databases to new environment. Can someone explain some best practices. What should we...

where can I query the 'Enable Mail Profile' value from the Agent properties - Hi All, I'm looking to query (via SQL) the 'Enable Mail Profile' value from the Agent properties, but I've been unable...

Backup questions for 612GB database! - We have a database that is over 612Gb and growing. Our backup is being done on tape using Backup Exec...

Error installing MS SQL Server R2 Enterprise (x64) - Hi Everyone, Recently I attempted to upgrade from MS SQL Server to MS SQL Server R2. However I have encountered an error,...

Perfomance due to foreign key - I have a table with primari key. which is refrenced across 63 columns in 40 + tables Now when i tried to...


SQL Server 2008 : T-SQL (SS2K8)

problem in logic for finding a Recursive Cte - hi, hope everybody doing good, here is my problem this is my data [code] DECLARE @Tbl AS TABLE (Mainid INT, Referenceid INT) INSERT INTO...

Query XML data for blsnkd - Hi I am try to see if there are any blanks in a node of a table that has xml...

Store result of stored procedure into a xml/nvarchar(max) variable - I have a stored procedure that returns XML using FOR XML Explicit. I need to use the output of this...


SQL Server 2008 : SQL Server Newbies

How to copy chart from excel sheet to another excel sheet ? - Hello, I have a task, that should copy chart from sheet to another excel sheet. Can anyone help me. i want to...

Help a complete noob with a project - Hello everyone, i have a project for a datawarehousing class and could really use some help in this. Heres what i...


SQL Server 2008 : SQL Server 2008 Administration

VOS3000 PRICE : VOS3000 RENT : VOS3000 SALE : VOS3000 SERVER : VOS3000 SOFTSWITCH : VOS3000 TUTORIAL : VOS3000 VIDEO TRAINING : VOS3000 WHOLESALE SWITCH : VOS3000 : VOS SERVER : VSR : WHAT IS VOS : VOS3000 2132 : VOS3000 2126 : VOS3000 2124 : VOS3000 2120 : VOS3000 2118 : VOS3000 2115 : VOS3000 - [b]"Hello VOIP Service Provider, We Provide ORIGINAL/LICENSE VOS3000 WITH ASR & LCR Based Routing, Unlimited Reseller Level and More Billing Reports! ..:: SPECIAL...


SQL Server 2008 : SQL Server 2008 Performance Tuning

Joining on views in queries instead of tables - I’m working on a legacy DB and I notice that several of the procedures do joins on views. Some of...


SQL Server 2005 : SQL Server 2005 Integration Services

Which would be faster, an SSIS Foreach or SQL Cursor for 6300 rows? - I'm currently re-writing an inherited C#/SQL CSV import process due to speed issues with the previous process (reading each line...

how to load oracle database data to sql server with the help of SSIS - how to load oracle database data to sql server with the help of SSIS


Reporting Services : Reporting Services

SSRS 2012 - corrupt export to excel - Hi all, we have recently deployed a 2012 SSRS server, and one of the first systems to go on it, requires...


Data Warehousing : Integration Services

How to Create custom error log - Hi All, I am new to ssis ,i want to send customized email notification in the below scenario i am uploading an...


SQLServerCentral.com : Anything that is NOT about SQL!

First SQl job were you nervous? - I currently work in a health clinic as a Clinical Applictions Specialist. I do the training, configuring workflows and as...


SQLServerCentral.com : Articles Requested

Is an Index Being Used? - I am looking for a short piece that queries the DMVs to show which indexes are being used by your...

Deploy to Test - How do you deploy your code changes to test from development? Give us the process and an example.

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 ©2014 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com