Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,671 through 11,685 (of 59,095 total)

RE: Jobs running indefinitely

Just a word of caution from a crusty ol' DBA that's long in tooth and has many battle scars...
Adding RAM is always nice but that may not 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)

August 3, 2018 at 9:01 am

#2000177
RE: How to set the primary key for each table

coolchaitu - Thursday, August 2, 2018 6:02 AM
Try writing a script using cursor
Why?
--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)

August 3, 2018 at 8:49 am

#2000173
RE: How to get a record if any of it's column values is set to true ?

jcelko212 32090 - Friday, August 3, 2018 8:38 AM
judejay26 - Tuesday, June 19, 2018 6:34 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)

August 3, 2018 at 8:44 am

#2000170
RE: Foreign Keys

HappyGeek - Friday, August 3, 2018 8:35 AM
Grant Fritchey - Friday, August 3, 2018 5:05 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)

August 3, 2018 at 8:41 am

#2000167
RE: Foreign Keys

Grant Fritchey - Friday, August 3, 2018 5:05 AM
HappyGeek - Thursday, August 2, 2018 10:18 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)

August 3, 2018 at 8:38 am

#2000166
RE: How to get a record if any of it's column values is set to true ?

Don't forget that, unless there's a NOT NULL constraint on these columns, a NULL could end up being the fly in the ointment.
--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)

August 2, 2018 at 8:07 pm

#2000107
RE: Need help to extract unstructured excel data to sql server

saptek9 - Thursday, August 2, 2018 7:22 AM
I have 12 different Excel files which are having multiple tabs in every file 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)

August 2, 2018 at 7:49 pm

#2000106
RE: Finding a String Anywhere in Another String

Heh... tough crowd! 😉 Have a good one!
--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)

August 2, 2018 at 7:30 pm

#2000097
RE: Finding a String Anywhere in Another String

hakan_l_borg - Wednesday, August 1, 2018 9:58 AM
Hi Luis, well the APS sure ships as a parallellism solution to query perf issues...
--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)

August 2, 2018 at 3:47 pm

#2000086
RE: Time Outs!!

I guess I'd do two things before any of that substantial deep diving...
1. Rebuild stats or at least make sure they've been rebuilt.
2. Check the indexes being...
--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)

August 2, 2018 at 3:30 pm

#2000084
RE: Finding a String Anywhere in Another String

Janeta Parakosova - Thursday, August 2, 2018 1:34 PM
Hi Jeff,
I used GUIDs to generate random strings with LEFT(NEWID(), 20) for the article....
--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)

August 2, 2018 at 2:07 pm

#2000078
RE: Foreign Keys

Grant Fritchey - Thursday, August 2, 2018 9:02 AM
Jeff Moden - Thursday, August 2, 2018 8:54 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)

August 2, 2018 at 1:20 pm

#2000066
RE: Variable assignments

lmalatesta - Thursday, August 2, 2018 11:03 AM
Jeff Moden - Monday, July 23, 2018 1:46 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)

August 2, 2018 at 1:17 pm

#2000063
RE: Finding a String Anywhere in Another String

Jeff Moden - Tuesday, July 31, 2018 12:09 PM
Janeta Parakosova - Tuesday, July 31, 2018 11:03 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)

August 2, 2018 at 1:10 pm

#2000061
RE: Finding a String Anywhere in Another String

hakan_l_borg - Thursday, August 2, 2018 12:09 AM
Thats not what I said either.
Understood but a whole lot of people take it 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)

August 2, 2018 at 9:02 am

#2000011

Viewing 15 posts - 11,671 through 11,685 (of 59,095 total)