Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,356 through 5,370 (of 59,072 total)

Reply To: Backup failed

Don't you have access to the rest of the failure message from the SQL Server Error Log?
If I had to guess from the truncated message above, I'd say you may...
--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 21, 2021 at 1:14 am

#3873756
Reply To: Transaction log and updates on large tables

x wrote:
what about fn_dblog?
I updated a table with the same value and after doing this there were two more rows returned by fn_dblog. each time I ran the (duplicate)...
--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 20, 2021 at 9:39 pm

#3873707
Reply To: Help with detecting and sending alerts for lengthy blocking

TangoVictor wrote:
Jeff Moden wrote:
You can actually setup an alert for blocking and then you can have that alert call a stored procedure to get some amplifying information, record that information...
--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 20, 2021 at 9:17 pm

#3873703
Reply To: Transaction log and updates on large tables

Heh... it's not my story. It's in the link you provided. Paul proved it with code. Can you prove it to be otherwise with code?
--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 20, 2021 at 6:54 pm

#3873634
Reply To: Help with detecting and sending alerts for lengthy blocking

TangoVictor wrote:
Not looking for a solution just some suggestions for methods that have worked well for others.
You can actually setup an alert for blocking and then you can have that...
--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 20, 2021 at 5:34 pm

#3873603
Reply To: Profiler Trace

Personally, I'd check the SQL Server Error Logs for deadlock events.

--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 19, 2021 at 6:04 pm

#3873182
Reply To: Database going to Recovery, while accessible.

@JohnyRotten,
Wow. I've never actually heard of any third party (nor anyone else, for that matter) using auto-close on a database before. Thanks for taking the time to post what you...
--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 19, 2021 at 12:08 pm

#3873008
Reply To: Things We Are Missing

I've been pretty happy... as some say... "Loving the lockdown". But, I have to agree with you Grant. Being around people does promote spontaneous discussion, which supports and enables the...
--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 19, 2021 at 12:04 pm

#3873007
Reply To: Archiving data to a read only file

If no one is allowed to read it, it might as well be compressed so it doesn't take as much room so I agree with Grant's suggestion of converting it...
--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 19, 2021 at 11:55 am

#3873006
Reply To: how checksum works?
892717952 wrote:
1. Could you please me how checksum work in the SQL statement ? below is an example.
SELECT * FROM Tablename1 WHERE CHECKSUM(*)
NOT IN (SELECT CHECKSUM(*) FROM TableName2)
2. and there 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 18, 2021 at 5:15 pm

#3872752
Reply To: Transaction log and updates on large tables

Jeff Moden wrote:
ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
(3) SQL does that itself, so that's only a very minor consideration.
I might be misinterpreting what you're saying above but, at face...
--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 18, 2021 at 1:27 pm

#3872697
Reply To: Things We Are Missing

I believe that what's missing can be described by a single word...
SERENDIPITY : The occurrence and development of events by chance in a happy or beneficial way.
--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 17, 2021 at 2:30 pm

#3872431
Reply To: Transaction log and updates on large tables

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
(3) SQL does that itself, so that's only a very minor consideration.
I might be misinterpreting what you're saying above but, at face value, 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 16, 2021 at 7:09 pm

#3872144
Reply To: Are the posted questions getting worse?

Great info. Thanks, Brandie.
--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 16, 2021 at 7:02 pm

#3872142
Reply To: Are the posted questions getting worse?

Michael L John wrote:
Jeff Moden wrote:
Brandie Tarvin wrote:
Silly question for you. Why do you need a Kindle device when you could install the Kindle or Nook app on any tablet of...
--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 16, 2021 at 6:40 pm

#3872135

Viewing 15 posts - 5,356 through 5,370 (of 59,072 total)