Click here to Skip to main content
15,878,430 members
Home / Discussions / Database
   

Database

 
AnswerRe: Not In operation? Pin
TheFM23417-Jul-08 3:00
TheFM23417-Jul-08 3:00 
GeneralRe: Not In operation? Pin
Member 387988117-Jul-08 3:09
Member 387988117-Jul-08 3:09 
Questionselect datas using union operation Pin
deepthy.p.m16-Jul-08 22:48
deepthy.p.m16-Jul-08 22:48 
AnswerRe: select datas using union operation Pin
Vimalsoft(Pty) Ltd17-Jul-08 0:50
professionalVimalsoft(Pty) Ltd17-Jul-08 0:50 
Questionreturn Table name + Column Name in sql query Pin
farabba16-Jul-08 20:51
farabba16-Jul-08 20:51 
AnswerRe: return Table name + Column Name in sql query Pin
Harvey Saayman16-Jul-08 23:01
Harvey Saayman16-Jul-08 23:01 
GeneralRe: return Table name + Column Name in sql query Pin
Mycroft Holmes17-Jul-08 20:08
professionalMycroft Holmes17-Jul-08 20:08 
GeneralRe: return Table name + Column Name in sql query Pin
Harvey Saayman17-Jul-08 20:19
Harvey Saayman17-Jul-08 20:19 
i dont know the EXACT reason why, but i have been told(by my step mom who's been a data architect at a large insurance company's data warehouse for the past 20 years, and many other people) that SELECT * FROM has significant and unnecessary server overhead. And when your working with db's that have terras and terras of data you can and will bring the system down.

The using of SELECT * FROM worn have a noticeable effect if your working on a much smaller scale db but its considered bad practice.

SQL just has these little things that bring performance down, another example would be using the prefix "sp_" in front of a stored procedure's name... the reason for that is that sp stands for system procedure and NOT stored procedure, so SQL goes and looks through the system procedures first before moving on to stored procedures.

Cheers Smile | :)

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL

you.suck = (you.passion != Programming)

GeneralRe: return Table name + Column Name in sql query Pin
Mycroft Holmes17-Jul-08 20:44
professionalMycroft Holmes17-Jul-08 20:44 
AnswerRe: return Table name + Column Name in sql query Pin
MBCDC21-Jul-08 0:39
MBCDC21-Jul-08 0:39 
Questiondynamically applyin styles based on DB Value to reports Pin
ch.ramesh16-Jul-08 19:06
ch.ramesh16-Jul-08 19:06 
AnswerRe: dynamically applyin styles based on DB Value to reports Pin
Ashfield16-Jul-08 20:13
Ashfield16-Jul-08 20:13 
GeneralRe: dynamically applyin styles based on DB Value to reports Pin
ch.ramesh16-Jul-08 20:21
ch.ramesh16-Jul-08 20:21 
GeneralRe: dynamically applyin styles based on DB Value to reports Pin
Ashfield17-Jul-08 2:24
Ashfield17-Jul-08 2:24 
QuestionMultiple queries within an ADO connection Pin
Airickjay16-Jul-08 9:50
Airickjay16-Jul-08 9:50 
AnswerRe: Multiple queries within an ADO connection Pin
tsaunders16-Jul-08 15:09
tsaunders16-Jul-08 15:09 
AnswerRe: Multiple queries within an ADO connection Pin
andyharman17-Jul-08 7:15
professionalandyharman17-Jul-08 7:15 
AnswerRe: Multiple queries within an ADO connection Pin
Airickjay17-Jul-08 8:30
Airickjay17-Jul-08 8:30 
AnswerRe: Multiple queries within an ADO connection Pin
MBCDC21-Jul-08 0:59
MBCDC21-Jul-08 0:59 
Questionerror when deleting with the WITH clause? Pin
harcaype16-Jul-08 7:01
harcaype16-Jul-08 7:01 
AnswerRe: error when deleting with the WITH clause? Pin
tsaunders16-Jul-08 15:02
tsaunders16-Jul-08 15:02 
GeneralRe: error when deleting with the WITH clause? Pin
harcaype16-Jul-08 19:13
harcaype16-Jul-08 19:13 
AnswerRe: error when deleting with the WITH clause? Pin
leoinfo17-Jul-08 4:19
leoinfo17-Jul-08 4:19 
GeneralRe: error when deleting with the WITH clause? Pin
harcaype17-Jul-08 5:56
harcaype17-Jul-08 5:56 
QuestionHow to get the first rows of a relational table (depending of the last date of change) Pin
fracalifa16-Jul-08 1:51
fracalifa16-Jul-08 1:51 

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.