Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,431 through 20,445 (of 59,098 total)

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
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (6/9/2015)
Jeff Moden (6/4/2015)
Shifting gears a bit...
Have any of you ever used a CTP of SQL Server to power your real production databases? Personally, 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 9:47 pm

#1804192
RE: Finding / getting in touch with recruiters?

jasona.work (6/9/2015)
Starting from the bottom:
Jeff: Yes, I'm currently up in Clinton Township.
As for the commute, Toledo would be a last-ditch resort, unless the telecommute option was on the table...
--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:38 pm

#1804191
RE: Should Salary Information Be Confidential?

TomThomson (6/9/2015)
Jeff Moden (6/9/2015)
Eric M Russell (6/9/2015)
Jeff Moden (6/8/2015)
...
I also won't work for a company that does intelligence or personality testing. Again, it has been a powerful indicator to...
--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:36 pm

#1804190
RE: Normalizing a database

madan.preeti2005 (6/9/2015)
Oh yes i forgot to mention that, once data is populated, indexes will be recreated. Do you think that will tune query to some extent?
Do you know how to...
--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 4:32 pm

#1804173

Viewing 15 posts - 20,431 through 20,445 (of 59,098 total)