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

The Agile Cult

This editorial was originally published on Sept 23, 2008. It is being re-run as Steve is on vacation.

Can developers change the way they build things? Can corporations?

I'd like to think so. After all there are companies and developers that get more efficient as they evolve their development practices. I know that I've gotten better at building software over time, getting more efficient as I learn better ways to actually write code, keep track of changes, quickly build and test, etc. Or maybe it's that I'm more disciplined about working carefully and actually doing things like checking in and out of version control, writing better test cases, and actually following the plan I've setup.

The Capability Maturity Model (CMM) from Carnegie Mellon University that measures the ability of a software development group to better build software. Most software teams rank very low on their scale, requiring much effort to move up the model to a more mature style of development. I'm not sure of those groups at a CMM level or 4 or 5 produce better software than those at level 1, but I'd like to think that they do.

There was a blog post about Agile development, which is a method of software development that I think can help one build software in a quicker and more flexible manner. In the post, which is a look back at an attempt to build a project using this methodology. It didn’t work out, though they did complete the project on time.

It's an interesting read to see a nice self examination of how their culture actually failed them. They couldn't really build Agile software, mostly because of the culture at the company. Despite the desire to change and the buy-in of the technology team, many other factors ended up preventing them from really sticking to their Agile plan.

Well they completed their second project successfully, albeit with some overtime involved. They recognized that they hadn't used the Agile methods and they'd fallen into an Agile Cult instead. It seems the author was a little disappointed in the result, and perhaps in their inability to deliver with Agile methods.

Personally I think that even partially adopting Agile methods results in benefits. Just because you can't deliver incremental releases or change your focus quickly doesn’t mean there aren't benefits. Having a different mindset and trying new techniques can have a lot of benefits for your team. Just thinking about building software differently can let you re-think the way you do things, allowing you to be more self-critical and look for ways to be more efficient.

Constantly trying new methodologies might not sustain you for the long term, but trying different development methodologies can help you find the things that work best in your environment. Once you know what works well, you can then set about changing the culture to become a more efficient software development team.

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 ( 20MB) feed

MP4 iPod Video ( 18MB) feed

MP3 Audio ( 4MB) feed

Feeds are available at iTunes and Mevio

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

ADVERTISEMENT
SQL Backup Pro

New! SQL Backup Pro 7.4

Try out the latest version today for faster, smaller compressed backups on all editions of SQL Server. Download a free trial now.

SQL Prompt

Make working with SQL a breeze

SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

SQL DBA Bundle

‘10 Tips for Efficient Disaster Recovery’

Learn Steve Jones’ disaster recovery lessons, and be better prepared for future disasters, big or small. Read now.

Featured Contents

 

What’s going on, on my server, right now?

Kimberly Killian from SQLServerCentral.com

Quick and easy way to monitor server activity and be notified from alerts. More »


 

SQL Server Central Webinar Series #24: Prepare for When Disaster Strikes

Press Release from SQLServerCentral.com

Our next webinar on July 23rd has Steve Jones presenting on some disaster stories with ideas on how you might prevent, or mitigate the effects, of those problem situations. More »


 

Survey: Understanding SQL Code

Additional Articles from SQLServerCentral.com

Understanding thousands of lines of code of an existing database is very time-consuming and tedious, prone to inadvertent oversight of key logic points. We are looking at advanced ways to provide greater insight into your code base while reducing the numerous demands placed on the developer. Please help us by completing this short survey to help us define the requirements. More »


 

Are my actual worker threads exceeding the sp_configure 'max worker threads' value?

Additional Articles from MSDN Communities

Tom Stringer (@SQLife) was working on some HADR testing for a customer to simulate many availability groups and introduce significant load into the system to measure overhead and such. In his quest to do that he was seeing behavior that he couldn’t really explain and so worked with him to uncover what was happening under the covers. More »


 

From the SQLServerCentral Blogs - My Advice About Growing as an IT and Data Professional

First off, I should apologize for not blogging in quite a while. I’ve been traveling extensively and, because traveling can... More »

Question of the Day

Today's Question (by pramod singla):

Out of 4 statements namely 1,2,3,4,5, which of the statement/statements will execute successfully? (select 4)
if object_id('test2') is not null
 drop table test2
if object_id('test1') is not null
 drop table test1

create table test1 (a int not null primary key);
create table test2 (b int,a int  )
GO

--statement 1
insert into test1
 output inserted.a
 select 1
GO

--statement 2
create trigger trig_test1
 on test1 after insert
as
 select 2
GO

--statement 3
insert into test1
 select 3
GO

--statement 4
insert into test1
 output inserted.a
 select 4
GO

--statement 5
declare @temp as table (b int)

insert into test1
 output inserted.a
 into @temp
 select 5

