Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,256 through 9,270 (of 59,099 total)

Reply To: What Keeps You Employed?

I tell people that I'm a database administrator and that I currently take care of and protect about 20 Terabytes of data. I explain that a Terabyte is a million...
--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)

May 24, 2019 at 12:48 am

#3646739
Reply To: Are the posted questions getting worse?

Michael L John wrote:
Wow. Just Wow. https://www.sqlservercentral.com/forums/topic/query-containing-while-loop-for-dates-taking-increditbly-long#post-3646645
I guess that's the word for it. They need some paid help especially in the area of some training.
--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)

May 24, 2019 at 12:14 am

#3646736
Reply To: Query help on Pivoting on two columns

Phil Parkin wrote:
Heh, Phil's name is not, nor ever has been, Sean! And the query was deliberately written in that way, as the OP did not specify the need to see...
--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)

May 23, 2019 at 11:46 pm

#3646732
Reply To: Query help on Pivoting on two columns
s-sql wrote:
```
DECLARE @RegionCounts Table
(
TYear char(2),
Region varchar(30),
RowCnt int
)

Insert into @RegionCounts values ('13','Latam',100)
Insert into @RegionCounts values ('13','NOAM',200)
Insert into @RegionCounts values ('14','Latam',300)
Insert into @RegionCounts values ('14','NOAM',400)

select * from @RegionCounts
```
I need...
--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)
May 23, 2019 at 5:05 pm

#3646607
Reply To: How to list counts hour by hour
No pun intended but let's hold the phone for a minute here. 😉
1. What do you want done for hours that have no entries in the table because there were...
--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)
May 22, 2019 at 3:55 am

#3645964
Reply To: SQL Agent. Run T-SQL in scheduled job against a DB in a different SQL instance.

greg.bull wrote:
Well, that's what I'd like to do! This is so I can keep the scheduling config and T-SQL on one admin SQL Server, whilst the databases reside on different...
--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)

May 22, 2019 at 3:37 am

#3645963
Reply To: prod and stage comparison

I could be wrong but it looks like all of that only covers SQL Server. If there's something else on the box that's putting the hammer to CPU or file...
--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)

May 22, 2019 at 3:35 am

#3645962
Reply To: Posts right edge cutting off?

Brandie Tarvin wrote:
I'm on IE 11...
I was specifically told during the last update (well prior to this latest migration) that they made a conscious decision to not support any form of...
--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)

May 21, 2019 at 2:58 pm

#3645745
Reply To: The Datatimeoffset Value

Ya know... this finally eliminated the confusion I had with this function (mostly because I don't use it but might have better reason to now). Thanks Steve.
--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)

May 21, 2019 at 3:13 am

#3645600
Reply To: DML performance : Unpartioned Table with Index vs Partitioned table with Index

Was it actually due to the partitioning itself or was it because of the preparations (and related indexes) that were actually the key? I'm asking because in that thread 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)

May 20, 2019 at 10:09 pm

#3645550
Reply To: Are the posted questions getting worse?

Grant Fritchey wrote:
Jeff Moden wrote:
You've been given a gift... when most folks write a presentation, they practice it at say 20 minutes but they've included so much good stuff that it will...
--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)

May 20, 2019 at 6:48 pm

#3645508
Reply To: Why Tools Can Help You Do Your Job

Kathi Kellenberger wrote:
If you don't use the tools correctly, then there is probably not much chance you are working correctly without them either, I guess.
The problem is that a whole lot...
--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)

May 20, 2019 at 3:06 pm

#3645420
Reply To: DML performance : Unpartioned Table with Index vs Partitioned table with Index

If I'm reading you correctly, I totally agree. SWITCH is a great reason to partition. That's not the "performance" thing that most folks talk about and that I tend 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)

May 20, 2019 at 2:07 pm

#3645380
Reply To: DML performance : Unpartioned Table with Index vs Partitioned table with Index

That pretty much supports what I've found. It's actually people finally paying attention to the data and doing some decent indexing that makes the code run faster. Because they're finally...
--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)

May 20, 2019 at 1:52 pm

#3645365
Reply To: Are the posted questions getting worse?

Brandie Tarvin wrote:
And posting powerpoint slides is kinda worthless if one subscribes to the belief that powerpoint should supplement the presentation, not contain the presentation.
I subscribe to "It Depends". If it's...
--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)

May 20, 2019 at 12:26 pm

#3645333

Viewing 15 posts - 9,256 through 9,270 (of 59,099 total)