Büyük bir tablonun küçük örneğini yapmak

by nurgun 11. January 2010 21:43

Büyük tablolarla çalışmak zordur, test ve debug işlemlerinde zamanın çoğu beklemekte geçebilir.

Örnek tablomuzda 40,000,000 kayıt olduğunu varsayalım, bu sorguyu çalıştırırsak TPropertyValue_Ornek

tabloyu yaratmış olacağız. Bu tabloda 400,000 rastgele seçilmiş kayıt olacaktır.

SELECT TOP 10 PERCENT * INTO TPropertyValue_Ornek

FROM TPropertyValue

ORDER BY NEWID()

 

Üstteki sorgu tempdb kullandığı için performans sorunu yaşayabilirsiniz. Bu durumda alttaki sorguyu çalıştırın.

SELECT  * INTO TPropertyValue_Ornek

FROM TPropertyValue

WHERE (ABS(CAST(

  (BINARY_CHECKSUM(*) *

  RAND()) as int)) % 100) < 10

Burada ~400,000 rastgele seçilmiş kayıt olacaktır.

 

 

Tags: ,

MS SQL | MS SQL Performans | MS SQL Server Yönetimi

Comments

4/22/2010 9:39:32 AM #

outdoor wall lighting fixtures

I dont know what to say.  This blog is fantastic.  Thats not really a really huge statement, but its all I could come up with after reading this.  You know so much about this subject.  So much so that you made me want to learn more about it.  Your blog is my stepping stone, my friend.  Thanks for the heads up on this subject.

outdoor wall lighting fixtures United States | Reply

4/22/2010 8:17:05 PM #

outdoor wall lighting fixtures

I dont know what to say.  This blog is fantastic.  Thats not really a really huge statement, but its all I could come up with after reading this.  You know so much about this subject.  So much so that you made me want to learn more about it.  Your blog is my stepping stone, my friend.  Thanks for the heads up on this subject.

outdoor wall lighting fixtures United States | Reply

4/24/2010 8:10:39 PM #

Corporate Gift Basket

I just cant stop reading this.  Its so cool, so full of information that I just didnt know.  Im glad to see that people are actually writing about this issue in such a smart way, showing us all different sides to it.  Youre a great blogger.  Please keep it up.  I cant wait to read whats next.

Corporate Gift Basket United States | Reply

4/25/2010 5:54:07 PM #

time management strategies

I think youve made some truly interesting points.  Not too many people would actually think about this the way you just did.  Im really impressed that theres so much about this subject thats been uncovered and you did it so well, with so much class.  Good one you, man!  Really great stuff here.

time management strategies United States | Reply

4/27/2010 11:47:11 PM #

Rapidshare

I\'m happy I found this blog, I couldnt discover any info on this subject matter prior to. I also run a site and if you want to ever serious in a little bit of guest writing for me if possible feel free to let me know, i\'m always look for people to check out my site. Please stop by and leave a comment sometime!

Rapidshare United States | Reply

4/28/2010 12:06:52 PM #

PR Discussions

I like it!  I like it a lot.  You know exactly what youre talking about, exactly where other people are coming from on this issue.  Im glad that I had the fortune to stumble across your blog.  Its definitely an important issue that not enough people are talking about and Im glad that I got the chance to see all the angles.

PR Discussions United States | Reply

5/3/2010 1:54:35 AM #

online backup

Write more, thats all I have to say.  Literally, it seems as though you relied on the video to make your point.  You clearly know what youre talking about, why waste your intelligence on just posting videos to your blog when you could be giving us something enlightening to read?

online backup United States | Reply

5/3/2010 5:55:00 AM #

wedding anniversary gifts

Hrmm that was weird, my comment got eaten. Anyway I wanted to say that it's nice to know that someone else also mentioned this as I had trouble finding the same info elsewhere. This was the first place that told me the answer. Thanks.

wedding anniversary gifts United States | Reply

5/3/2010 6:58:43 PM #

compare fishing pole

