Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,141 through 4,155 (of 59,098 total)

Reply To: How to get the permission creation and modification date

Gibbs wrote:
You can modify the date created by copying a file. The file's created date becomes the modified date and the current date when the file is copied becomes 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)

January 4, 2022 at 7:02 pm

#3969864
Reply To: Start Sql server agent job after a trigger

rafamaniac wrote:
ok thank you, will see what the service broker can do.
K... just remember that's not my first choice. For me personally, it wouldn't be a choice. Like I said,...
--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)

January 4, 2022 at 6:56 pm

#3969862
Reply To: Missing Indexes

Hawkins_IT wrote:
Sorry my post is confusing. I wasn't really sure how elaborate on it. Yes, we are having performance issues and it mainly looks like disk IO latency. We have...
--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)

January 4, 2022 at 6:52 pm

#3969861
Reply To: Multiple Date rows into One single Date row(date range)

Thanks. I definitely missed your 301 comments below the 2nd spreadsheet you posted.
You say to only worry about the contiguous dates but neither the Green or the Purple sections 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)

January 4, 2022 at 6:38 pm

#3969858
Reply To: Start Sql server agent job after a trigger

rafamaniac wrote:
Is it possible to start Sql server agent job after a trigger? what i want to do is after a certain table updates a certain column, then it runs...
--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)

January 4, 2022 at 3:50 am

#3969534
Reply To: Get Data from Internet Directly into SQL Server

That's awesome, Frederico! Thanks for posting that.
It would appear, though, that you actually have to program for the table structure. Is there anything like the getting data from the Web...
--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)

January 4, 2022 at 1:29 am

#3969511
Reply To: Missing Indexes

p.s. You might also want to read the following about Query Store. Personally, I'll never enable it and use other methods to figure out what I need to but I'm...
--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)

January 4, 2022 at 1:00 am

#3969509
Reply To: are there are any thing can do after create index to enhance query speed ?

My first recommendation is that you actually desk check the query to make sure that you don't have anything "silly" in it. For example, looking at your query, you have...
--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)

January 4, 2022 at 12:50 am

#3969506
Reply To: Missing Indexes

Your post is a bit confusing. You start by talking about I/O Latency but show a chart for CPU usage and then ask if it's common to have a lot...
--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)

January 4, 2022 at 12:30 am

#3969503
Reply To: Backup SQL database generates error

Worse than that, it sounds like you're doing backups on the same server that you're backing up. That's a serious mistake because if the server crashes, not only have 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)

January 4, 2022 at 12:10 am

#3969494
Reply To: Get Data from Internet Directly into SQL Server

water490 wrote:
Now THAT's interesting. Just curious... do you know what the page will be for 2022? Or will it magically change at the end of the month?
Yes, that link should...
--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)

January 4, 2022 at 12:03 am

#3969489
Reply To: My New Resolution

Rune Bivrin wrote:
Easy enough. But I would personally assign whoever created that table with DATETIME instead of DATE to toilet cleaing duty for a week...
"It Depends". I can see someone designing...
--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)

January 3, 2022 at 11:57 pm

#3969483
Reply To: Multiple Date rows into One single Date row(date range)

Getting back to your second output, what exactly is it that determines if the entries are contiguous? Does a contiguous period always start with a comp code of 301? 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)

January 3, 2022 at 5:06 pm

#3969388
Reply To: Multiple Date rows into One single Date row(date range)

The pictures are very helpful for understanding but it would also be extremely helpful if you included readily consumable data. Please see the first link in my signature line below...
--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)

January 3, 2022 at 4:56 pm

#3969381
Reply To: Get Data from Internet Directly into SQL Server

pietlinden wrote:
It looks like you can now use PowerQuery as a source in SSIS. The nice thing is that Excel can write PowerQuery for you - all you have 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)

January 3, 2022 at 4:48 pm

#3969379

Viewing 15 posts - 4,141 through 4,155 (of 59,098 total)