Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,411 through 7,425 (of 59,091 total)

Reply To: Combining many crossing intervals

Thanks for the feedback. How did you load the polygon information for the test. I'm not so familiar with it and it seems like it only takes literal strings 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)

April 3, 2020 at 2:38 pm

#3740229
Reply To: before update trigger on sql server

BWAAA-HAAA!!! Whew! I feel much better about what you're doing now. Thanks for the feedback, Albert.
--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)

April 3, 2020 at 2:34 pm

#3740227
Reply To: mass null replace in a query.

Lee Hopkins wrote:
It resides in a table, I really done want to do isnull() on all fields but if i have to?
The reason why I asked what you're doing the conversion...
--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)

April 2, 2020 at 4:51 pm

#3740027
Reply To: mass null replace in a query.

Lee Hopkins wrote:
I have some data that i have no control over (third party supplying the data). I am extracting it to a CSV but the end user does not want...
--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)

April 2, 2020 at 3:28 pm

#3740013
Reply To: ghost cleanup blocks checkpoint

BernardoGasca wrote:
This is old but Maybe it will help someone. I had the same issue, a ghost clean up spid was blocking backup jobs and checkpoints at times. When I...
--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)

April 2, 2020 at 3:25 pm

#3740012
Reply To: before update trigger on sql server

albertht1987 wrote:
In users I have two fields: name which is primary key and password.
You may have a much larger issue on your hands. Are the passwords in clear text or...
--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)

April 2, 2020 at 3:22 pm

#3740011
Reply To: Delete Duplicates from table based on two columns

I wonder how you got a "Jeff Query" out of this thread. I don't have any code posted. 😉
--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)

April 2, 2020 at 3:01 pm

#3740007
Reply To: Collections: Computed gaps for continuous numbers

Unfortunately, they'd probably say the same things they said on the CONNECT site for years and years and they are now saying on the FEEDBACK site. "Works as designed" or...
--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)

April 2, 2020 at 2:57 pm

#3740006
Reply To: Shrinking _log file for live database

Actually, there IS a problem with having a large log file and that would be the sometimes huge amount of extra time a RESTORE would take. Restoring a log file...
--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)

April 1, 2020 at 10:36 pm

#3739838
Reply To: Unexcpted erorrs restoring large tables

What are the exact errors that you're seeing? (Copy'n'Paste, please)

--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)

April 1, 2020 at 6:19 pm

#3739754
Reply To: SA account locked out/Single user turned on/SQL Server Agent stopped

jensohl94 wrote:
Update.....I'm staying up watching the logs! Just saw something in there. Invalid login with the admin account to ReportServer. Guessing this in an SSRS thing? Have had issues with...
--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)

April 1, 2020 at 6:17 pm

#3739753
Reply To: Force job to fail based on condition of IF

You should be able to use RAISERROR with a severity of, say, 16. Please see the following for more info on RAISERROR.
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/raiserror-transact-sql?view=sql-server-ver15
--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)

April 1, 2020 at 6:14 pm

#3739751
Reply To: Cursors Without Performance Penalties

From a lot of the code I've seen, no refactoring would be necessary. 😀
--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)

April 1, 2020 at 6:01 pm

#3739737
Reply To: Calculating Easter in SQL

I saw those in your code. Like I said, well done on the article. I've not seen such a collection of methods for calculating what Easter Day is all in...
--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)

April 1, 2020 at 4:48 pm

#3739714
Reply To: Collections: Computed gaps for continuous numbers

Thanks. I was coming up against the very same thing and I was trying to avoid the use of any form of dynamic SQL. For now, that seems improbable at...
--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)

April 1, 2020 at 4:42 pm

#3739713

Viewing 15 posts - 7,411 through 7,425 (of 59,091 total)