Jeff Moden

Forum Replies Created

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

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, 6 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
RE: Horrible performance using sys.dm_os_performance_counters

PatLap - Wednesday, March 27, 2019 7:32 AM
Hi,
We are in process of buying a third party application (NewRelic) that does a 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)

March 27, 2019 at 2:50 pm

#2034023
RE: TempDB File Size Per TempDB FIle

trent.adams0201 - Wednesday, March 27, 2019 11:33 AM
I've answered my own question. I do need to change the *.mdf file as well...
--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 1:36 pm

#2034017
RE: SA account

Admingod - Wednesday, March 27, 2019 10:50 AM
I know it's not a good practice to share SA account password with developers. However,...
--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 1:33 pm

#2034016

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