Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,866 through 2,880 (of 59,098 total)

Reply To: Performance degradation - Help troubleshooting

ramana3327 wrote:
Thanks everyone. Statistics update did the magic. The CPU inbound message is gone. Waiting for the confirmation from App tram
Awesome. Thanks for the feedback on what the fix was.
As...
--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)

September 3, 2022 at 5:52 pm

#4083625
Reply To: How do I query to exclude the "first position of a 3 digit number"

aaron.reese wrote:
how about:
give me a list of hotels of 4 or more floors where any floor has more than 12 rooms?
Not a particularly difficult query, but made much simpler if...
--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)

September 3, 2022 at 5:44 pm

#4083624
Reply To: SQL user and AD Group - Blank out the "Default Schema"

Johan Bijnens wrote:
Best practice is always specifying the schema for any object used.
Preach it brother!
--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)

September 2, 2022 at 10:25 pm

#4083478
Reply To: Proper DW Fact and Dimension design questions

pietlinden wrote:
Sorry, I'm not great at Data Warehouse design. =( I'm modeling a bakery for a friend of mine. He purchases ingredients and the prices for them may change over...
--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)

September 2, 2022 at 10:13 pm

#4083476
Reply To: Performance degradation - Help troubleshooting

All that information provides is that something is beating the hell our of your disk system. You need to find out what that is. Have you tried looking at Task...
--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)

September 2, 2022 at 10:05 pm

#4083474
Reply To: Send Alert Email On Disabling DDL Trigger

We have such a system in place. It won't stand up in court, though because, me being a DBA with SysAdmin privs (or anyone else with SysAdmin privs) could turn...
--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)

September 2, 2022 at 10:01 pm

#4083473
Reply To: What should I have done with this?

Too funny, Rick. What did it say on what would be the bottom of the box as it's oriented in the picture?
--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)

September 2, 2022 at 9:54 pm

#4083467
Reply To: Find replace using regular expressions

drew.allen wrote:
I believe that this does close to what you are looking for. It can probably be massaged to do exactly what you want. The big problem is that 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)

September 2, 2022 at 9:49 pm

#4083465
Reply To: How do I query to exclude the "first position of a 3 digit number"

I agree with Scott that such a query is going to return all the hotel rooms except "some" and will likely do a scan anyway. So, just keep it simple,...
--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)

September 2, 2022 at 9:45 pm

#4083464
Reply To: Performance on large table -Index Creation
If you do build an index (non-clustered or clustered, doesn't matter) on the Unique Identifier column, build the index with a 71% Fill Factor and setup a job to...
- This reply was modified 4 years ago by Jeff Moden. Reason: Forgot to specify the column
--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)
September 2, 2022 at 6:04 am

#4083125
Reply To: URGENT - Visio Diagram from SQL Server Database

Your answer is here...
https://www.google.com/search?q=reverse+engineer+a+database+using+visio
I believe it needs to be the "professional" version, though.

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

September 2, 2022 at 5:50 am

#4083121
Reply To: Potholes in the Road of Progress

How strange it is that this wonderful article resurface today. It's provided some much needed motivation. Thank you again for writing it, Phil.
--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)

September 2, 2022 at 4:40 am

#4083108
Reply To: Performance degradation - Help troubleshooting

Agreed on both.
--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)

September 2, 2022 at 1:05 am

#4083090
Reply To: How do I query to exclude the "first position of a 3 digit number"

Yes. That would work but how often would you actually have a need that couldn't be solve easily, like Phil did?
--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)

September 2, 2022 at 1:04 am

#4083089
Reply To: SQL Server 2022 Build List

Ah, sorry. This article is strictly about 2022. My mistake.
--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)

September 1, 2022 at 7:13 pm

#4083014

Viewing 15 posts - 2,866 through 2,880 (of 59,098 total)