Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,336 through 4,350 (of 59,069 total)

Reply To: New Index Maintenance Methods Recommended by Microsoft

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
Jeff Moden wrote:
As a bit of a sidebar, wouldn't adding more files add to the problem you spoke of previously?
I'm not sure which specific "problem" you're referring to.
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)

November 9, 2021 at 6:08 pm

#3949591
Reply To: Help Converting Query For Hierarchical Data

duffdean wrote:
I have a working query within MySQL based on (Managing Hierarchical Data in MySQL - http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/). The problem I have is that I need to implement the same functionality on another...
--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)

November 6, 2021 at 9:28 pm

#3948695
Reply To: Query to fetch top SQL statements

I whole-heartedly agree Michael. Collecting data and knowing what to do with it are two very different things.
I'll also state that while extended events can be useful, it's a total...
--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)

November 6, 2021 at 8:52 pm

#3948694
Reply To: how testing works in real time environment

shalinipega2 wrote:
I want to know stages of testing.
I know this post is half a decade old but, since it was necro'd and bubbled to the surface, I have to ask......
--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)

November 6, 2021 at 8:34 pm

#3948693
Reply To: Automate loading data to SQL Server 2016 from Oracle DB
For performance reasons, I wouldn't use a "straight" SELECT from a linked server. Instead, I normally use OPENQUERY as the source for an INSERT INTO.
```
 INSERT INTO...
```
--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)
November 6, 2021 at 8:20 pm

#3948690
Reply To: Update Column but with Distinct Values
kaj wrote:
This should work, I think:
```
UPDATE t
SET t.CarStatus = '2'
FROM #Test t
INNER JOIN (
    SELECT CarID, MIN(Id) AS Id
    FROM #Test
...
```
--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)
November 6, 2021 at 8:10 pm

#3948688
Reply To: Monitoring system

sqlguru wrote:
We are setting up Idera SQL DM system to monitor our SQL Server's. So we have availability group setup for the repositories at database level. Looking for option 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)

November 6, 2021 at 7:40 pm

#3948679
Reply To: How to learn SQL?

Michael L John wrote:
These are MySQL forums https://forums.mysql.com/
As a bit of a side bar, I just took a look at that. It's quite extensive but, lordy... try scanning all of 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)

November 6, 2021 at 7:31 pm

#3948677
Reply To: SQL query help

jcelko212 32090 wrote:
Since the table is an unordered set, the concept of a previous record doesn’t apply in SQL.
That's not actually true but, even if it was, the logical selection...
--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)

November 6, 2021 at 7:26 pm

#3948675
Reply To: How to get Feature Name and Feature Value separated by $ for table AllData ?
I was careful to preserve as much of the original code as possible and to document this as well as the original code was. 😉
```
UPDATE Codes
 ...
```
--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)
November 6, 2021 at 7:08 pm

#3948674
Reply To: New Index Maintenance Methods Recommended by Microsoft

ScottPletcher wrote:
Jeff Moden wrote:
As a bit of a sidebar, wouldn't adding more files add to the problem you spoke of previously?
I'm not sure which specific "problem" you're referring to.
The one 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)

November 6, 2021 at 3:12 pm

#3948646
Reply To: Query runs slow sometimes and sometimes runs superfast (2 minutes vs 2 seconds)

skb 44459 wrote:
But still cant figure out why its very slow at times.
It's probably because the triggers that feed it are written incorrectly as some form of dynamic SQL that materialize...
--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)

November 5, 2021 at 7:10 pm

#3948469
Reply To: How to retrieve a number in range that matches another number
Here's one simple way. It'll really help things if you have an index on the TimeInterval column.
```
DECLARE @InputParameter [decimal](15, 6) = 691195
;
 SELECT TOP 1 *
 ...
```
--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)
November 5, 2021 at 6:48 pm

#3948464
Reply To: Database Corruption - LOB

You should play the lottery tonight. 😀 You just proved that you're one of the luckiest people on the whole planet. 😀
With that (and I know you get it but...
--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)

November 5, 2021 at 6:32 pm

#3948463
Reply To: SSRS reports that use a data component

Rod at work wrote:
Jeff Moden wrote:
Understood but that's not my question. To be more clear, you stated that...
I'd rather write components in a project written in C# that yield the results 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)

November 5, 2021 at 5:55 pm

#3948451

Viewing 15 posts - 4,336 through 4,350 (of 59,069 total)