Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,436 through 18,450 (of 59,070 total)

RE: storedprocedure to run a sql file(abc.sql) and store result in a file(abc.txt)

Steve Jones - SSC Editor (2/4/2016)
sqlcmd -S servername -E -d Databasename -i c:\abc.sql -o c:\abc.txt
You can also substitute a ">" for the "-o". It will cause the file 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)

February 4, 2016 at 6:53 pm

#1856733
RE: Starting over after a long absense, Advice?

ulrichrpu (2/4/2016)
I can't do the work I once did, it will literally kill me...
First of all, hat's off to you for trying. Never cut yourself down because of such...
--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)

February 4, 2016 at 6:07 pm

#1856728
RE: Total time jobs run on a day

river1 (2/4/2016)
Hello,
Thank you for the replies.
I would like to get the time that each [font="Arial Black"]job [/font]took per day to execute. This cam be done on a month analysis....
--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)

February 4, 2016 at 5:58 pm

#1856727
RE: Get list of months, monthname and Year

sandeepmittal11 (2/4/2016)
Agree with Jeff, but i think it would not make much difference when you have such small list of data
"It Depends". You have to take into consideration how...
--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)

February 4, 2016 at 7:24 am

#1856529
RE: CHARINDEX in reverse

Jeff Moden (7/6/2009)
Sergiy (7/5/2009)
Jeff Moden (7/2/2009) Andrew already did exactly what I would do...
I would not.
There was a member of Led Zeppelin, John Paul Jones.
Would not be happy 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)

February 3, 2016 at 9:43 am

#1856341
RE: Reducing transaction log disk space

dembis (2/2/2016)
I do not really care about the transaction logs. In fact the main database is on simple mode. For the replication, preferably, I would not like to lose anything.
Actually,...
--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)

February 2, 2016 at 3:32 pm

#1856138
RE: Find and Remove Duplicate Records SQL Server

andy_111 (1/31/2016)
Not really useful article.
Not really a useful comment, either. Please explain why you think it's not useful.
--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)

February 2, 2016 at 11:03 am

#1856054
RE: truncating and sizing log files

Just to add to what's already been recommended, how often do you take log file backups?
--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)

February 2, 2016 at 8:40 am

#1856008
RE: Reducing transaction log disk space

dembis (2/2/2016)
Hey guys,
I have many databases pointing their transaction logs to a same location (G: drive in my case). I would like to reduce the size of G: thru vmware...
--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)

February 2, 2016 at 8:35 am

#1856005
RE: House Keeping - Statistics

NicHopper (2/1/2016)
I've taken so much from this site and the SQLcommunity that it be my pleasure to try and put something back by contributing.
I'll get something typed up and submitted.
Thanks,
Nic
Very...
--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)

February 1, 2016 at 11:13 pm

#1855910
RE: Flag Values Based on Columns

Eirikur Eiriksson (1/27/2016)
Jeff Moden (1/26/2016)
I'd take some heart in what was said as mean as it sounded. We have quick posts that don't survive the future and people saying...
--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)

February 1, 2016 at 11:10 pm

#1855909
RE: Pivoting Problem" in "Development - SQL Server 2014"

It is my fault. I was deleting SPAM and hit the wrong thread. I've sent an email to the WebMaster asking if he could undelete 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)

January 31, 2016 at 1:17 pm

#1855572
RE: Help with xp_cmdshell folder creation

Whyy wouldn't you just change all your VARCHAR variable definitions to 8000 and do the same thing for the sub and sub sub folders?
--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)

January 31, 2016 at 11:33 am

#1855570
RE: Are the posted questions getting worse?

Hugo Kornelis (1/31/2016)
Jeff Moden (1/31/2016)
Hugo Kornelis (1/31/2016)
Ed Wagner (1/30/2016)
The articles and discussion on this site are top-notch.
I am once more going to be contrary. But let me start 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)

January 31, 2016 at 9:48 am

#1855563
RE: Are the posted questions getting worse?

Hugo Kornelis (1/31/2016)
Ed Wagner (1/30/2016)
The articles and discussion on this site are top-notch.
I am once more going to be contrary. But let me start with the positive: a lot of...
--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)

January 31, 2016 at 8:36 am

#1855559

Viewing 15 posts - 18,436 through 18,450 (of 59,070 total)