Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,571 through 9,585 (of 59,102 total)

Reply To: Hello new world!
Yeah... guess there's a time limit for edits on posts... can't edit the previous post any more.

Briefcase is making sucking sounds. Had everything categorized by tags and all the tags...
- This reply was modified 7 years, 7 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)
March 31, 2019 at 3:22 am

#2187560
Reply To: Hello new world!
It would also appear that you cannot go back to a previously submitted post and edit it.
Also, for article, you can no longer get a view count to see how...
- This reply was modified 7 years, 7 months ago by Jeff Moden.
- This reply was modified 7 years, 7 months ago by Jeff Moden.
- This reply was modified 7 years, 7 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)
March 31, 2019 at 3:11 am

#2186392
Reply To: Hello new world!
Article counts are totally out of whack. I don't have 75 articles and for other people, since when to blog entries count as articles?
A lot of old clickable links don't...
- This reply was modified 7 years, 7 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)
March 31, 2019 at 2:18 am

#2179712
Reply To: Hello new world!

Dammit! My animated avatar is gone and so are all of my subscriptions!

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

March 31, 2019 at 2:13 am

#2179242
Reply To: Hello new world!
Jeff Moden wrote:
2167901 wrote:
Just testing for Copy’n’Paste from SSMS to the forum..
/****** Object: UserDefinedFunction [dbo].[fnTally] Script Date: 03/30/2019 20:45:59 ******/
SET...
- This reply was modified 7 years, 7 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)
March 31, 2019 at 1:03 am

#2169960
Reply To: Hello new world!
Jeff Moden wrote:
Just testing for Copy’n’Paste from SSMS to the forum..
```
/****** Object:  UserDefinedFunction [dbo].[fnTally]    Script Date: 03/30/2019 20:45:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 ALTER...
```
--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)
March 31, 2019 at 12:52 am

#2168413
Reply To: Hello new world!
Just testing for Copy'n'Paste from SSMS to the forum..
```
/****** Object:  UserDefinedFunction [dbo].[fnTally]    Script Date: 03/30/2019 20:45:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 ALTER FUNCTION...
```
--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)
March 31, 2019 at 12:48 am

#2167901
RE: Creating a non-unique index

I'm humbled. Thank you for the kind words and, as Dixie said, yes... that's me. :blush: I'll also say that it's not just me. DelimitedSplit8K is...
--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)

March 28, 2019 at 10:55 am

#2034122
RE: Speedy Table Variables

Lynn Pettis - Thursday, March 28, 2019 10:09 AM
Sean Lange - Thursday, March 28, 2019 8:31 AM
--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)

March 28, 2019 at 10:41 am

#2034117
RE: Horrible performance using sys.dm_os_performance_counters

As a bit of a sidebar, since there are so many rows that need to be loaded into memory for the query, I wonder how many rows are actually showing...
--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)

March 28, 2019 at 8:13 am

#2034097
RE: Horrible performance using sys.dm_os_performance_counters

PatLap - Thursday, March 28, 2019 6:44 AM
Thank you guys for your help. I did the following 3 tests and here are...
--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)

March 28, 2019 at 8:11 am

#2034094
RE: Speedy Table Variables

Stewart "Arturius" Campbell - Wednesday, March 27, 2019 11:35 PM
Jeff Moden - Wednesday, March 27, 2019 11:20...
--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)

March 28, 2019 at 8:05 am

#2034093
RE: Speedy Table Variables

The correct answer should be "It Depends" on which version of SQL Server you have. IIRC, this is a 2019 feature and it hasn't yet been RTM'd yet, has 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)

March 27, 2019 at 11:20 pm

#2034048
RE: Horrible performance using sys.dm_os_performance_counters

At this point, I'm going to suggest that you ask the 3rd party vendor that uses the query.
Also, change the WHERE clause to NOT use "<>". Instead, 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)

March 27, 2019 at 9:43 pm

#2034042
RE: Recursive CTE Duplication

danielfountain - Wednesday, March 27, 2019 8:21 AM
Hi all,
I am working on a system that has Business units and a Parent\Child relationship.
I...
--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)

March 27, 2019 at 2:52 pm

#2034024

Viewing 15 posts - 9,571 through 9,585 (of 59,102 total)