Your blog is outrageous!  I mean, Ive never been so entertained by anything in my life!  Your vids are perfect for this.  I mean, how did you manage to find something that matches your style of writing so well?  Im really happy I started reading this today.  Youve got a follower in me for sure!

compare fishing pole United States | Reply

5/4/2010 12:02:28 AM #

boat canopy

Thank you for this blog.  Thats all I can say.  You most definitely have made this blog into something thats eye opening and important.  You clearly know so much about the subject, youve covered so many bases.  Great stuff from this part of the internet.  Again, thank you for this blog.

boat canopy United States | Reply

5/4/2010 7:05:17 AM #

tax rebate calculator

How-do-you-do, just needed you to know I have added your site to my Google bookmarks because of your extraordinary blog layout. But seriously, I think your site has one of the freshest theme I've came across. It really helps make reading your blog a lot easier.

tax rebate calculator United States | Reply

5/4/2010 9:55:22 AM #

boat canopy

Thank you for this blog.  Thats all I can say.  You most definitely have made this blog into something thats eye opening and important.  You clearly know so much about the subject, youve covered so many bases.  Great stuff from this part of the internet.  Again, thank you for this blog.

boat canopy United States | Reply

5/8/2010 10:41:13 PM #

Make money online

For what its worth, the layout is definitely amazing.  You know how to balance writing and images/videos.  However, I cant get over how little you actually bring to light here.  I think that everyones said the same thing that youve said over and over again.  Dont you think its time for something more?

Make money online United States | Reply

5/9/2010 1:33:04 PM #

Backpacking In Europe

I dont know who you think you are, but youre just blowing smoke out your ears.  Nothing youre saying makes sense and its all a bunch of immature ranting.  If you want people to get behind your blog, you should at the very least learn a little something about what youre talking about!

Backpacking In Europe United States | Reply

5/15/2010 9:43:05 AM #

pingback

Pingback from topsy.com

Twitter Trackbacks for
        
        MSSQL ve Oracle Blog, MSSQL, Oracle, Telekom | Büyük bir tablonun küçük örneğini yapmak
        [nurgun.net]
        on Topsy.com

topsy.com | Reply

5/16/2010 9:55:57 PM #

lp gas grill

I dont really know what youre talking about here.  This cant be the only way to think about this can it?  It seems like you know a lot about the subject, so why not explore it more?  Make it more accessible to everyone else who may not agree with you?  Youd get a lot more people behind this if you just stopped making general statements.

lp gas grill United States | Reply

5/22/2010 3:50:26 PM #

Italy Private Jet Charter

Congratulations on having one of the most sophisticated blogs Ive come across in some time!  Its just incredible how much you can take away from something simply because of how visually beautiful it is.  Youve put together a great blog space --great graphics, videos, layout.  This is definitely a must-see blog!

Italy Private Jet Charter United States | Reply

5/27/2010 9:25:06 AM #

Designer handbags

Anyway I wanted to say that it's nice to know that someone else also mentioned this as I had trouble finding the same info elsewhere. This was the first place that told me the answer. Thanks.

Designer handbags United States | Reply

5/29/2010 4:55:00 AM #

Payday Cash

Can I make a suggestion?  I think youve got something good here.  But what if you added a couple links to a page that backs up what youre saying?  Or maybe you could give us something to look at, something that would connect what youre saying to something tangible?  Just a suggestion.

Payday Cash United States | Reply

5/29/2010 11:11:45 PM #

band text marketing

I was wondering if you ever considered changing the layout of your blog?  Its very well written; I love what youve got to say.  But maybe you could a little more in the way of content so people could connect with it better.  Youve got an awful lot of text for only having one or two images.  Maybe you could space it out better?

band text marketing United States | Reply

5/31/2010 4:17:41 AM #

designer handbags

. I also run a site and if you want to ever serious in a little bit of guest writing for me if possible feel free to let me know, i\'m always look for people to check out my site. Please stop by and leave a comment sometime!

designer handbags United States | Reply

5/31/2010 9:03:33 PM #

profit instruments review

Wicked tale.

profit instruments review United States | Reply

