Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,671 through 20,685 (of 59,098 total)

RE: Join

sharonsql2013 (5/18/2015)
Is it possible to join based on conditions
I am trying to join Project_Code with Manager.Code but if the project_code is blank then it should look for Project_CostCenter and Join...
--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)

May 19, 2015 at 6:01 pm

#1799204
RE: how to run a transaction accross multipale instance of sqlserver without linked server

rajemessage 14195 (5/19/2015)
Basically i want to run a transaction between two different instance of server,
so that i can rollback task done at both the instances when ever i want.
To be...
--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)

May 19, 2015 at 5:36 pm

#1799202
RE: Documenting with Tests

PHYData DBA (5/19/2015)
Gail Wanabee (5/17/2015)
I've worked in shops where formal documentation was required for all code and it had to be maintained.
I've worked in shops where developers insisted 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)

May 19, 2015 at 4:57 pm

#1799200
RE: Contiguous time slots

@eirk tsomik,
I'm not sure why but it looks like 3 posts where you posted some readily consumable code were deleted by that autospam detector or an over-zealous monitor. 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)

May 19, 2015 at 4:50 pm

#1799199
RE: Testing Simple Calculations and UDFs with tSQLt

Steve Jones - SSC Editor (5/19/2015)
Jeff Moden (5/18/2015)
I did say that most UDFs would never be updated, not all but, let's ask the question.
How many UDFs that were already 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)

May 19, 2015 at 12:21 pm

#1799129
RE: Testing Simple Calculations and UDFs with tSQLt

I agree but why does one need the extra layer of tSqLt? DelimitedSplit8k even has two different tests built into the header so they won't get lost.
--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)

May 19, 2015 at 9:03 am

#1799052
RE: How to target files in a certain sub dir with get-childitem

jzieleniuk (5/19/2015)
We receive files with spaces and i want to replace those spaces with dashes...
Why? There should be no problem with handling files with spaces. You just need...
--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)

May 19, 2015 at 9:01 am

#1799050
RE: Usage of CTE - Trick with Dates

Iwas Bornready (5/18/2015)
Recursion can be dangerous but I agree, sometimes very helpful.
Do you have any examples of where it was helpful?
--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)

May 18, 2015 at 4:46 pm

#1798868
RE: Testing Simple Calculations and UDFs with tSQLt

I did say that most UDFs would never be updated, not all but, let's ask the question.
How many UDFs that were already in production have you actually updated?
--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)

May 18, 2015 at 4:44 pm

#1798867
RE: Redgate Backup

ramana3327 (5/17/2015)
It included the new database also.
I am looking to set up the differential backup. I will look in to the documentation. Thanks for providing the documentation
Just a word...
--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)

May 18, 2015 at 4:31 pm

#1798863
RE: Boring or Scripting

Steve Jones - SSC Editor (5/18/2015)
Plus it's a skill that can help you work in Exchange, AD, Windows, etc if you get called to help out.
Heh... yet another excellent...
--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)

May 18, 2015 at 4:21 pm

#1798862
RE: Boring or Scripting

xsevensinzx (5/18/2015)
Jeff Moden (5/18/2015)
TomThomson (5/18/2015)
Jeff Moden (5/17/2015)
Heh... I look at the recommendations for "scripting" languages with a bit of disgust. There are so many things that SQL Server does...
--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)

May 18, 2015 at 4:18 pm

#1798860
RE: Need Ammunition for Developers Doing Select *'s

Vyper426 (5/18/2015)
Ed Wagner (5/15/2015)
A SELECT * in a cursor...So that means if a column is added to a table the system uses, the interface breaks at every point where it...
--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)

May 18, 2015 at 4:09 pm

#1798858
RE: Formatting a email from a SQL job

You can also get a decent example right out of "Books Online". Lookup sp_send_dbmail and look at the last example.
--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)

May 18, 2015 at 3:51 pm

#1798857
RE: Testing Simple Calculations and UDFs with tSQLt

Great article. I'm just not sure why anyone needs to use tSQLt for such a thing. It seems like an extra layer that's not needed. There's also...
--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)

May 18, 2015 at 3:43 pm

#1798855

Viewing 15 posts - 20,671 through 20,685 (of 59,098 total)