April 27, 2016 at 1:10 am
Steve Jones - SSC Editor (4/26/2016)
rodjkidd (4/26/2016)
TomThomson (4/26/2016)
Steve Jones - SSC Editor (4/26/2016)
See you there, and...
you have a car? I thought everyone in the UK just used trains.
Trains? UK rail fares are by far the highest in Europe - for most journeys train is far more expensive and far less convenient than car (unless of course the journey by car involves spending hours driving through stop go average speed < 5mph traffic jams). A lot of people use cars in preference to trains.
If it wasn't for it being 5 cities (including home) in 8 days and I'd have to drive down the M6 on a Friday.
I would have driven. At least this way I can sit and read on the train.
But as a general rule I avoid trains in UK.
Rodders...
Great, and I'll be making my way up from LHR to Liverpool on Thur via train.
You'll be fine Steve :w00t:
Rodders...
April 27, 2016 at 3:42 am
Steve Jones - SSC Editor (4/26/2016)
rodjkidd (4/26/2016)
TomThomson (4/26/2016)
Steve Jones - SSC Editor (4/26/2016)
See you there, and...
you have a car? I thought everyone in the UK just used trains.
Trains? UK rail fares are by far the highest in Europe - for most journeys train is far more expensive and far less convenient than car (unless of course the journey by car involves spending hours driving through stop go average speed < 5mph traffic jams). A lot of people use cars in preference to trains.
If it wasn't for it being 5 cities (including home) in 8 days and I'd have to drive down the M6 on a Friday.
I would have driven. At least this way I can sit and read on the train.
But as a general rule I avoid trains in UK.
Rodders...
Great, and I'll be making my way up from LHR to Liverpool on Thur via train.
Yeah, me too. I thought that was the way to get it done.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2016 at 3:43 am
rodjkidd (4/27/2016)
Steve Jones - SSC Editor (4/26/2016)
rodjkidd (4/26/2016)
TomThomson (4/26/2016)
Steve Jones - SSC Editor (4/26/2016)
See you there, and...
you have a car? I thought everyone in the UK just used trains.
Trains? UK rail fares are by far the highest in Europe - for most journeys train is far more expensive and far less convenient than car (unless of course the journey by car involves spending hours driving through stop go average speed < 5mph traffic jams). A lot of people use cars in preference to trains.
If it wasn't for it being 5 cities (including home) in 8 days and I'd have to drive down the M6 on a Friday.
I would have driven. At least this way I can sit and read on the train.
But as a general rule I avoid trains in UK.
Rodders...
Great, and I'll be making my way up from LHR to Liverpool on Thur via train.
You'll be fine Steve :w00t:
Rodders...
And you do have a car. A nice one. Wheels and everything.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 27, 2016 at 3:49 am
Grant Fritchey (4/27/2016)
rodjkidd (4/27/2016)
Steve Jones - SSC Editor (4/26/2016)
rodjkidd (4/26/2016)
TomThomson (4/26/2016)
Steve Jones - SSC Editor (4/26/2016)
See you there, and...
you have a car? I thought everyone in the UK just used trains.
Trains? UK rail fares are by far the highest in Europe - for most journeys train is far more expensive and far less convenient than car (unless of course the journey by car involves spending hours driving through stop go average speed < 5mph traffic jams). A lot of people use cars in preference to trains.
If it wasn't for it being 5 cities (including home) in 8 days and I'd have to drive down the M6 on a Friday.
I would have driven. At least this way I can sit and read on the train.
But as a general rule I avoid trains in UK.
Rodders...
Great, and I'll be making my way up from LHR to Liverpool on Thur via train.
You'll be fine Steve :w00t:
Rodders...
And you do have a car. A nice one. Wheels and everything.
And I didn't have to pay extra for the wheels either 😉
Rodders...
April 27, 2016 at 5:12 am
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 27, 2016 at 8:11 am
TomThomson (4/26/2016)
Steve Jones - SSC Editor (4/26/2016)
See you there, and...
you have a car? I thought everyone in the UK just used trains.
Trains? UK rail fares are by far the highest in Europe - for most journeys train is far more expensive and far less convenient than car (unless of course the journey by car involves spending hours driving through stop go average speed < 5mph traffic jams). A lot of people use cars in preference to trains.
I thought that's why they built all those bus lanes on the M4... (duck)
April 27, 2016 at 1:08 pm
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
If you are a chronological nut, then Bane first. 😀
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
April 28, 2016 at 2:43 am
Brandie Tarvin (4/27/2016)
TomThomson (4/26/2016)
Steve Jones - SSC Editor (4/26/2016)
See you there, and...
you have a car? I thought everyone in the UK just used trains.
Trains? UK rail fares are by far the highest in Europe - for most journeys train is far more expensive and far less convenient than car (unless of course the journey by car involves spending hours driving through stop go average speed < 5mph traffic jams). A lot of people use cars in preference to trains.
I thought that's why they built all those bus lanes on the M4... (duck)
Oh do you mean the Olympic lane? Well it's still coloured differently, but you don't get many buses using it now 😉
Rodders...
April 28, 2016 at 2:54 am
SQLRNNR (4/27/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
If you are a chronological nut, then Bane first. 😀
I am slowly starting to understand the power of the dark side...
April 28, 2016 at 3:24 am
BLOB_EATER (4/28/2016)
SQLRNNR (4/27/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
If you are a chronological nut, then Bane first. 😀
I am slowly starting to understand the power of the dark side...
Stop right there Blobby, our poor planet's in deep enough sh1t as it is.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
April 28, 2016 at 6:03 am
ChrisM@Work (4/28/2016)
BLOB_EATER (4/28/2016)
SQLRNNR (4/27/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
If you are a chronological nut, then Bane first. 😀
I am slowly starting to understand the power of the dark side...
Stop right there Blobby, our poor planet's in deep enough sh1t as it is.
Well this is what happens when I get refused into the Jedi's council!
April 28, 2016 at 7:43 am
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!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2016 at 7:53 am
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!
1) What do you mean by "large" amount of data? How many millions of rows and/or how many GB?
2) What is the ultimate goal here? What are you doing with the exported data?
3) Is this a one-time deal or will it be an on going process?
4) Is the data straight from a single table, or a query combining columns from multiple tables, or a subset of fields from a single table?
5) If from a single table, are you wanting 100% of the rows? And if yes, is there an INT / BIGINT PK on the table?
6) Not SSIS is fine, but does it have to be SQLCMD?
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
April 28, 2016 at 8:01 am
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!
Sure. Do the following.
Send me an email to IMNotAPhisher@brandie.com with your full name, social security number, credit card number, CCV, expiration date, and birth date.
As soon as I get that information, I'll post all the links you want.
April 28, 2016 at 8:01 am
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!
Table and index ddl, sample table scripts and execution plans please.
RVVVVVF from Scary
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
Viewing 15 posts - 53,806 through 53,820 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply