Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,426 through 7,440 (of 59,098 total)

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

Whew!!! Nice one, Steve!! You had me going there! I was thinking that I should plan on retiring sooner than I really wanted because even the cursors in Oracle are...
--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:19 am

#3739483
Reply To: Calculating Easter in SQL

Very nice collection of algorithms, Jeffrey. I've got one more for you to add to your collection.
Peter "Peso" Larsson came up with the following basic method quite a while back. ...
--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:05 am

#3739481
Reply To: Need some help getting info of people logged in, but from the POV of NON-Sysadm

We have no clue by what you mean by "unexpected results".
--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, 2020 at 8:38 pm

#3739425
Reply To: extract all data with week

For me, it was the initial run of having an extra 90 million rows. 😀
--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, 2020 at 8:35 pm

#3739423

Viewing 15 posts - 7,426 through 7,440 (of 59,098 total)