Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,301 through 15,315 (of 59,097 total)

RE: Help with trigger transaction

Your existence check using SELECT COUNT(*) is horribly expensive and is the likely cause of many of your problems. Change it to the appropriate IF EXISTS() as a starting point.
--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)

March 31, 2017 at 7:54 pm

#1936099
RE: Are the posted questions getting worse?

Crud. I guess I blew it. Today was the last day to submit contributions for MVP renewal. I went to update my profile at 8:30PM and it won't take any...
--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)

March 31, 2017 at 7:44 pm

#1936098
RE: Do it all in C# instead?

I'm curious. What is this supposedly complicated process?
--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)

March 31, 2017 at 4:01 pm

#1936091
RE: Determine average

crowegreg - Friday, March 31, 2017 12:46 PM
Attached is an export of the table into an excel spreadsheet.
For report week Mar 24th,...
--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)

March 31, 2017 at 3:55 pm

#1936090
RE: Adding $2 to a Price column?

I don't know if it has anything to do with the problem but why do you keep using string literals for columns that are not character based datatypes?
Heh......
--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)

March 31, 2017 at 3:53 pm

#1936089
RE: 'Spell check' a string-valued field

Alan.B - Thursday, March 30, 2017 8:49 PM
I don't know if what Jeff posted was helpful (another vanishing OP) but this is...
--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)

March 31, 2017 at 7:35 am

#1935976
RE: Bulk Insert a pipe delimited file into a temporary table

The reason it takes so long is because you're always loading the "TOP 1" file and there's nothing to end the loop. You've also got some other nuances in your...
--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)

March 30, 2017 at 9:49 pm

#1935900
RE: DBCC is running from 5 days

NorthernSoul - Thursday, March 30, 2017 12:51 PM
Jeff Moden - Thursday, March 30, 2017 8:37 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)

March 30, 2017 at 8:34 pm

#1935897
RE: SQL Server DBA Certification

SQLRNNR - Thursday, March 30, 2017 11:42 AM
smatu - Wednesday, March 29, 2017 3:34 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)

March 30, 2017 at 8:29 pm

#1935896
RE: How to join these tables together

jcelko212 32090 - Thursday, March 30, 2017 1:33 PM
A table must have a key, by definition. This key cannot be 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)

March 30, 2017 at 8:24 pm

#1935895
RE: Stored procedure parameters

That could definitely be a part of the problem. I definitely missed the obvious (choose 2) message and the fact that they were check boxes for answers instead of radio buttons. ...
--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)

March 30, 2017 at 7:45 pm

#1935894
RE: 'Spell check' a string-valued field

You're welcome. It might sound a bit strange but (I have no life 😉 ) thank you for the interesting problem.
--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)

March 30, 2017 at 7:32 pm

#1935893
RE: SQL Server DBA Certification

See the following.
https://www.microsoft.com/en-us/learning/sql-certification.aspx
In the process of becoming a DBA, make sure you know how to write code to get the current date an time. T-SQL is...
--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)

March 30, 2017 at 9:15 am

#1935753
RE: DBCC is running from 5 days

NorthernSoul - Thursday, March 30, 2017 2:34 AM
I notice you've raised another topic regarding memory pressure. Is this happening on the same...
--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)

March 30, 2017 at 8:37 am

#1935742
RE: Stored procedure parameters

I take exception to the supposed correct answer. If you have defaults on the parameters, input is not required. I agree... a bit of word play has come into this...
--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)

March 30, 2017 at 8:32 am

#1935739

Viewing 15 posts - 15,301 through 15,315 (of 59,097 total)