select * from @temp
GO


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.

Did you miss yesterday's question, T-SQL? Answer now.

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

ADVERTISEMENT

SQL Server 2012 Integration Services Design Patterns

SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution. Get your copy from Amazon today.

Featured Script

Virtual tally table function

Steven Willis from SQLServerCentral.com

This iTVF will create a tally table of any size with user-defined lower and upper bounds. So if you want a tally table with 100,000 rows that starts at 250,001 and ends at 350,000, just enter the lower and upper bounds as parameters and the function does the rest. As written, it converts any negative number entered as a min parameter into zero. (A max parameter < 1 will generate an error.)
I ran a performance test on this function against a "physical" tally table with 10,000,000 rows using Jeff Moden's test methodology and test data generator. The testing code can be made available on request. This function performs as well or better than the physical tally table.
So if you have an application that requires an upper bound greater than the traditional 10-11,000 rows of the common tally table, or if you need to set a range of row numbers, this function will do that easily with no loss of efficiency.
I want to give credit to Jeff Moden for generating the concept through his articles and research on tally tables; credit to Dwain.c for his keen-eyed suggestions and tweaks; and of course to Brian Bates and his row-generating algorithm without which this function could not have evolved.
Steven Willis

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

Filegroups ClusteredIndex - Non-Clustered NDF - For performance sake. I have a server with drives D:, E:, & F:. I have a large table I want to...

Securty Trigger stroed procedure - Hi , I want to capturethe Audit Server Security Events , like if any one doing Create / Alter / Drop logins on server...

I have few doubts, SOMEONE PLZ ANSWER MY QUEESTIONS –Thanks in advanced. - Hi All 1. In mirroring If I add data file in primary server will it reflect in mirror server or not? If yes...

DB Free space issue - Hello, we have a vendor DB which always keeps around 3GB of free space. It is sql 2005 SP3 and DB Data...

sql server 2005 sp1 is slow - users experience slowness on the sql server 2005 sp1. Windows Server 2003 Standard Edition SP1 Physical RAM: 3.25 GB I set the...

databse file removed, still in metadata - MSSQL 2005 SP3 I have just noticed the following behaviour: removed a file from a database using dbcc shrinkfile(emptyfile) and alter database...

SQL Server 2005 : Backups

SQL doesn't see .bak file? - Sorry, this is probably a really dumb question, but when I go to do a restore in SSMS, when I...

point in time restore in bulk logged recovery mode - Hi Can some body please suggest that is bulk logged recovery mode database restored to pint in time is any situation..please...

SQL Server 2005 : Business Intelligence

Incremental Loading using sqlserver 2008 - I have a scenario where I have to calculate the incremental data ( insert,update and delete). The architecture is as follow: SSIS...

SQL Server 2005 : Development

how to trap dos errorlevel when sqlcmd execution timout ? - Hello, I test %ERRORLEVEL% in a .bat file who execute sqlcmd -b -l 1 -t 1 ... but sqlcmd exits with success...

SQL Server 2005 : SQL Server 2005 Integration Services

SSIS Logic - SSIS Package: 1) I am trying to get the value from a look up table into a @intial variable : example say...

SQL Job does not executes SSIS package but Job goes to executing state and don’t stop. - Hi, There is one SSIS package which is executed successfully when run from Visual Studio. When the package is executed through...

SSIS 2005 blank values problem - I am using a package to load data from a tab delimited flat file into SQL server table. For this purpose,...

SQL Server 7,2000 : Administration

what is PKM in SQl Server ? - what is PKM in SQl Server ? --snt

SQL Server 7,2000 : T-SQL

Continue control from rollback in trigger to procedure - Hi Dear, [code="sql"]CREATE TABLE TestTable ( ID INT, Name NVARCHAR(100) ) GO CREATE TRIGGER TestTable_Insert ON TestTable FOR INSERT AS DECLARE @ID INT SELECT @ID = [ID] FROM INSERTED IF @ID = 1 ROLLBACK TRANSACTION GO CREATE PROCEDURE p1 AS DECLARE...

SQL Server 7,2000 : SQL Server Agent

Error 14258: cannot perform this operation while SQL server agent is starting. Try again later. - Hello. I have a SQL 2000 SP4 that has this problem with the job since 15/07/2013. Look pretty and we...

SQL Server 2008 : SQL Server 2008 - General

Strange Error With Cursor - Hello, I have a cursor that I use to alter stored procedures to fix bugs that has always worked for me...

do I need to use case explicily - I have a database that imported some students' info from a text file. When importing into the raw table, the studentID...

Table partition sql 2008 partion key include on cluster index - Hi, I am new for table partition so please help me to choose right key for cluster index. example: Table (colA,colB,colc,.....) Colc : my partition...

