sql server - SQL query to fast data generation -

-

i have created query generate data sql databases, generation of 1 gb data takes 45 minutes. how increase performance of data generation?

declare @rowcount int declare @rowstring varchar(10) declare @random int declare @upper int declare @lower int declare @insertdate datetime  set @lower = -730 set @upper = -1 set @rowcount = 0  while @rowcount < 3000000 begin  set @rowstring = cast(@rowcount varchar(10))  select @random = round(((@upper - @lower -1) * rand() + @lower), 0)  set @insertdate = dateadd(dd, @random, getdate())   insert table_1   (q   ,w   ,e   ,r   ,t   ,y)  values   (replicate('0', 10 - datalength(@rowstring)) + @rowstring   , @insertdate   ,dateadd(dd, 1, @insertdate)   ,dateadd(dd, 2, @insertdate)   ,dateadd(dd, 3, @insertdate)   ,dateadd(dd, 4, @insertdate))   set @rowcount = @rowcount + 1 end

you may try following also:

;with seq (     select top (3000000) n = row_number() on (order @@spid) - 1 sys.all_columns c1, sys.all_columns c2 ) insert table_1 (q, w, e, r, t, y) select     right('0000000000' + cast(n varchar(10)), 10)     ,p.insertdate     ,dateadd(dd, 1, p.insertdate)     ,dateadd(dd, 2, p.insertdate)     ,dateadd(dd, 3, p.insertdate)     ,dateadd(dd, 4, p.insertdate) seq     cross apply (select dateadd(dd, round(((@upper - @lower -1) * rand(checksum(newid())) + @lower), 0), getdate())) p(insertdate)

Comments

Post a Comment

Popular posts from this blog

design - Custom Styling Qt Quick Controls -

-
Image
i have custom design qt quick controls. example, change background colour of tool bar, since hate default design. how can that? in qt quick controls, there limited styling available via qt quick control styles items, buttonstyle , checkboxstyle , etc. at moment, other styles require delving qt sources , messing internal details. here complete example of how 1 might modify toolbar's style. main.qml import qtquick 2.1 import qtquick.layouts 1.0 import qtquick.controls 1.0 applicationwindow { toolbar: toolbar { id: toolbar component.oncompleted: toolbar.data[0].item.children = [newrectangle]; property item _newrectangle: rectangle { // rectangle within toolbarstyle's panel // gleaned from: // http://qt.gitorious.org/qt/qtquickcontrols/source/ // c304d741a27b5822a35d1fb83f8f5e65719907ce:src/styles/base/toolbarstyle.qml id: newrectangle anchors.fill: parent...
Read more

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more