Click here to Skip to main content
15,905,781 members
Home / Discussions / Database
   

Database

 
GeneralRe: How do I write the insert sql statement for the following scenario ? Pin
karengsh14-Jun-17 18:55
karengsh14-Jun-17 18:55 
Questionwhy we use datareader Pin
Mazahir Habib1-Jun-17 20:10
Mazahir Habib1-Jun-17 20:10 
AnswerRe: why we use datareader Pin
John C Rayan1-Jun-17 22:16
professionalJohn C Rayan1-Jun-17 22:16 
GeneralRe: why we use datareader Pin
Mycroft Holmes1-Jun-17 22:25
professionalMycroft Holmes1-Jun-17 22:25 
Questionattempt to load oracle client libraries threw badimageformatexception ssis Pin
indian1431-Jun-17 13:59
indian1431-Jun-17 13:59 
AnswerRe: attempt to load oracle client libraries threw badimageformatexception ssis Pin
Richard Deeming2-Jun-17 1:18
mveRichard Deeming2-Jun-17 1:18 
QuestionLoading Data on Demand Pin
Richard Andrew x6431-May-17 11:02
professionalRichard Andrew x6431-May-17 11:02 
AnswerRe: Loading Data on Demand Pin
Richard Deeming31-May-17 11:44
mveRichard Deeming31-May-17 11:44 
#1 - it loads all of the rows into memory at once. DataTable.Load | Reference Source[^]

Displaying 150,000 rows on screen in one hit is not a good idea. How is the poor user ever going to find the one row they're interested in? There must be some way to summarise, filter, or page the data to make it easier to consume.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer


GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:05
professionalRichard Andrew x6431-May-17 13:05 
AnswerRe: Loading Data on Demand Pin
Mycroft Holmes31-May-17 13:01
professionalMycroft Holmes31-May-17 13:01 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:07
professionalRichard Andrew x6431-May-17 13:07 
GeneralRe: Loading Data on Demand Pin
Mycroft Holmes31-May-17 13:21
professionalMycroft Holmes31-May-17 13:21 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:28
professionalRichard Andrew x6431-May-17 13:28 
AnswerRe: Loading Data on Demand Pin
Eddy Vluggen31-May-17 13:21
professionalEddy Vluggen31-May-17 13:21 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6431-May-17 13:36
professionalRichard Andrew x6431-May-17 13:36 
GeneralRe: Loading Data on Demand Pin
Eddy Vluggen1-Jun-17 0:35
professionalEddy Vluggen1-Jun-17 0:35 
AnswerRe: Loading Data on Demand Pin
Jörgen Andersson31-May-17 22:18
professionalJörgen Andersson31-May-17 22:18 
GeneralRe: Loading Data on Demand Pin
Richard Andrew x6416-Jun-17 11:20
professionalRichard Andrew x6416-Jun-17 11:20 
QuestionSQL server: How to get backup file information using SMO Pin
w1424326-May-17 17:52
w1424326-May-17 17:52 
AnswerRe: SQL server: How to get backup file information using SMO Pin
Eddy Vluggen2-Jun-17 1:44
professionalEddy Vluggen2-Jun-17 1:44 
QuestionHow to create SQL Server backup folder Pin
w1424326-May-17 17:44
w1424326-May-17 17:44 
QuestionSSRS - dynamic columns depending on client parameter Pin
Danpeking24-May-17 23:33
Danpeking24-May-17 23:33 
QuestionSql server: create table with column that support unique and multiple nulls Pin
w1424323-May-17 20:03
w1424323-May-17 20:03 
AnswerRe: Sql server: create table with column that support unique and multiple nulls Pin
Maciej Los23-May-17 20:27
mveMaciej Los23-May-17 20:27 
GeneralRe: Sql server: create table with column that support unique and multiple nulls Pin
w1424323-May-17 20:45
w1424323-May-17 20:45 

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.