6/5/2010 8:17:51 AM #

 Cho Yung Tea

Really a educative and informative post, the post is good in all regards,I am glad to read this post.

www.articlesbase.com/.../...ree-trial-2124982.html

Cho Yung Tea United States | Reply

6/16/2010 10:02:20 PM #

Svitlana.Net.Ua

I would like to thank you for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own BlogEngine blog now.

Svitlana.Net.Ua United States | Reply

6/17/2010 9:13:24 AM #

financial aid for single mothers

Nice coding you got in here. It is actually very helpful especially for the ones who are just starting SQL and Oracle. They will definitely learn a lot from this blog.

financial aid for single mothers United States | Reply

6/19/2010 4:35:32 PM #

няня

I would like to thank you for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. In fact your creative writing abilities has inspired me to start my own BlogEngine blog now.
http://svitlana.net.ua/staff/category/3/ гувернантка, http://svitlana.net.ua/staff/category/5/ повар, http://svitlana.net.ua/staff/category/6/ садовник, http://svitlana.net.ua/staff/category/10/ репетитор, http://svitlana.net.ua/staff/category/4 домработница, http://svitlana.net.ua/staff/category/8/ семейная пара, http://svitlana.net.ua/pages/2/ работа няней.

няня United States | Reply

6/24/2010 8:20:11 PM #

kord gitar lagu melayu

thanks for sharing

kord gitar lagu melayu United States | Reply

6/25/2010 3:59:55 AM #

Игра в Покер

Can you please provide more information on this subject? BTW your blog is great. Cheers.

Игра в Покер United States | Reply

7/4/2010 6:02:39 AM #

Красивые проститутки

Люди, в виду свое занятости, не имеют много времени для того, что бы искать себе развлечение, тем более такое специфическое. Именно для этих целей и ввели в список своих услуг эту, которая помогает удовлетворять запросы таких клиентов. Согласитесь, очень удобно просто снять трубку телефона, заказать себе такую услугу, и проститутки Сочи  вас поймут, и организуют все по высшему уровню. Стоит отметить, чтобы качественно предложить вам БДСМ, жрицы любви долго практикуются, изучают соответствующую литературу, что бы полностью быть в теме и не разочаровать требовательного клиента. А это не так уж и просто.

Красивые проститутки United States | Reply

7/4/2010 6:51:03 AM #

Магазин сантехники

It\\\'s an intriguing approach. I commonly see minimalist judgments on the matter but yours it\\\'s written in a pretty special way. For sure, I will revisit your site for more info.

Магазин сантехники United States | Reply

7/7/2010 4:19:26 AM #

woodworking classes nj

Do you have a perception of what shade you’re following? Maybe a thing close towards color with the trim? If so, shellac may perhaps do the trick.

woodworking classes nj United States | Reply

7/7/2010 9:27:14 AM #

Проститутки в Москве

I like your blog so much that I feel I have to wish you. Happy New Year in advance. Have a nice and prosperous year ahead

Проститутки в Москве United States | Reply

7/11/2010 4:05:44 AM #

Новинки сантехники

I really got a kick out of your article. I don\\\'t really have much to say in reply, I only wanted to comment to reply with wonderful operate. good luck in 2010.

Новинки сантехники United States | Reply

7/12/2010 4:01:50 AM #

Проститутки

You gave nice ideas here. I done a research on the issue and learnt most peoples will agree with your blog. Certainly, these practices are unfair; but they say that most of their rules are only to apply to people who overdraw.

Проститутки United States | Reply

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading



Nurgün Özgür

Facebook

 

Nurgün Özgür Photo

1993'ten bu yana profesyonel olarak yazılım ve sistem yönetimi konularında çeşitli yerli ve yabanci kuruluşların farklı kademelerinde aktif olarak yer aldım. Halen, telekomünikasyon alanında dünya lideri bir kuruluşta Software Team Manager görevimi sürdürmekteyim.

 

Valid XHTML 1.0 Transitional


Tag cloud

PagerankAlexa.Com PagerankAlexa.com