Are the posted questions getting worse?
-
GilaMonster (4/28/2016)
Phil Parkin (4/28/2016)
Does anyone have The Ball today?Mine just reads "Maybe"
Are you sure about that?
Apparently the initial post changed.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
Lynn Pettis (4/28/2016)
I think it is time for me to take a break.People can't format their code to make it readable, can't post enough information to really help them with out guessing at most of what they need, some get upset when you ask for more information, some don't give you what you ask for, and I find more and more irritating.
I'll keep an eye here on the water cooler, but other than that, I think I'm done for a while.
Uh oh. Lynn, if you aren't answering questions, who's going to have the patience to deal with WC? :w00t: I don't.
We won't have anyone to keep the silver spoons stocked. 😉
-
Ed Wagner (4/28/2016)
Lynn Pettis (4/28/2016)
I think it is time for me to take a break.People can't format their code to make it readable, can't post enough information to really help them with out guessing at most of what they need, some get upset when you ask for more information, some don't give you what you ask for, and I find more and more irritating.
I'll keep an eye here on the water cooler, but other than that, I think I'm done for a while.
Uh oh. Lynn, if you aren't answering questions, who's going to have the patience to deal with WC? :w00t: I don't.
We won't have anyone to keep the silver spoons stocked. 😉
I have been self-censoring myself on several threads the last few days. If I try to assist other than maybe asking or restating a question, I can see myself definitely crossing the line regarding professionalism. I have had some extremely inappropriate replies on my mind when walking away from a few threads. Not where I want to be.
-
Lynn Pettis (4/28/2016)
Ed Wagner (4/28/2016)
Lynn Pettis (4/28/2016)
I think it is time for me to take a break.People can't format their code to make it readable, can't post enough information to really help them with out guessing at most of what they need, some get upset when you ask for more information, some don't give you what you ask for, and I find more and more irritating.
I'll keep an eye here on the water cooler, but other than that, I think I'm done for a while.
Uh oh. Lynn, if you aren't answering questions, who's going to have the patience to deal with WC? :w00t: I don't.
We won't have anyone to keep the silver spoons stocked. 😉
I have been self-censoring myself on several threads the last few days. If I try to assist other than maybe asking or restating a question, I can see myself definitely crossing the line regarding professionalism. I have had some extremely inappropriate replies on my mind when walking away from a few threads. Not where I want to be.
I hear you. I wish I could say that I have no idea how you feel, but I do. You're probably right - take a break for a while and come back fresh for a whole new round. 😉
-
Grant Fritchey (4/28/2016)
Technical question:I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able to script these exports so that I do, let's say, 10,000 rows at a time, in chunks. I'm doing this so that I have the ability to easily restart, and, allow for starting to migrate or move the exported files as each chunk finishes.
What's the best way to, in a relatively generic fashion, efficiently divide a table into these 10,000 row chunks?
Articles, blog posts, some documentation to get this going in the right direction. Please!
Oh, and, what the heck... URGENT!
Ha!
BCP and xp_CmdShell. Simple and very fast.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Jeff Moden (4/28/2016)
Grant Fritchey (4/28/2016)
Technical question:I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able to script these exports so that I do, let's say, 10,000 rows at a time, in chunks. I'm doing this so that I have the ability to easily restart, and, allow for starting to migrate or move the exported files as each chunk finishes.
What's the best way to, in a relatively generic fashion, efficiently divide a table into these 10,000 row chunks?
Articles, blog posts, some documentation to get this going in the right direction. Please!
Oh, and, what the heck... URGENT!
Ha!
BCP and xp_CmdShell. Simple and very fast.
Yes, old school is often best. It worked a decade and a half ago, and it can still work today.
If the stuff contains duplicate rows (:sick:) you need to take care of that when recording where you are up to, and it may mean you can't use precise 10,000 row chunks. In any case you need to make sure your copying and your recording of where you are at happen in the same transaction. I don't recall there being any problems apart from that (but it's a long time since I last did it).
As an alternative to xp_cmdshell and BCP, do it with an SQL agent job - a jobstep copies 10,000 rows with an insert-select statement and some extra rows if the last or those rows is not the last (or only) row with particular values using another select statement, then writes a where I'm up to record, then perhaps delays for a time and then perhaps picks itself as next step (can't remember if you need two steps to do this - it's all so long ago), or it can put the copying and place marking and delay code in a while loop within the step, or can just exit (and take the next 10,000 rows when next it's scheduled). That too is old school that will still work.
Tom
-
GilaMonster (4/27/2016)
BLOB_EATER (4/27/2016)
GilaMonster (4/26/2016)
BLOB_EATER (4/26/2016)
GilaMonster (4/26/2016)
SQLRNNR (4/26/2016)
The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according to Darth Sidious - the apprentice of Plagueis).If it is Plagueis it'll be a very nice connection.
If you haven't read the (now non-canon) book Darth Plagueis, do so. It's a fascinating story of Sidious's apprenticeship under Plagueis. Gives a much wider view into Sideous's machinations than the prequels did.
I'm going to look into this, the dark side intrigues me.
In that case, I'll recommend the title "Bane" too (the story of Darth Bane, the Sith Lord who instituted the Rule of Two after seeing in-fighting destroy the Sith Order that trained him)
Is there a specific order? Or am I good to go with either of the two?
They're set 1000 years apart.
I read Plagueis first, and only the first chapter so far of Bane
And I apologise, the title for the book about Darth Bane is "Path of Destruction"
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
GilaMonster (4/29/2016)
GilaMonster (4/27/2016)
BLOB_EATER (4/27/2016)
GilaMonster (4/26/2016)
BLOB_EATER (4/26/2016)
GilaMonster (4/26/2016)
SQLRNNR (4/26/2016)
The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according to Darth Sidious - the apprentice of Plagueis).If it is Plagueis it'll be a very nice connection.
If you haven't read the (now non-canon) book Darth Plagueis, do so. It's a fascinating story of Sidious's apprenticeship under Plagueis. Gives a much wider view into Sideous's machinations than the prequels did.
I'm going to look into this, the dark side intrigues me.
In that case, I'll recommend the title "Bane" too (the story of Darth Bane, the Sith Lord who instituted the Rule of Two after seeing in-fighting destroy the Sith Order that trained him)
Is there a specific order? Or am I good to go with either of the two?
They're set 1000 years apart.
I read Plagueis first, and only the first chapter so far of Bane
And I apologise, the title for the book about Darth Bane is "Path of Destruction"
You realize, Gail, that you are a horrible person for this... don't you?
I'm a bibliophile. I love books. But we're in the middle of an upgrade and I have so much yard work to do (pulling vines off the fence so the hornets don't decide to nest there again this year), which means I have no time to read, d@mm1t!
And here you are, tempting me. Telling me there are Books I MUST READ... Darn you, evil Sith SQL Person you!!! Horrible, evil, tempting person you.
Screw yard work. NEED BOOKS.
(Thanks for the title update. Much appreciated.) @=)
-
Brandie Tarvin (4/29/2016)
You realize, Gail, that you are a horrible person for this... don't you?I'm a bibliophile. I love books. But we're in the middle of an upgrade and I have so much yard work to do (pulling vines off the fence so the hornets don't decide to nest there again this year), which means I have no time to read, d@mm1t!
And here you are, tempting me. Telling me there are Books I MUST READ... Darn you, evil Sith SQL Person you!!! Horrible, evil, tempting person you.
Screw yard work. NEED BOOKS.
(Thanks for the title update. Much appreciated.) @=)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
TomThomson (4/28/2016)
Jeff Moden (4/28/2016)
Grant Fritchey (4/28/2016)
Technical question:I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able to script these exports so that I do, let's say, 10,000 rows at a time, in chunks. I'm doing this so that I have the ability to easily restart, and, allow for starting to migrate or move the exported files as each chunk finishes.
What's the best way to, in a relatively generic fashion, efficiently divide a table into these 10,000 row chunks?
Articles, blog posts, some documentation to get this going in the right direction. Please!
Oh, and, what the heck... URGENT!
Ha!
BCP and xp_CmdShell. Simple and very fast.
Yes, old school is often best. It worked a decade and a half ago, and it can still work today.
If the stuff contains duplicate rows (:sick:) you need to take care of that when recording where you are up to, and it may mean you can't use precise 10,000 row chunks. In any case you need to make sure your copying and your recording of where you are at happen in the same transaction. I don't recall there being any problems apart from that (but it's a long time since I last did it).
As an alternative to xp_cmdshell and BCP, do it with an SQL agent job - a jobstep copies 10,000 rows with an insert-select statement and some extra rows if the last or those rows is not the last (or only) row with particular values using another select statement, then writes a where I'm up to record, then perhaps delays for a time and then perhaps picks itself as next step (can't remember if you need two steps to do this - it's all so long ago), or it can put the copying and place marking and delay code in a while loop within the step, or can just exit (and take the next 10,000 rows when next it's scheduled). That too is old school that will still work.
Thanks for the input, both of you.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
GilaMonster (4/29/2016)
GilaMonster (4/27/2016)
BLOB_EATER (4/27/2016)
GilaMonster (4/26/2016)
BLOB_EATER (4/26/2016)
GilaMonster (4/26/2016)
SQLRNNR (4/26/2016)
The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according to Darth Sidious - the apprentice of Plagueis).If it is Plagueis it'll be a very nice connection.
If you haven't read the (now non-canon) book Darth Plagueis, do so. It's a fascinating story of Sidious's apprenticeship under Plagueis. Gives a much wider view into Sideous's machinations than the prequels did.
I'm going to look into this, the dark side intrigues me.
In that case, I'll recommend the title "Bane" too (the story of Darth Bane, the Sith Lord who instituted the Rule of Two after seeing in-fighting destroy the Sith Order that trained him)
Is there a specific order? Or am I good to go with either of the two?
They're set 1000 years apart.
I read Plagueis first, and only the first chapter so far of Bane
And I apologise, the title for the book about Darth Bane is "Path of Destruction"
cool thanks - time for me to get a kindle.
-
BLOB_EATER (4/29/2016)
GilaMonster (4/29/2016)
GilaMonster (4/27/2016)
BLOB_EATER (4/27/2016)
GilaMonster (4/26/2016)
BLOB_EATER (4/26/2016)
GilaMonster (4/26/2016)
SQLRNNR (4/26/2016)
The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according to Darth Sidious - the apprentice of Plagueis).If it is Plagueis it'll be a very nice connection.
If you haven't read the (now non-canon) book Darth Plagueis, do so. It's a fascinating story of Sidious's apprenticeship under Plagueis. Gives a much wider view into Sideous's machinations than the prequels did.
I'm going to look into this, the dark side intrigues me.
In that case, I'll recommend the title "Bane" too (the story of Darth Bane, the Sith Lord who instituted the Rule of Two after seeing in-fighting destroy the Sith Order that trained him)
Is there a specific order? Or am I good to go with either of the two?
They're set 1000 years apart.
I read Plagueis first, and only the first chapter so far of Bane
And I apologise, the title for the book about Darth Bane is "Path of Destruction"
cool thanks - time for me to get a kindle.
No need to buy a Kindle, you can use the apps for any device or the online reader on Amazon
😎
-
Eirikur Eiriksson (4/29/2016)
BLOB_EATER (4/29/2016)
GilaMonster (4/29/2016)
GilaMonster (4/27/2016)
BLOB_EATER (4/27/2016)
GilaMonster (4/26/2016)
BLOB_EATER (4/26/2016)
GilaMonster (4/26/2016)
SQLRNNR (4/26/2016)
The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according to Darth Sidious - the apprentice of Plagueis).If it is Plagueis it'll be a very nice connection.
If you haven't read the (now non-canon) book Darth Plagueis, do so. It's a fascinating story of Sidious's apprenticeship under Plagueis. Gives a much wider view into Sideous's machinations than the prequels did.
I'm going to look into this, the dark side intrigues me.
In that case, I'll recommend the title "Bane" too (the story of Darth Bane, the Sith Lord who instituted the Rule of Two after seeing in-fighting destroy the Sith Order that trained him)
Is there a specific order? Or am I good to go with either of the two?
They're set 1000 years apart.
I read Plagueis first, and only the first chapter so far of Bane
And I apologise, the title for the book about Darth Bane is "Path of Destruction"
cool thanks - time for me to get a kindle.
No need to buy a Kindle, you can use the apps for any device or the online reader on Amazon
😎
If you were looking for an excuse to buy a Kindle, then yes it's time to get one. Otherwise, I agree with Eirikur on this one. Far easier just to download the Kindle app for your phone, laptop, or other computing device and then just hook it up to your Amazon account.
If you don't have an Amazon account, then it is indeed time to get one. Unless you go to Barnes and Noble (my preferred book vendor), then you'll just need their Nook app instead of the Kindle app and an account with them.
-
Can someone help me with "hacking" the Script Job As Drop code?
I don't really want to hack MS's version so much as look at it and adapt it to my own custom proc.
-
BLOB_EATER (4/29/2016)
GilaMonster (4/29/2016)
GilaMonster (4/27/2016)
BLOB_EATER (4/27/2016)
GilaMonster (4/26/2016)
BLOB_EATER (4/26/2016)
GilaMonster (4/26/2016)
SQLRNNR (4/26/2016)
The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according to Darth Sidious - the apprentice of Plagueis).If it is Plagueis it'll be a very nice connection.
If you haven't read the (now non-canon) book Darth Plagueis, do so. It's a fascinating story of Sidious's apprenticeship under Plagueis. Gives a much wider view into Sideous's machinations than the prequels did.
I'm going to look into this, the dark side intrigues me.
In that case, I'll recommend the title "Bane" too (the story of Darth Bane, the Sith Lord who instituted the Rule of Two after seeing in-fighting destroy the Sith Order that trained him)
Is there a specific order? Or am I good to go with either of the two?
They're set 1000 years apart.
I read Plagueis first, and only the first chapter so far of Bane
And I apologise, the title for the book about Darth Bane is "Path of Destruction"
cool thanks - time for me to get a kindle.
I read all my kindle books on my iPad. I find the phone too small to read comfortably, but iPad is perfect size.
The book's available in paper too, I have the hard copy sitting next to me.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 53,836 through 53,850 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply