Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,086 through 8,100 (of 59,091 total)

Reply To: Question of the day - how to submit

Awesome! Looking forward to seeing it, John!
--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 20, 2019 at 2:10 pm

#3709585
Reply To: PIVOT taking forever unless temp table var used

What do you get when you write it with straight criteria instead of selecting from the sub-query?
--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 20, 2019 at 1:51 pm

#3709577
Reply To: how to find duplicate rows, dynamically, with a loop
Jonathan AC Roberts wrote:
Jeff Moden wrote:
Of course, that recommendation also comes with the warning that if the hashbytes are different, then the rows are guaranteed to be different. However (and you know this...
- This reply was modified 6 years, 8 months ago by Jeff Moden.
--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 20, 2019 at 1:42 pm

#3709573
Reply To: how to find duplicate rows, dynamically, with a loop
Jonathan AC Roberts wrote:
```
SELECT CONCAT('
SELECT ''', QUOTENAME(t.TABLE_SCHEMA), '.', QUOTENAME(t.TABLE_NAME),  ''' [TABLE_NAME], COUNT(*) COUNT 
  FROM (SELECT ',x.c, '
         ...
```
--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 19, 2019 at 11:22 pm

#3709278
Reply To: how to find duplicate rows, dynamically, with a loop

cuseman03 wrote:
well the PK alone doesn't indicate real world duplicates as in you can create an index column of sorts but that doesn't solve potential duplicates and even where there...
--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 19, 2019 at 11:16 pm

#3709277
Reply To: how to find duplicate rows, dynamically, with a loop

Why do you need to do this? Any table with a unique index on it, even a non-clustered one, will not have duplicates in it. Same goes for any table...
--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 19, 2019 at 7:50 pm

#3709229
Reply To: Question of the day - how to submit

Look in the upper right corner of the display for "Write for us". Click and follow your nose.
--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 19, 2019 at 7:43 pm

#3709227
Reply To: Audit failed/successful login LOG

Duplicate post. Please... no posts here. No need to split up possible answers. Go to the first one in process at https://www.sqlservercentral.com/forums/topic/audit-failed-successful-login-log-4#post-3709164
--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 19, 2019 at 4:02 pm

#3709169
Reply To: Audit failed/successful login LOG

Duplicate post. Please... no posts here. No need to split up possible answers. Go to the first one in process at https://www.sqlservercentral.com/forums/topic/audit-failed-successful-login-log-4#post-3709164
--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 19, 2019 at 4:02 pm

#3709168
Reply To: Audit failed/successful login LOG

Duplicate post. Please... no posts here. No need to split up possible answers. Go to the first one in process at https://www.sqlservercentral.com/forums/topic/audit-failed-successful-login-log-4#post-3709164
--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 19, 2019 at 4:00 pm

#3709167
Reply To: Sql Timeout error

Grant Fritchey wrote:
Jeff Moden wrote:
I've not worked with Dynamics... is that one of those MS applications/databases that uses random GUIDs for keys?
Yes!
With database designs that would make Codd break down weeping. They...
--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 19, 2019 at 3:39 pm

#3709163
Reply To: Sql Timeout error

I've not worked with Dynamics... is that one of those MS applications/databases that uses random GUIDs for keys?

--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 19, 2019 at 2:39 pm

#3709127
Reply To: Database copy automation

alexandermkd wrote:
In mean time i have found solution.
Tnx guys
BR
Two way street here... what solution did you come up 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)

December 19, 2019 at 2:36 pm

#3709122
Reply To: Question on Index

In that case, use a non-clustered index on the hashkey. It will be more narrow than a clustered index and will run much more quickly.

--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 18, 2019 at 9:37 pm

#3708923
Reply To: Return a value if record does not exist

ricoinside-sqlcentral wrote:
Wonderful solution! Congratulations!
Hmmm... wait for it...
--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 18, 2019 at 9:32 pm

#3708920

Viewing 15 posts - 8,086 through 8,100 (of 59,091 total)