Click here to Skip to main content
15,848,903 members
Home / Discussions / Database
   

Database

 
Questionproblem modeling messages tables Pin
ahmadiss19-Jul-12 7:10
ahmadiss19-Jul-12 7:10 
AnswerRe: problem modeling messages tables Pin
PIEBALDconsult19-Jul-12 13:24
mvePIEBALDconsult19-Jul-12 13:24 
GeneralRe: problem modeling messages tables Pin
ahmadiss20-Jul-12 1:44
ahmadiss20-Jul-12 1:44 
GeneralRe: problem modeling messages tables Pin
PIEBALDconsult20-Jul-12 4:40
mvePIEBALDconsult20-Jul-12 4:40 
GeneralRe: problem modeling messages tables Pin
ahmadiss22-Jul-12 6:12
ahmadiss22-Jul-12 6:12 
Questionhow to stop sql server 2005 Pin
sumeet kumar Attri18-Jul-12 22:38
sumeet kumar Attri18-Jul-12 22:38 
AnswerRe: how to stop sql server 2005 Pin
Karthik Harve18-Jul-12 23:26
professionalKarthik Harve18-Jul-12 23:26 
GeneralMaking a row-based Iteration of a Bulk-Insertion Pin
SkyRunner18-Jul-12 22:16
SkyRunner18-Jul-12 22:16 
We are looking a change on the code to make it watchable and improve it's performance.

Want to change this piece of SQL query into a loop version which
Could `Select-Insert` records by 1000 items per iteration.

On each iteration want to get a print to see what was the last inserted item
and if possible get the elapsed time on the iteration.

The Code :

INSERT INTO [tData2]
(
[Key],
Info1,
Info2
)
SELECT
[Key],
Info1,
Info2
FROM
[tData]
-- Conditions were removed as weren't related to this question

your help is really appreciated.

modified 19-Jul-12 3:50am.

AnswerRe: Making a row-based Iteration of a Bulk-Insertion Pin
Eddy Vluggen19-Jul-12 0:34
professionalEddy Vluggen19-Jul-12 0:34 
GeneralRe: Making a row-based Iteration of a Bulk-Insertion Pin
Michael Potter19-Jul-12 4:50
Michael Potter19-Jul-12 4:50 
GeneralRe: Making a row-based Iteration of a Bulk-Insertion Pin
SkyRunner19-Jul-12 6:08
SkyRunner19-Jul-12 6:08 
QuestionSSIS and SSAS Pin
Member 927049917-Jul-12 22:06
Member 927049917-Jul-12 22:06 
AnswerRe: SSIS and SSAS Pin
Mycroft Holmes18-Jul-12 14:00
professionalMycroft Holmes18-Jul-12 14:00 
QuestionRe: SSIS and SSAS Pin
Jan Steyn19-Jul-12 4:59
Jan Steyn19-Jul-12 4:59 
QuestionMicrosoft reporting services Pin
berba17-Jul-12 1:44
berba17-Jul-12 1:44 
QuestionDeleting Data Using Job Scheduler Pin
ASPnoob16-Jul-12 23:59
ASPnoob16-Jul-12 23:59 
AnswerRe: Deleting Data Using Job Scheduler Pin
rimazuc17-Jul-12 1:00
rimazuc17-Jul-12 1:00 
AnswerRe: Deleting Data Using Job Scheduler Pin
Michael Potter17-Jul-12 4:38
Michael Potter17-Jul-12 4:38 
QuestionAn Iteration with renaming and avoiding duplicates Pin
SkyRunner16-Jul-12 9:37
SkyRunner16-Jul-12 9:37 
QuestionRe: An Iteration with renaming and avoiding duplicates Pin
Suvabrata Roy16-Jul-12 9:55
professionalSuvabrata Roy16-Jul-12 9:55 
AnswerRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 3:36
SkyRunner17-Jul-12 3:36 
AnswerRe: An Iteration with renaming and avoiding duplicates Pin
Mycroft Holmes16-Jul-12 13:58
professionalMycroft Holmes16-Jul-12 13:58 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 3:39
SkyRunner17-Jul-12 3:39 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
Mycroft Holmes17-Jul-12 3:59
professionalMycroft Holmes17-Jul-12 3:59 
GeneralRe: An Iteration with renaming and avoiding duplicates Pin
SkyRunner17-Jul-12 4:08
SkyRunner17-Jul-12 4:08 

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.