Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,161 through 11,175 (of 59,099 total)

RE: How to get output of SP_HELP_JOB into a script?

prakashanand2223 - Saturday, September 22, 2018 1:13 AM
Jen-169507 - Thursday, February 16, 2006 8:58 PM
--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)

September 22, 2018 at 7:48 am

#2006647
RE: Convert Date

Lynn Pettis - Friday, September 21, 2018 9:42 AM
craig.jenkins - Friday, September 21, 2018 8:18 AM
--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)

September 21, 2018 at 10:06 pm

#2006643
RE: Which data to baseline before and after adding an index

webrunner - Friday, September 21, 2018 8:20 AM
Hello experts,
While troubleshooting a poorly performing query, I was able to have some success 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)

September 21, 2018 at 9:59 pm

#2006642
RE: Convert Date

Jonathan AC Roberts - Friday, September 21, 2018 9:04 AM
Jeff Moden - Friday, September 21, 2018 8:41...
--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)

September 21, 2018 at 9:22 am

#2006589
RE: Obfuscating values (via T-SQL) in several Varchar, Char, and Datetime columns ?

VoldemarG - Wednesday, September 19, 2018 1:26 PM
Is there any good T-SQL solution that you can recommend for obfuscating a dozen 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)

September 21, 2018 at 8:52 am

#2006585
RE: Fitting Into RAM

Summer90 - Friday, September 21, 2018 8:12 AM
Reminds me of a previous boss of mine in the 1990s when talking about...
--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)

September 21, 2018 at 8:48 am

#2006583
RE: Convert Date

below86 - Friday, September 21, 2018 7:50 AM
You could try this:
CONVERT(CHAR(11), DateIn, 107) AS DateIn
107 is going to have a comma 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)

September 21, 2018 at 8:47 am

#2006582
RE: Convert Date

Jonathan AC Roberts - Friday, September 21, 2018 7:06 AM
craig.jenkins - Friday, September 21, 2018 6:53 AM
--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)

September 21, 2018 at 8:41 am

#2006581
RE: Creating Strings with Replicate

roger.plowman - Friday, September 21, 2018 8:14 AM
See, this is proof T/SQL is insane and full of gotchas. There is no reason replicate()...
--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)

September 21, 2018 at 8:30 am

#2006579
RE: Loading CSV Files Using Dynamic SQL

i_love_data - Wednesday, September 19, 2018 7:59 AM
Has anyone managed to load a large file like that? I tried with a file...
--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)

September 21, 2018 at 8:18 am

#2006575
RE: Loading CSV Files Using Dynamic SQL

sgtidwell - Thursday, September 20, 2018 6:43 AM
Bruin - Tuesday, September 18, 2018 5:31 PM
--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)

September 21, 2018 at 8:15 am

#2006572
RE: Loading CSV Files Using Dynamic SQL

Bruin - Friday, September 21, 2018 3:23 AM
sgtidwell - Thursday, September 20, 2018 6:43 AM
--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)

September 21, 2018 at 8:14 am

#2006571
RE: Loading CSV Files Using Dynamic SQL

Bruin - Tuesday, September 18, 2018 5:31 PM
How does the process work\handle(using format file) with truncation of a field in csv larger...
--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)

September 21, 2018 at 8:13 am

#2006569
RE: Fitting Into RAM

We have a couple of 2.2 TB database and it's that large because of a very common problem in the industry... people use RDBMSs as a "keep it forever" file system. 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)

September 21, 2018 at 8:05 am

#2006563
RE: create a button that will run a query and export it to excel

Give the users a spreadsheet where they can click a button, have it run a stored procedure, and put the results in the same spreadsheet. Removes the onus from you...
--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)

September 21, 2018 at 6:59 am

#2006542

Viewing 15 posts - 11,161 through 11,175 (of 59,099 total)