Click here to Skip to main content
15,890,438 members
Home / Discussions / Database
   

Database

 
GeneralRe: Stored procedure / query optimization Pin
Vagif Abilov29-Sep-04 19:40
professionalVagif Abilov29-Sep-04 19:40 
Generaleqivalent of "FOR UPDATE" Pin
WinDotNet27-Sep-04 19:35
WinDotNet27-Sep-04 19:35 
GeneralRe: eqivalent of "FOR UPDATE" Pin
Anonymous30-Sep-04 0:34
Anonymous30-Sep-04 0:34 
GeneralOracleClient StoredProcedure Pin
jzb27-Sep-04 17:01
jzb27-Sep-04 17:01 
QuestionAny way to optomize this? Pin
Jacob Hammack27-Sep-04 16:48
Jacob Hammack27-Sep-04 16:48 
AnswerRe: Any way to optomize this? Pin
Mike Ellison27-Sep-04 17:15
Mike Ellison27-Sep-04 17:15 
GeneralRe: Any way to optomize this? Pin
Jacob Hammack29-Sep-04 11:39
Jacob Hammack29-Sep-04 11:39 
AnswerRe: Any way to optomize this? Pin
Bill Dean29-Sep-04 6:50
Bill Dean29-Sep-04 6:50 
Hi Jacob,

I have a couple of fairly phylisophical points to add. Ignore them as you please Smile | :) .

First off, it's not a really good idea to change database schema from within your code. Creating and deleting view (and table and sprocs, etc) are really design-time processes. Do it before-hand and be done. Why? Well, what happens when user #2 tries to create the view before user #1 drops? You've got an exception to handle... It just get's too messy.

Related to the first point, I am very leary of a program running with a sql user that has sufficient privileges to alter the db schema.

Just my $0.02
Bill
QuestionHow to position to row in DataTable or DataView Pin
magic4927-Sep-04 7:58
magic4927-Sep-04 7:58 
AnswerRe: How to position to row in DataTable or DataView Pin
Bill Dean29-Sep-04 7:01
Bill Dean29-Sep-04 7:01 
Generalsaving/retrieving image data in MSDE Pin
LongRange.Shooter27-Sep-04 7:40
LongRange.Shooter27-Sep-04 7:40 
GeneralPartial answer Pin
Steven Campbell27-Sep-04 8:30
Steven Campbell27-Sep-04 8:30 
GeneralRe: urgent can any help me ? Pin
Mike Ellison27-Sep-04 18:26
Mike Ellison27-Sep-04 18:26 
GeneralRe: urgent can any help me ? Pin
Colin Angus Mackay29-Sep-04 7:02
Colin Angus Mackay29-Sep-04 7:02 
GeneralRe: urgent can any help me ? Pin
Mike Ellison29-Sep-04 7:10
Mike Ellison29-Sep-04 7:10 
Generaldatabinding a dataset / datarows / columns to a tablecontrol - please help Pin
sean123027-Sep-04 3:40
sean123027-Sep-04 3:40 
GeneralSQL server/ ADO.NET performance Pin
Paul Horstink27-Sep-04 0:47
Paul Horstink27-Sep-04 0:47 
GeneralRe: SQL server/ ADO.NET performance Pin
David Salter27-Sep-04 3:21
David Salter27-Sep-04 3:21 
Generalrow locking Pin
WinDotNet26-Sep-04 20:29
WinDotNet26-Sep-04 20:29 
GeneralParameterised Queries in VB6 Pin
David Wengier26-Sep-04 14:29
David Wengier26-Sep-04 14:29 
GeneralRe: Parameterised Queries in VB6 Pin
rmacfadyen26-Sep-04 15:10
rmacfadyen26-Sep-04 15:10 
GeneralRe: Parameterised Queries in VB6 Pin
David Wengier26-Sep-04 18:21
David Wengier26-Sep-04 18:21 
GeneralRe: Parameterised Queries in VB6 Pin
rmacfadyen26-Sep-04 19:24
rmacfadyen26-Sep-04 19:24 
GeneralDataTable question... Pin
Besinci26-Sep-04 7:32
Besinci26-Sep-04 7:32 
GeneralRe: DataTable question... Pin
Mike Ellison27-Sep-04 18:25
Mike Ellison27-Sep-04 18:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.