Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,281 through 2,295 (of 59,067 total)

Reply To: record loading

And, I didn't read Jeffrey Williams post before I posted (I was responding to a post on the first page of this thread). He's spot on about the Unix TimeStamp...
--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)

December 13, 2022 at 10:41 pm

#4125202
Reply To: record loading
Bruin wrote:
```
Insert Into Tag_Data_Capture_staging
(TagName,CaptureValue,DateRecorded)
select * 
from OPENQUERY(srv1, 'select tagid,floatvalue,DATEADD(s,t_stamp/1000,''1969-12-31 20:00:00'') from rem.ignition.dbo.sqlt_data_1_2021_12
where DATEADD(s,t_stamp/1000,''1969-12-31 20:00:00'') between  ''12-09-2021'' AND ''12-10-2021'' and floatvalue is not null');
```
I did the Insert...
--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)
December 13, 2022 at 10:27 pm

#4125190
Reply To: No PK on any tables - Need that to enable Change Tracking on SQL Server

cbarus wrote:
Jeff- I agree. I was too hasty in my initial thought process. Change is inevitable. Change of thought for better is not 🙂
😀
--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)

December 13, 2022 at 12:30 am

#4124692
Reply To: No PK on any tables - Need that to enable Change Tracking on SQL Server

@cbarus - I CAN definitely understand not wanting to mess with a legacy app or it's database especially when they're out of support. I was just confused by your posts...
--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)

December 12, 2022 at 5:21 pm

#4124662
Reply To: Poking the Bear

Grant Fritchey wrote:
Thanks for the feedback all. No, no hate on Trace. I was dead serious in what I said about never questioning anyone using it ever again. Also, equally serious...
--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)

December 12, 2022 at 5:15 pm

#4124660
Reply To: Create graphic report showing databases backed up and success stats

And, in case you're wondering what the chart looked like that I needed (and sound like what you want) here's what I ended up making. The Red lines show 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)

December 12, 2022 at 6:29 am

#4124505
Reply To: Create graphic report showing databases backed up and success stats

Here's one more that shows some promise but it's not apparent as to whether or not it includes SQL Server backups.
https://www.bocada.com/product/backup-monitoring/

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

December 12, 2022 at 6:23 am

#4124500
Reply To: Create graphic report showing databases backed up and success stats

It's been a long time since I've looked at backup dashboards and monitoring software. All of the ones I've looked at in the last hour are pretty disappointing. LiteSpeed, which...
--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)

December 12, 2022 at 6:20 am

#4124499
Reply To: Create graphic report showing databases backed up and success stats

I believe that NetBackup actually provided the monitoring dashboard you speak of. What are you using for backups now? Are they SQL "native" backups or are you using some other...
--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)

December 12, 2022 at 4:32 am

#4124472
Reply To: Create graphic report showing databases backed up and success stats

got2be wrote:
A reply to my post was deleted as spam. My post was not marked as spam. I want the reports to show how many databases I’m backing up, time...
--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)

December 12, 2022 at 4:23 am

#4124465
Reply To: Create graphic report showing databases backed up and success stats

To be honest, you're post looks like a typical two part spam, the second part of which has already been deleted as spam.
Since you're new on this forum, if 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)

December 11, 2022 at 11:32 pm

#4124416
Reply To: No PK on any tables - Need that to enable Change Tracking on SQL Server

cbarus wrote:
Thanks Michael. The issue is I don't want to touch the existing vendor DB. It is anyways out of support but it still works and we don't want to...
--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)

December 11, 2022 at 9:23 pm

#4124403
Reply To: Blocking

As a bit of a sidebar, check out Adam Machanic's sp_WhoIsActive at the following link. Click on the "Documenation" tab and look for "blocking" on the next list of links. ...
--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)

December 10, 2022 at 9:11 pm

#4124213
Reply To: Poking the Bear

I value you as both a long-distance friend and a mentor so I'm not going to passive-aggressively insult you or gas-light you like you just have many of us. 😉
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)

December 10, 2022 at 2:43 am

#4123997
Reply To: Data Activity Tracking Using SQL Triggers

Hemandu Malhotra wrote:
Hi Jeff Moden,
Thank you for your response. I am not sure if I follow some of your concerns. Yes, this is an old method and we have customized 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)

December 9, 2022 at 10:15 pm

#4123940

Viewing 15 posts - 2,281 through 2,295 (of 59,067 total)