what lock pages in memory option does. - Hi i want to know what lock pages in memory option does. i donot gets it wording " Windows not to swap...

between sql server and sql server agent - hi soory for stupid question but whats difference between sql server and sql server agent ??? arent both windows services .if...

Error converting data type varchar to numeric - Hi All, Im not the greatest at SQL but Im getting better. I do not understand why I get the following...

Looping through table - I am simply trying to look through a table select out email(recipient), and combing to columns into one(body and unique)...

Object cannot be renamed because the object participates in enforced dependencies. - Here is the senario... I have multiple copies of a table across several servers. The problem is that these sometimes...

SQL 2008 R2 Build 10.50.1790.0 - MS11-049 is this a windows update. I can get sql to 1777 build. Using cu packs. How do I use...

Help with temp table based on previous row value - [Edited to drastically simplify question] Please see attached. Thanks!

Order By trouble - Hi geniuses, I need to order some data and when Value = Null -> 'Not Defined'. Next I need the Value 'Not Defined'...

Create a view with a self populating column - Have a strange request from the apps folks. Here is what they want: We have three SQL Server databases with the...

Moving clustered indexes to new filegroup - I am rebuilding the clustered index of a table to a new filegroup using DROP EXISTING in order to move...

Execution Plan Changes With "TOP 1" And problem with the response time - Hi, I have a view like : [i] alter VIEW View_IdPERSON as select em.EMAIL_VALUE as liste_email ,e.PERSON_id as Liste_DMID ,ed.DATA_BIRTHDATE as Liste_DMDATENAISSANCE...

Date convertion - Hi, My table have a column with date format 'Jun 15 2010 12:00:00:000AM' But i need that column name with the format...

Log file - what is the difference between the database logfile and the database configured under replication ?

DATEADD Requirement - I have a requirement like... Add a week to the initial date provided till end of current month of initial...

No history of job execution in a particular instance - Hi, I have a job scheduled to run every 2 hours during the week. The job started to run at 1:15 PM...

SQL Server 2008 Replication. ½,¼,¾ (fraction signs) have stopped replicating properly in a varchar field. They are now getting corrupt. (e.g. 108¾ at publisher and 108ó at subscriber) - Re: SQL Server 2008 Replication. ½,¼,¾ (fraction signs) have stopped replicating properly in a varchar field. They are now getting corrupt....

MSDTC - what is MSDTC and the purpose in sql and is it necessary to have MSDTC on sql cluster ?

SQL erroring for windows authentification when mixed is selected - Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only....

Do you allow Entity Framework? / Database Security Permissions - I know this topic has been talked a lot but, i'm having this issue right now, the Developers team at...

Help with SQL query - Hello all, I am not sure whether this is the right thread to post this or not. Anyways, I have one...

SSIS package creation - Hi, I need to import data from Oracle table to SQL Server table using SSIS. I'm using data flow task with OLEDB...

MERGE statement - WHEN NOT MATCHED DELETE takes ages - I am using the MERGE functionality in SQL 2008. My code works fine. However if I clean the buffers I've noticed...

Need A Help in DATA MASKING in SQL SERVER 2008 - Hello Friends, I want to mask certain fields in employee_bank_account_info table, which are very sentive information. I searched for it , i found...

Ranking Based of Advert Breaks - Hi People, This is a tough one for me. Let me start by explaining what i want to do then posting...

SQL Server 2008 : T-SQL (SS2K8)

TSQL Business Rule Implementation Between Two Tables - Hello, I am writing a report in SSRS and at first thought I would implement these biz rules at the report...

search values in a temp table with like operator - Hi, I have a SQL proc with a search-parameter (given as coma separated values) which should return all data of...

[HELP] FOR XML - Hi All, I need use SQL (for xml) to write in this customize format of XML as below: <track_n_trace tranid="1234" ordernum="ABC123"> <current_location>MY</current_location> ...

Date Validations? - How To Validate a year, month,and date and totaldate?Year should be in yyyy format,month should be between 1 and 1...

Hi Please help to resolve this Problem: Advance Thanks for given Solution - Table1: Reportid | IdetityID(Pimary key) -------- | --------- 2 | 1 2 2 2 3 2 4 2 5 Table2: Reportid | IdetityID(Primary key) -------- | --------- 3 | 1 3 | 2 3 | 3 3 4 3 5 I want to insert above values in to Table3 leke below: Hear P

Unique Field - How to Retrieve A Field That is unique in two tables?

Substring takes 100%CPU - SELECT CASE WHEN substring(column_name, 1, 2) = '44' THEN column_name ELSE '44' + column_name END 'column_name', min(col2) 'date' FROM DBNAME..TABLENAME(nolock) WHERE col3...

