Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,096 through 7,110 (of 59,091 total)

Reply To: Memory Optimized tables for speeding inserts and updates

IMHO, memory optimized tables have a lot of baggage for something like this. How often will you need to do this? If it's once every 10 minutes, maybe. If it's...
--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)

May 18, 2020 at 3:03 pm

#3752597
Reply To: Return code with stored procedure

You have to use RETURN somevalue or variable in the proc to get such a return.
See the following...
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/return-transact-sql?view=sql-server-ver15
--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)

May 18, 2020 at 2:33 pm

#3752582
Reply To: How can I determine relationships or dependencies between tables or queries?

frank.kress wrote:
Hi Jeff
that's incredibly fantastic. That's exactly what I thought.
The system views such as: sys.sql_dependencies goes in the right direction but the tool from Quest is a real hammer.
And 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)

May 18, 2020 at 1:55 pm

#3752511
Reply To: Cleanup Sysmail -items from msdb

Maybe, but it shouldn't be for long unless you have a huge number of emails per day. Of course, you would have had the same blocking (short and sweet) with...
--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)

May 18, 2020 at 1:49 am

#3752366
Reply To: Cleanup Sysmail -items from msdb

I'm thinking that, although the mail items are being deleted, I'm not sure that any attachments will be and I'm pretty sure that the mail log isn't being reduced by...
--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)

May 17, 2020 at 7:27 pm

#3752338
Reply To: Thoughts on storing repetitive data

Using 9999-01-01 is no more of kludge than using NULL but the former has advantages over using NULL when it comes to performance, especially if you understand that the use...
--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)

May 17, 2020 at 3:56 pm

#3752330
Reply To: Forum FAQ

Cool. Added the link to the Forum FAQ article to my signature line. Thanks, Steve.
--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)

May 15, 2020 at 11:21 pm

#3752141
Reply To: Number of TempDB Files over 8

Rebuild the stats first. Let's talk about the indexes after that.
Believe it or not and depending on the type(s) of workloads they have, logical fragmentation may not actually matter for...
--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)

May 15, 2020 at 9:54 pm

#3752132
Reply To: Bones of SQL - Practical Calendar Queries

ans328 wrote:
Can you give a brief explanation of the nested date functions?
It's just the use of functions as operands (parameters) for other functions. Something like the following pseudo-code...
Function3( Function1(somevalue) ,Function2(somevalue)...
--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)

May 15, 2020 at 2:22 pm

#3752010
Reply To: Problem with a heap table

Step one is to remove all doubt. Do the SELECT COUNT(*) thing on the table.
You also say that you inserted millions of rows into the heap. There are 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)

May 15, 2020 at 1:55 pm

#3752001
Reply To: Thoughts on storing repetitive data

Disagreement noted.
However, there's nothing in what I stated that uses 24:00:00, nothing that would violate the constraint on the EndDate, and thee method I suggested actually does use the proper...
--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)

May 15, 2020 at 1:41 pm

#3751997
Reply To: Normalization query challenge -- more an intellectual exercise than anything

Steve Collins wrote:
jonathan.crawford wrote:
Jeff, quit torturing the poor guy and just give him the linkhttp://www.sqlservercentral.com/Forums/Topic530630-8-2.aspx
Nice. Is there a unicode version?
No, but the conversion should be fairly simple.
Man... I can't believe...
--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)

May 15, 2020 at 1:10 am

#3751876
Reply To: What does the Future DBA Do?

Cool. Thanks Eric. I'll take a look.

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

May 14, 2020 at 9:53 pm

#3751845
Reply To: Normalization query challenge -- more an intellectual exercise than anything

Interesting. Does it correctly handle names like MacDonald, McDonald, van Halen, O'Leary, and things like "This is a Book"?
--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)

May 14, 2020 at 7:29 pm

#3751698
Reply To: XEvent Targets

Grant Fritchey wrote:
Focus on what tools can do for you instead of 12 year old reports of a tool's shortcomings.
Heh... I know what you mean. I've been saying the same thing...
--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)

May 14, 2020 at 7:16 pm

#3751691

Viewing 15 posts - 7,096 through 7,110 (of 59,091 total)