Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,971 through 5,985 (of 59,072 total)

Reply To: Avoid Trigger!! If you are a good DB developer!!

youcantryreachingme wrote:
So if you wanted a field named date_last_modified on your data table and you wanted to use a trigger to set that value to getDate() via an update trigger,...
--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 2, 2020 at 3:17 pm

#3816067
Reply To: Restoring Database from Snapshot on the different Server

joe-676144 wrote:
Is it possible to restore not only the database but also it's snapshots from the Live to the Dev server?
It's about time you found this place and signed up,...
--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 2, 2020 at 3:06 am

#3815889
Reply To: Can I download Shapefiles for all countries from somewhere?

I don't need such a thing but I Googled for "download Shapefiles for all countries" and got a shedload of hits that also had the word "free" in their descriptions.

--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 1, 2020 at 11:38 pm

#3815840
Reply To: Can I clone a database across servers?

If both databases live on the same SAN, checkout the documentation for the SAN... it may have the ability to do a "SAN Snapshot", which is incredibly fast and doesn't...
--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 1, 2020 at 11:16 pm

#3815834
Reply To: Virtual SQL - Standard vs Enterprise, per-core

The other advice would be to upgrade at least the 2012 and 2014 instances. Also, if each host has 32 cores, are some of them really low usage where 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)

December 1, 2020 at 11:11 pm

#3815833
Reply To: Get Particular Date from a Month

SwePeso wrote:
I am using an 8 core laptop with 8 GB of ram and 512 GB SSD disk, SQL Server 2019.
I get consistent 1100 ms with Jeffreys cte.
I'm thinking 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)

December 1, 2020 at 10:25 pm

#3815815
Reply To: Get Particular Date from a Month

SwePeso wrote:
I get 450 milliseconds when using the algorithm as a scalar function. I get 1000 milliseconds when using the algorithm as an inline table-valued function.
Using the same 1 000...
--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 1, 2020 at 7:56 pm

#3815758
Reply To: Get Particular Date from a Month

SwePeso wrote:
Are you referring to this function? https://www.sqltopia.com/algorithms/date-and-time/get-the-nth-weekday-of-any-interval/
I can't see that it should take 4 seconds to run over a million date interval?
That's the one, Peter. Here's the code 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)

December 1, 2020 at 7:04 pm

#3815717
Reply To: Get Particular Date from a Month

Jeffrey Williams wrote:
Jeff Moden wrote:
You did good. Peter's takes over 4 seconds on a million rows. Yours takes about 380ms. Like I said, an order of magnitude
Curious - I am...
--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 1, 2020 at 6:24 pm

#3815704
Reply To: Get Particular Date from a Month

Jeffrey Williams wrote:
Jeff Moden wrote:
@Jeffrey Williams,
I tested your performance improvements for Peter's code and they're an order of magnitude faster. Nicely done. I've also not been able to find a fault 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)

December 1, 2020 at 4:29 pm

#3815611
Reply To: Costing per database

TJ_T wrote:
Hi,
I am just checking to see if anyone has ever did a costing per database (based on it size). I am trying to figure out what the cost 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)

December 1, 2020 at 3:15 pm

#3815589
Reply To: Get Particular Date from a Month

Sergiy wrote:
Look at the last script from my post.
It allows to the function against all the dates you can possibly get.
in between the brackets at CROSS APPLY (...) T2 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)

December 1, 2020 at 1:44 pm

#3815545
Reply To: sys.dm_os_performance_counters Resource Pool Stats returns zero

How much memory is actually in this particular system? I ask because, while I agree that Express is pretty limited, it seems to me that it should be able 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 1, 2020 at 1:43 pm

#3815544
Reply To: Tally generator

Totally agreed on that, Sergiy. It turned out that I had problems with my fnTally function going nuts but it wasn't the fault of the function. 2017 RTM sucked eggs...
--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 1, 2020 at 5:22 am

#3815424
Reply To: My topic is being flagged as spam
You folks should hum a rock at the webmaster for this site to do two things...
1. See if they'll "unspam" your post.
2. See if they can improve the anti-spam bot...
--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 1, 2020 at 5:16 am

#3815423

Viewing 15 posts - 5,971 through 5,985 (of 59,072 total)