IF ELSE Query - I have written an IF ELSE statement into a sproc but I'd like to display the results (as in counts)...

Select All Records from Temporary Table and Assign to VARCHAR? - Hello! I am new to TSQL and require some help with a problem I'm having. I have a stored procedure where...

previous week query 0700 - 0700 - HI all I have been asked to generate reports from my c# package I have created every Monday at 0700hrs,...

split a string - If I have a street address that I would like to split street from Apt number, how could I do...

SQL Server 2008 : SQL Server Newbies

Where to start - Hello, I'm hoping someone might be able to point me in a direction, even if its pointing me to a different...

Not your usual documentation question - I am a server/SQL admin in a large organization. We have thousands of SQL databases on many clusters and individual...

SQL Server 2008 : SQL Server 2008 High Availability

Restore user database within a SQLServer 2008 failover cluster - I am new to SQLServer2008 clustering , When I try to restore a database within the cluster , I get the message...

SQL Server 2008 : SQL Server 2008 Administration

Linked Server - Works Except With Insert Statement - I am trying to get Job information from ServerB, and populate a Table Variable on ServerA. From ServerA, I am...

Dumb question about data types - Using SSMS 2008 R2. This is driving me nuts. I have a table that has a LOT of foreign keys....

shared & Exculsive latches? - Hi, PAGEIOLATCH_SH --------------- wiat_time_S 175094.26 Pct 1.05 Running_Pct 96.99 PAGEIOLATCH_EX -------------- wiat_time_S 119320.6 Pct 0.71 Running_Pct 98.53 these shared & Exculsive latchs acquired in waits stats in cummulative number since restarted server,...

How to apply patches one and more sql at same tme - one of the our client ask to me ,300 sql servers need to apply patches same time ? how to do...

Central Management Server left out in the cold - I just set up a Central Management Server and can now check my policies against a whole group of SQL...

Can’t use connect using (local) or localhost as a server name - Hello everyone I have a laptop with SQL Server 2008 installed locally. I can only connect to the server by specifying...

Transaction Log growth out of control - Last weekend I re-indexed some Databases. Before doing so I backed up the Databases and Set them to simple recovery mode. After...

Career : Certification

How many tests do I need for 2012 after I get my MCITP - OK, I'm desperate to figure out how many exams I have to take after I finish the SQL 2008 exams...

Career : Employers and Employees

Client does not want to pay overtime. How to deal with it ? - I am hourly-paid employee of a consulting company, but work all the time at client site. Sometimes I have to...

Programming : Powershell

Powershell error - Ok in ISE , fails in Agent job - Morning all. I am trying to run script to get Translog details. The script works fine in ISE and produces report...

SQLServerCentral.com : Anything that is NOT about SQL!

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

Today's Random Word! - HI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...

Reporting Services : Reporting Services

Enhanced Your Barcode Display and Encode Non-English Characters in 2D Barcode - The latest version of [b][url=http://www.aspose.com/reporting-services/barcode-component.aspx] Aspose.BarCode for Reporting Services [/url][/b] 5.6.0 has been released. This release discusses some important features...

SSRS Report : Help Me to display text box values in Header of the report - Hello guys, sorry if I am posting in the wrong section of the Forum, I am looking for the help on...

Database Design : Design Ideas and Questions

How to handle dynamic fields - I'm not sure if I'm using the right terms, but I was wondering the proper way to design a database/application...

Data Warehousing : Integration Services

SCript component Binary code code not found error always - SSIS2012 - I have spent three days on this not able to find an anserr Added script component transform open the edit script...

Incremental Load using SQL SERVER 2008 - I have to perform incremental load using ssis. The workflow and architecture is as follows: I have an etl process in...

SSIS Scenario Help me ? - Dear All, Have a nice day for all. We have a scenario for out project.we have extract data from oracle sourece to...

Roll back .AddRow() in Script Component? - Hi all I have an asynchronous script component which does something like this: [code="vb"] try { this.DataOutputBuffer.AddRow(); this.DataOutputBuffer.ETLLogPackageExecutionId = ETLLogPackageExecutionId; //other columns defined here } catch...

Data Transfer - data not transfered in order - hi there, I have a table with 371 751 rows. I have a standard SSIS package that transfers data from table...

Data Warehousing : Strategies and Ideas

Extend or migrate a Fact Table? - Hi Folks, I`m facing a Situation, in which the reference data of our data warehouse is changing. Basically a new System...

Good analysing, reporting end-user tool ?? - Hi, I'm looking for a good analysing program for our end-users. It needs to be able to : build queries with a simple...

Data Warehousing : Analysis Services

Cube dimension listings - I'm trying to recreate an old SSAS 2000 cube in 2008, and I've got most everything done. The problem is...

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