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:...
View Answer
| Jul 25 2005 12:16 AM GMT
| asked by
nbellistri
Hardware, Database Management Systems, SQL Server
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%...
View Answer
| Jul 15 2005 10:19 AM GMT
| asked by
RobynLorusso23
Database Management Systems, SQL Server, Administration
Changing the statement heap parameter on iSeries
Hi,I would like to know how to change the statement heap parameter DB2 (stmtheap) on the AS/400. I tried the command GET DATABASE CONFIGURATION FOR database-alias (giving alias name as the AS/400 server name) but it returns the error "SQL0901N The SQL statement failed because of a non-severe...
View Answer
| Jun 8 2005 6:10 AM GMT
| asked by
sbkhole
DataCenter, Data center operations, Physical security
Inserting data into a vargraphic data type field
How to insert data into a vargraphic data type field. I have done the following CREATE TABLE TEST_TABLE (FLD1 VARGRAPHIC(20))This is done succesfullyINSERT INTO TEST_TABLE VALUES('TEST')This gives a SQL error Please let me know how I can acheive it.
View Answer
| Apr 28 2005 9:44 AM GMT
| asked by
sbkhole
DataCenter, Data center operations, IT architecture
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...
View Answer
| Dec 17 2004 2:20 AM GMT
| asked by
jsbaig
Application software, IBM, Servers
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 generationReverse engineeringAccurately representing every detail of a databaseSpeedUse for different DB platformsThanks for any comments.
View Answer
| May 12 2004 3:29 PM GMT
| asked by
pegasusdba
Availability, Modeling, Security
