Database modeling question
I have a quandry on my hands. Another developer and I are designing a replacement for an older custom application, and we’re deep into data modeling. We can’t agree on a solution. More precisely, I think it should go one way, he thinks it should go a different way, and I can’t quite prove that [...]

Answer Question   |  July 30, 2009  9:04 PM
Database, Modeling, Normalization

what is normalization
what is normalization

Answer Question   |  September 27, 2007  7:05 AM
Normalization

SQL Server worst practices
Hello, My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here: http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1071463,00.html. In response to this tip, several readers [...]

Answer Question   |  July 26, 2005  12:16 PM
Administration, Availability, Backup & recovery, CE/Mobile, Database Management Systems, Development, Hardware, Migration, Modeling, Normalization, Performance/Tuning, Security, SQL Server, Standard Edition 2000, Version 7 and earlier

Upgrade to SQL Server 2005 sooner or later?
Hello, I’m the editor of SearchSQLServer.com and I am hoping to get your opinons on a timely topic. Prior to Microsoft announcing its November 7 release date for SQL Server 2005, we had run a poll asking site members: How have the delays with SQL Server 2005 affected your organization’s plans? 58% delays had no [...]

Answer Question   |  July 22, 2005  10:19 AM
Administration, Architecture/Design, Availability, Backup & recovery, CE/Mobile, Database Management Systems, Implementation, Installation/Upgrade, Migration, Modeling, Normalization, Performance/Tuning, Security, SQL Server, Standard Edition 2000, Tech support, Version 7 and earlier

Stored Procedure Error
This is mu stored Procedure: CREATE PROCEDURE ADMINISTRATOR.DIMS_SP_PerformSearch ( vuserId integer, vsearchText varchar(500) , vfromID integer, voption integer ) ———————————————————————— – SQL Stored Procedure ———————————————————————— BEGIN IF (vsearchText != ”) THEN delete from DIMS_General_Search where userId = vuserId; end if; IF (voption = 0) THEN INSERT INTO DIMS_General_Search SELECT vuserId,DIMS_Scanned_Transaction.scanned_date , DIMS_Document_Type.document_type_name , DIMS_Document_type_Attributes.attribute_name,DIMS_Scanned_transaction_Detail.answer, DIMS_Scanned_Transaction.scanned_transaction_id [...]

Answer Question   |  December 17, 2004  2:20 AM
Application software, Availability, DB2 Everyplace, Development, IBM, Instant Messaging, Java, Migration, Modeling, Normalization, Performance/Tuning, Servers, WebSphere Studio

Oracle 9i Designer
Do you have any opinions on the use of Designer versus a tool like Erwin or PowerDesigner in handling the following concerns: Database generation Reverse engineering Accurately representing every detail of a database Speed Use for different DB platforms Thanks for any comments.

Answer Question   |  May 12, 2004  3:29 PM
Availability, Backup & recovery, Migration, Modeling, Normalization, Performance/Tuning, Security, Storage management, Very Large Databases