Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,396 through 7,410 (of 59,072 total)

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
Reply To: Cursors Without Performance Penalties

latkinson wrote:
Good one. But sometimes I wish there was a better row by row method available for those few times when there appears to be no other option.
Luther
jarick 15608 wrote:
You got...
--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:34 pm

#3739711
Reply To: Cursors Without Performance Penalties

David.Poole wrote:
Don't get too comfortable Jeff. SQL Server on Linux was also a Steve Jones classic April Fool
Heh... I wasn't going to bring it up just for that reason. 😀 ...
--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:23 pm

#3739695
Reply To: Calculating Easter in SQL

Thanks, Joe. I was reading about that in the second link I provided. Interesting bit of history that still affects us today. So, to answer the question of "When 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)

April 1, 2020 at 4:20 pm

#3739694
Reply To: Wargames Quotes

My absolute favorite scene from that movie also contains my favorite quote from the movie. Here's a link to it...
https://www.youtube.com/watch?v=MpmGXeAtWUw
--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 1:29 am

#3739485

Viewing 15 posts - 7,396 through 7,410 (of 59,072 total)