Jeff Moden

Forum Replies Created

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

RE: How to save jobs

In SSMS, you can click on the jobs folder of the Object Explorer (press the F8 key to get there if you don't already know how) and then press the F7...
--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:54 am

#2000194
RE: Inserting multiple rows of data in single temp table

Heh... I didn't see Drew's post because I had opened this thread and let it sit for a while. So sorry for the double post with the same answer.
--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:48 am

#2000191
RE: Foreign Keys

HappyGeek - Friday, August 3, 2018 8:51 AM
Jeff Moden - Friday, August 3, 2018 8:41 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 9:46 am

#2000190
RE: Inserting multiple rows of data in single temp table

The error message was telling you exactly what is wrong... you weren't using the VALUES Table Valued Constructor correctly. 😉

create table ##Test ([Primary KW] varchar...
--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:12 am

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

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