Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,841 through 9,855 (of 59,093 total)

RE: Sort already comma separated list

patrickmcginnis59 10839 - Thursday, February 7, 2019 4:12 PM
Jeff Moden - Tuesday, February 5, 2019 7:39 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)

February 7, 2019 at 7:34 pm

#2021454
RE: Backup and log

mdube 62615 - Thursday, February 7, 2019 9:11 AM
Jeff, your knowledge on the subjet are impressive. Thanks a lot for your time, 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 7, 2019 at 9:25 am

#2021414
RE: How can I export all table names plus column names from sql?

Heh... and Sue also teaches how to unsnarl the reel! 😀
--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 7, 2019 at 9:15 am

#2021410
RE: How can I export all table names plus column names from sql?

deb.pabst - Thursday, February 7, 2019 7:54 AM
Does anyone know how to add schema to the query?
With the idea of teaching someone...
--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 7, 2019 at 8:25 am

#2021397
RE: Laptop Cooling Device with Docking Station

Sean Perkins - Monday, February 4, 2019 7:32 AM
Does anybody know of a cooling device that is big enough to cool a...
--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 7, 2019 at 8:08 am

#2021395
RE: Output of stored procedure to a txt file??

pietlinden - Thursday, January 31, 2019 6:12 PM
Umm... that post you're adding to is SEVENTEEN YEARS old.
How about...
https://sqlwithmanoj.com/tag/bcp-queryout/
Heh... ya gotta admit,...
--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 7, 2019 at 8:05 am

#2021393
RE: shrink tran log on production server

kevin.j.sexton - Thursday, February 7, 2019 6:19 AM
If I find a database with a 2GB data file and a 50 GB log...
--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 7, 2019 at 7:51 am

#2021388
RE: upgrade to 2016 causing performance problems

MJ-1115929 - Wednesday, February 6, 2019 4:07 AM
Eirikur Eiriksson - Tuesday, February 5, 2019 7:06 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)

February 7, 2019 at 6:46 am

#2021373
RE: Tuning Query In Stored Procedure

Grant Fritchey - Thursday, February 7, 2019 4:19 AM
Jeff Moden - Wednesday, February 6, 2019 11:06 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)

February 7, 2019 at 6:40 am

#2021371
RE: Level 1: The Basic SELECT Statement

Good lord. I clicked on the link and it took me to codeplex, which says that it "is still available" if you click on a certain link which takes 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)

February 6, 2019 at 11:28 pm

#2021342
RE: Tuning Query In Stored Procedure

Grant Fritchey - Wednesday, February 6, 2019 6:22 AM
jkramprakash - Wednesday, February 6, 2019 6:16 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)

February 6, 2019 at 11:06 pm

#2021341
RE: Backup and log

p.s. If you can take advantage of some of the tricks I talked about including using ONLINE = OFF, your 7.5GB index should take about 43 seconds per REBUILD (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)

February 6, 2019 at 10:25 pm

#2021340
RE: Backup and log

mdube 62615 - Tuesday, February 5, 2019 9:11 AM
Jeff Moden - Tuesday, February 5, 2019 8:50 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)

February 6, 2019 at 10:21 pm

#2021339
RE: Easy (I think) mdf file size question

Despite the apparent knee jerk reactions by some in the face of large MDFs, Eddie is spot on.
I'll also state that a whole lot of data is "W.O.R.M"...
--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 6, 2019 at 9:49 pm

#2021338
RE: Level 1: The Basic SELECT Statement

imaaronacs - Wednesday, February 6, 2019 7:42 PM
Hello, I started working on this staircase and noticed the AdventureWorks database was used during...
--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 6, 2019 at 8:53 pm

#2021335

Viewing 15 posts - 9,841 through 9,855 (of 59,093 total)