Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,556 through 9,570 (of 59,091 total)

Reply To: Hello new world!
Ugh! Looks like I'm not the only one that going to suffer link breakages... have a look at Sean's signature line at the following post.
https://www.sqlservercentral.com/forums/topic/are-the-posted-questions-getting-worse/page/4216/#post-2034220

Response times seem to be...
- This reply was modified 7 years, 5 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 9:49 pm

#2271880
Reply To: Recreating sane index not improve the performance

Why do you ask? After almost two weeks, has some new problem occurred? 😉

Generally speaking, the order in which you create or rebuild non-clustered index makes no diference.
--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 9:45 pm

#2271525
Reply To: Hello new world!

When HappyGeek posted about my signature line, my signature line was broken. I edited it trying to fix the broken link and it removed almost all of the BBCodes. 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 31, 2019 at 9:24 pm

#2270415
Reply To: Hello new world!

To be honest, I think that anyone trying to do forum posts on an android is expecting a bit much. 😉
--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 11:57 am

#2235728
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, 5 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, 5 months ago by Jeff Moden.
- This reply was modified 7 years, 5 months ago by Jeff Moden.
- This reply was modified 7 years, 5 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, 5 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, 5 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

Viewing 15 posts - 9,556 through 9,570 (of 59,091 total)