Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,511 through 9,525 (of 59,102 total)

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
Reply To: Ability to delete your own replies and posts that have no replies

They only allowed such a thing for certain people and only on certain forums. I believe the reason for that was that some OPs would delete their original and their...
--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 2:52 pm

#2690874
Reply To: Bankers Rounding

Globalleads wrote:
There is certainly a lot to find out about this subject. I really like all the points you made!
Man, quit spamming and get a real job. Just because 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)

April 3, 2019 at 1:33 pm

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

Robert Chipperfield (Redgate) wrote:
Jeff Moden wrote:
It looks like profiles work again as do the PM messages.
Sorry folks - some rewrite rule badness happened. Should be fixed now (along with followers / following...
--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 1:29 pm

#2685052
Reply To: DBA for future

rolltheballaz wrote:
The article is really nice and interesting. I have searched for this type of information and would love to read this information. I hope you will share more useful...
--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:38 am

#2574883

Viewing 15 posts - 9,511 through 9,525 (of 59,102 total)