Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,401 through 20,415 (of 59,072 total)

RE: Just want to make sure I have my facts straight about autogrowth.

Duran (6/10/2015)
Hi Jeff,
Thanks for the reply, you mentioned that it depended on a couple of things, in a nutshell, what are those things?
Regards,
D.
Pretty much what I said in my previous...
--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)

June 10, 2015 at 8:03 am

#1804351
RE: Parsing large varbinary fields

Tom_Sacramento (6/10/2015)
He Jeff,
The primary key is a GUID called ID - not my idea, but this is an inherited database...
What I need is a count of each of the 3...
--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)

June 10, 2015 at 7:39 am

#1804338
RE: SELECT INTO vs INSERT INTO on Columnstore

PatrickSimons (6/10/2015)
Jeff Moden (6/9/2015)
PatrickSimons (6/9/2015)
I agree 100%. Especially when you SELECT INTO inside a transaction to a temporary table (##) = worst case....
What problems have you had there? Or...
--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)

June 10, 2015 at 7:37 am

#1804336
RE: SELECT INTO vs INSERT INTO on Columnstore

r.e.kiser (6/10/2015)
It's my understanding that SELECT INTO locks one or more system database tables until the data completes loading, thus preventing any other user on the entire server instance from...
--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)

June 10, 2015 at 7:33 am

#1804334
RE: Like to have data returned in 1 row vs. multiple rows

David Burrows (6/10/2015)
Jeff Moden (6/9/2015)
Is the number of columns in the final output a given or do we have to have the code figure that out?
Shouldn't that be max number...
--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)

June 10, 2015 at 7:22 am

#1804328
RE: SQL Server Data Lost on User DB's

ericpap (6/8/2015)
I'm facing a very complex situation with my software databases on a specific server. This is the second time this problem happend on this server. Basically while user where...
--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)

June 10, 2015 at 12:45 am

#1804217
RE: SQL 2014 is running slower than SQL 2008

I know it doesn't help except that misery loves company. I've never seen a new revision of SQL Server where there weren't some horrible slowdowns even if you did...
--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)

June 10, 2015 at 12:41 am

#1804216
RE: Replicating table A into table B within the same database

I have to ask the question, please. Why is there a need to replicate a table to the same database? What is the reason?
--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)

June 10, 2015 at 12:38 am

#1804215
RE: SELECT INTO vs INSERT INTO on Columnstore

ramya.sqlservr (6/9/2015)
Jeff Moden (6/9/2015)
The scenario descriptions in the final chart of the article also don't seem to match the actual scenario descriptions in the text of the article. That...
--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)

June 9, 2015 at 11:35 pm

#1804204
RE: SELECT INTO vs INSERT INTO on Columnstore

BTW, if anyone wants some official MS documentation on the subject, please see the following article.
FIX: SELECT INTO Locking Behavior
Also notice the line where it says that this isn't a...
--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)

June 9, 2015 at 11:32 pm

#1804203
RE: SELECT INTO vs INSERT INTO on Columnstore

PatrickSimons (6/9/2015)
I agree 100%. Especially when you SELECT INTO inside a transaction to a temporary table (##) = worst case....
What problems have you had there? Or are you citing...
--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)

June 9, 2015 at 10:29 pm

#1804198
RE: SELECT INTO vs INSERT INTO on Columnstore

Thordog (6/9/2015)
SELECT INTO does place locks on system metadata, which can cause issues for users, until the SELECT INTO completes. INSERT INTO can be minimally logged by using a...
--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)

June 9, 2015 at 10:26 pm

#1804197
RE: Just want to make sure I have my facts straight about autogrowth.

It depends on a couple of things but, generally speaking and considering the size of today's databases, auto incrementing by 1MB is a horrible thing to do especially with the...
--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)

June 9, 2015 at 10:17 pm

#1804196
RE: Insert without a PK

I have to say that this is one of the weirdest set of answers I've ever seen. This is the reason why I don't take certification tests. 😛
I...
--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)

June 9, 2015 at 10:12 pm

#1804195
RE: Delimiters - Importing Data - SQL Server Import Wizard

Despite the whacko delimiters, importing this will be a breeze (looks like the ol' AT&T junk I used to have to load from tape). You just can't use (IIRC)...
--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)

June 9, 2015 at 9:57 pm

#1804193

Viewing 15 posts - 20,401 through 20,415 (of 59,072 total)