Jeff Moden

Forum Replies Created

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

RE: Sort already comma separated list

jcelko212 32090 - Friday, February 8, 2019 2:04 PM
>> But to create a primary key with an int or bigint all 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 8, 2019 at 2:09 pm

#2021558
RE: Sort already comma separated list

jcelko212 32090 - Friday, February 8, 2019 12:42 PM
Jeff Moden - Tuesday, February 5, 2019 6:04 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 8, 2019 at 2:06 pm

#2021557
RE: Columnstore Indexes - do we need to perform any maintenance on them?

Grant Fritchey - Friday, February 8, 2019 6:47 AM
You are going to want to rebuild columnstore indexes on some sort of basis....
--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 8, 2019 at 9:36 am

#2021522
RE: How should I reserve a set of "next numbers"?

Chris Wooding - Friday, February 8, 2019 9:16 AM
The code in the sproc just does an update of column Last_Key on 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)

February 8, 2019 at 9:33 am

#2021521
RE: Sort already comma separated list

patrickmcginnis59 10839 - Thursday, February 7, 2019 8:25 PM
I've seen some of those concerns with purchase order number. Sometimes you have...
--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 8, 2019 at 7:24 am

#2021495
RE: Convert string MMDDYYYY to a date

below86 - Thursday, February 7, 2019 2:52 PM
Jeff Moden - Thursday, December 20, 2018 10:36 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 8:01 pm

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

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