Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,281 through 17,295 (of 59,098 total)

RE: Execution plan differences in QA and Prod

You also need to make sure that statistics are up to date on the tables involved and you also need to consider differences in table volume and range(s) of data...
--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)

July 15, 2016 at 12:54 pm

#1890414
RE: t-sql large data size

@wendy,
I'll recommend again that you get a copy of Books Online (BOL for short) and use it. It clearly stated under the TEXT datatype that it is what has...
--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)

July 15, 2016 at 11:53 am

#1890387
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

asutorius (7/15/2016)
I was curious how these two concatenate examples compared in speed, I placed the examples in their own tabs in my local Sql Server 2014 and turned on Include...
--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)

July 15, 2016 at 11:11 am

#1890376
RE: Simple CLR request

Alan.B (7/12/2016)
CELKO (7/12/2016)
-1 is a wonderful answer.
To what? Who are you trying to communicate with here?
Mixed systems (those with more than one language embedded in each other) are always...
--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)

July 14, 2016 at 8:47 pm

#1890223
RE: Get start and end date row by row calculation based on duration

See this article (http://www.sqlservercentral.com/articles/T-SQL/61539/) for why Eirikur says "for small data sets". And it doesn't take many rows for the problem to become HUGE.
I don't, however, see this problem...
--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)

July 13, 2016 at 7:01 pm

#1889998
RE: Simple CLR request

Alan.B (7/13/2016)
CELKO (7/13/2016)
-1 is a wonderful answer. Mixed systems (those with more than one language embedded in each other) are always inefficient and a nightmare for anyone to read 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)

July 13, 2016 at 3:14 pm

#1889980
RE: which is better to user the cross join or while loop ?

ChrisM@Work (10/12/2012)
nitin.varshney (10/12/2012)
Hi
Please tell me which is better for the performance impact ?
1. Insert into #temp table Using the cross join with tables.
2. Insert into #temp table using 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)

July 13, 2016 at 2:32 pm

#1889970
RE: How to use a table value function that splits a string

NineIron (7/13/2016)
I have a TVF that takes two parameters, string and delimter but, I don't know how to pass the field values into the function in order to get my...
--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)

July 13, 2016 at 1:34 pm

#1889948
RE: Odd (to me) Behavior with NTILE() and NULL Values in Source Data

Alan.B (2/25/2016)
The NTally Inline Table Valued Function
N-I-I-I-I-C-E! Great documentation, too!
--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)

July 13, 2016 at 1:12 pm

#1889946
RE: A problem of concurrency on a small table

paolobianchi (7/13/2016)
Hi all,
i have a problem on an application.
Details:
Table AAA, about 500 records, not growing
Many users (about 100) make a read from this table, many times (about 120 times for...
--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)

July 13, 2016 at 10:22 am

#1889914
RE: Generate Repeating Set of Row_Number values

douglashwilliams (7/12/2016)
Hello -
I have a table that contains a set of rows, where each row can represent a query to run. I have an ETL process that I can...
--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)

July 12, 2016 at 6:41 pm

#1889749
RE: t-sql 2012 datatype

wendy elizabeth (7/12/2016)
In sql server 2012, I would like to know what datatype can hold the maximum number of characters? (The datatype will need to contain letters, numbers, and potentially...
--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)

July 12, 2016 at 5:32 pm

#1889746
RE: Sequential Numbers Joined to Serial Number Table

DarthBurrito (7/12/2016)
This works out perfectly. Thanks!
Since you're the one that will have to maintain it, do you understand it... perfectly?
--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)

July 12, 2016 at 5:25 pm

#1889745
RE: Not a DBA admin - How do i optimize/tune my queries, check on missing index?

HappyGeek (7/11/2016)
quentin.harris (7/8/2016)
True. It is a difficult place to be as a developer not sitting within the DBA/BI team but interfacing with their DW.
It seems to be a life...
--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)

July 12, 2016 at 4:47 pm

#1889744
RE: Combine rows into one row with line break by querying with XML

shogunSQL (7/12/2016)
Thank you very much All for your efforts.
I think I got it now. By replaceing ® sign where Char(10) is, The ® sign is used as a trick...
--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)

July 12, 2016 at 4:14 pm

#1889742

Viewing 15 posts - 17,281 through 17,295 (of 59,098 total)