Jeffrey Williams

Forum Replies Created

Viewing 15 posts - 1,501 through 1,515 (of 6,676 total)

Reply To: What is the best way to create events from table inserts in SQL Server

I think this fits in with service broker much more than using triggers. The service broker would monitor the table and generate a message for every insert - and call...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

December 1, 2020 at 8:23 pm

#3815780
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...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

December 1, 2020 at 7:38 pm

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

What is the purpose of this secondary copy of the database? There are several options available - depending on what you intend to do with that copy.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

December 1, 2020 at 6:40 pm

#3815715
Reply To: Get Particular Date from a Month

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 wondering where the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

December 1, 2020 at 6:08 pm

#3815701
Reply To: Get Particular Date from a Month

Rock wrote:
This works perfectly. A little change in the output. If I pass TestDate as Today. It has to get me Thursday (follows with 2nd Tue - 12 Nov 2020)...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

December 1, 2020 at 3:44 pm

#3815610
Reply To: Get Particular Date from a Month

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 the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

December 1, 2020 at 3:40 pm

#3815609
Reply To: Get Particular Date from a Month

Steve Collins wrote:
It depends on what the "today" date is, no?
CASE 2 - If Today is 1 Dec 2020 - Then, The output should be (12 Nov 2020) -
Reason, 10 Dec...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

November 30, 2020 at 10:59 pm

#3815342
Reply To: Get Particular Date from a Month

Jeff Moden wrote:
Jeffrey Williams wrote:
Just a little warning - you should not use a string literal in the function as that will be implicitly converted and could cause cardinality issues. Instead -...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

November 30, 2020 at 10:54 pm

#3815340
Reply To: Get Particular Date from a Month

Steve - if you set the test date to 2020-12-09 you should get 2020-12-10 as the Thursday following the second Tuesday of the month. At least that is how I...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs

November 30, 2020 at 10:31 pm

#3815335
Reply To: Get Particular Date from a Month
Jeff Moden wrote:
Ok... One more time. This time, actually verified.
Here's the formula for use with GETDATE(). You can change the two "GETDATE()"s to a column in a table, as well.
```
Jeffrey Williams

“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll
How to post questions to get better answers faster

Managing Transaction Logs
```
November 30, 2020 at 9:08 pm

#3815313

Reply To: Tempdb increasing crazily

892717952 wrote:

Jeff Moden wrote:

The things you mention don't typically cause the crazy increase you speak of. And I just told you a "good way" to find it so someone can fix...

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

November 30, 2020 at 7:50 pm

#3815290

Reply To: Join to lookup table on multiple columns

Except that single outer apply will be executed for each row in the Meter table - and the data must be sorted each time based on the filters from the...

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

November 27, 2020 at 8:21 pm

#3814558

Reply To: Join to lookup table on multiple columns

Just curious - but how are these solutions better than using multiple joins? If this is a performance related issue - fix the use of the upper functions on the...

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

November 27, 2020 at 5:59 pm

#3814514

Reply To: Join to lookup table on multiple columns

I don't think that is going to be possible - each of the different values you are looking up will exist on a different row and there is nothing that...

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

November 26, 2020 at 6:39 pm

#3814263

Reply To: Backup time not reducing even after DB size went down 300 GB

Earlier in the thread he stated the database was taking 2 hours.

PJ_SQL wrote:

Database was 500Gb, 200 GB worth data deleted and then shrink files to reclaim space, backup was taking...

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

November 25, 2020 at 10:45 pm

#3814026

Viewing 15 posts - 1,501 through 1,515 (of 6,676 total)