Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,496 through 9,510 (of 59,091 total)

Reply To: SELECT COUNT(*) Taking a Very Long Time

homebrew01 wrote:
Bad habit of (*) perhaps. Thinking "It's just a count"

Crud... that's what I get for reading a post prior to a quart of coffee. When I first read your...
--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)

April 8, 2019 at 6:21 pm

#3026771
Reply To: Missing Articles/Editorials

It's not just the missing articles... The "Resources" section on articles (the place where code was attached) still appears to be missing. Especially for articles where the code displayed in...
--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)

April 8, 2019 at 2:50 pm

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

Congratulations GAIL SHAW!!!!

And thanks to the Developer Team that fixed the "Contributors" output!!
--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)

April 8, 2019 at 2:45 pm

#3018404
Reply To: Quoting posts with Line breaks

Understood but the really helpful nature of quoting is that you don't have to go back through the entire thread to see what someone is talking about even if 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)

April 8, 2019 at 2:43 pm

#3018334
Reply To: SELECT COUNT(*) Taking a Very Long Time

Because you've asked for all of the data including 3 Text columns (which have also been deprecated for years now) and file paths that can also be quite large. My...
--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)

April 7, 2019 at 3:54 am

#2956751
Reply To: building one group from other groups aggregated

If the order of the rows is important, there is nothing in the data to support the order and you cannot rely on the "natural" order. There has to be...
--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)

April 7, 2019 at 3:42 am

#2956374
Reply To: DBA for future

Grant Fritchey wrote:
I'm on board with learning both. T-SQL is vital, there's no question. However, automation is vital and you can't, in fact shouldn't, do some things within the OS...
--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)

April 5, 2019 at 11:59 am

#2859000
Reply To: DBA for future

Didn't say that PowerShell was going to hurt abilities in T-SQL. The problem is that a whole lot of people are using PowerShell instead of T-SQL to do things that...
--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)

April 5, 2019 at 2:53 am

#2828958
Reply To: DBA for future

lsalih wrote:
Grant, well said... Having worked with cloud and SQL DBA work, I found learning Powershell is a must. Anyone deals with cloud and managing different flavors of RDMS needs...
--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)

April 4, 2019 at 8:50 pm

#2807688
Reply To: Unable to send email

LearningDBA wrote:
It's working now.
So tell us how and why please...
--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)

April 4, 2019 at 4:39 pm

#2788724
Reply To: Quoting posts with Line breaks

Steve Jones - SSC Editor wrote:
This appears to be working now. The quote items are a permissions issue, as we work on what we allow/don't by non moderators.
Cool... That and the names appear instead...
--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)

April 4, 2019 at 4:21 pm

#2787502
Reply To: Links in earlier posts not working

Any word on fixing links? Hits on Google and Bing are dropping like flies.

I'm no front-end expert by any means but here's a thought for a possible fix. Rumor has...
--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)

April 4, 2019 at 12:15 am

#2729368
Reply To: db owner best practice

I would make one that reports when the owner is something else but I'm not sure I'd make one do an auto-change. You just can't tell when that could break...
--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)

April 3, 2019 at 10:24 pm

#2723314
Reply To: DBA for future

No... automating things that a DBA does will NOT "automate you out of a job". On the contrary... it will make you even more valuable because you'll have time 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)

April 3, 2019 at 6:11 pm

#2704786
Reply To: Please revert to old site or prevent new content until data loss issues resolved

That and many internal, Google, and hardcoded blog links throughout the world are now broken.
--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)

April 3, 2019 at 4:47 pm

#2699433

Viewing 15 posts - 9,496 through 9,510 (of 59,091 total)