Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,321 through 16,335 (of 59,067 total)

RE: Inline table-valued function to list numbers

p.s. First, thank you for wanting "hints" instead of a "solution". It absolutely demonstrates that you have the right stuff for database programming.
Second, because of your interest in...
--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)

November 11, 2016 at 8:12 pm

#1912021
RE: Inline table-valued function to list numbers

TheTrojan (11/11/2016)
Hi everyone,
I'm a newbie and recently I've come across an excercise quite complex (for me). In short, these are the requirements:
A - an inline table-valued function with 1 parameter...
--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)

November 11, 2016 at 7:51 pm

#1912020
RE: TSQL Formatting tool?

Eric M Russell (11/11/2016)
Jeff Moden (11/11/2016)
Eric Mamet (11/10/2016)
Can someone recommend a (free?) tool to format TSQL Code.
Ideally, it should be something working in both SSMS and Visual Studio (SSDT)...
--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)

November 11, 2016 at 7:17 pm

#1912019
RE: TSQL Formatting tool?

Eric Mamet (11/10/2016)
Can someone recommend a (free?) tool to format TSQL Code.
Ideally, it should be something working in both SSMS and Visual Studio (SSDT) as we use both 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)

November 11, 2016 at 12:57 pm

#1911994
RE: Inserting records failing everyday

EasyBoy (11/8/2016)
We have one schedule job which dropping and inserting records into table on daily basis. But this job is failing due to "Could not allocate space for object...
--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)

November 11, 2016 at 12:50 pm

#1911991
RE: Substring a value after a period

hoseam (11/11/2016)
I get string values as input, e.g 'Documentation.Account', whatever value I get I want to extract it to get anything after a period(.) e.g'Account' I was thinking of using...
--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)

November 11, 2016 at 12:44 pm

#1911988
RE: Deployment Solutions that include Data?

If RedGate Data Compare is used against relatively small amount of reference data, then it works just fine. The problem is that they generate data scripts that are RBAR...
--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)

November 11, 2016 at 12:33 pm

#1911986
RE: Back-to-Back Version of SQL Server

Saurabh.D (11/10/2016)
Hi,
Not Sure, right place to ask.
I am very new to SQL Server.
Why Microsoft release Back-to-Back version of SQL Server...
--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)

November 11, 2016 at 12:27 pm

#1911985
RE: Go Code

I don't believe that everyone can be taught to code simply because it's not something that some people actually have an interest in doing. There are also those 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)

November 11, 2016 at 12:20 pm

#1911981
RE: Are the posted questions getting worse?

Lynn Pettis (11/10/2016)
Jeff Moden (11/9/2016)
Lynn Pettis (11/9/2016)
Jeff, I actually excepted you to have some interesting comments about the code I emailed you, or didn't you get it?
Ah. sorry. 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)

November 10, 2016 at 12:25 pm

#1911758
RE: How to use a CSV as parameter in a query

Eirikur Eiriksson (11/10/2016)
Further on the fixed width method, here is an example, 100 x more efficient than XML and roughly 4-8 x more efficient than DelimitedSplit8K.
😎
I have proven many times...
--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)

November 10, 2016 at 5:50 am

#1911626
RE: How to use a CSV as parameter in a query

Henk Schreij (11/10/2016)
It's the company policy that the DB is used for storing the tables (with FK's including cascades, defaults). But no stored procedures or functions.
Yowch!. I did some...
--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)

November 10, 2016 at 5:46 am

#1911623
RE: Are the posted questions getting worse?

Lynn Pettis (11/9/2016)
Jeff, I actually excepted you to have some interesting comments about the code I emailed you, or didn't you get it?
Ah. sorry. I did see it and...
--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)

November 9, 2016 at 8:39 pm

#1911524
RE: is it possible to determine the max length of a field in a csv file?

Alan.B (11/9/2016)
Jeff Moden (11/8/2016)
Alan.B (11/8/2016)
You can accomplish this using NGrams2B which can be downloaded from here[/url] at the end of the article.).
I must be tired and I'm not seeing...
--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)

November 9, 2016 at 8:36 pm

#1911523
RE: Are the posted questions getting worse?

Brandie Tarvin (11/9/2016)
Eirikur Eiriksson (11/9/2016)
No offence Jeff, just thought this was funny
😎
That is kind of funny.
Base 36 is f____g funny. 😉 Saw that when I was looking at an...
--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)

November 9, 2016 at 5:06 pm

#1911518

Viewing 15 posts - 16,321 through 16,335 (of 59,067 total)