Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,641 through 20,655 (of 59,072 total)

RE: Finding out Total Disk Space in TSQL

Steve Jones - SSC Editor (1/15/2015)
JimAtWork (2/3/2014)
I have the same challenge and I have to query thousands of servers many of which do not allow the use of OA_ 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)

May 20, 2015 at 10:29 am

#1799377
RE: Sql Job to send results

ramana3327 (5/14/2015)
Hi,
I want to run this below query on scheduled basis and send the result to me through Sql job. It is running but not sending any result
How to set...
--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 7:06 pm

#1799211
RE: How to create numerous directories on a server using data from sql table

GF (5/19/2015)
Update on this adventure.
I have created all the folders I need to based on a list I generated from a SQL table.
FOR /F %i in (E:\documents\folderlist.txt) do md "%i"
Now...
--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:52 pm

#1799209
RE: Unused,duplicate indexes

tcronin 95651 (5/19/2015)
i would look at ozar's index routine and use that.
Link?
--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:04 pm

#1799205
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

Viewing 15 posts - 20,641 through 20,655 (of 59,072 total)