Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,066 through 10,080 (of 59,093 total)

RE: SQL getting locked up - Important please help!

sizal0234 - Thursday, January 10, 2019 2:24 PM
Hi,
In the past week, we had to reboot sql server to make it come out...
--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)

January 11, 2019 at 1:51 pm

#2018731
RE: Recommendations for "phasing out" of local SQL backups for NetApp SNAPS

Toddmonster85 - Thursday, January 10, 2019 10:44 AM
We're having a debate regarding administration of SQL server backups.
Recently we've started using NetApp SnapCenter...
--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)

January 11, 2019 at 1:30 pm

#2018729
RE: Evolving Our Tools

Heh... you learn all those wonderful tools and begin to rely on them. Then, something happens and you end up at a new company and you're dead because 1) they...
--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)

January 11, 2019 at 1:15 pm

#2018724
RE: Badly Trained AI

robert.sterbal 56890 - Friday, January 11, 2019 7:53 AM
Jeff Moden - Thursday, January 10, 2019 9:54 PM
--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)

January 11, 2019 at 8:05 am

#2018702
RE: Files with larger disk consumption

Junior GalvÃ£o - MVP - Friday, January 11, 2019 6:49 AM
Jeff Moden - Thursday, January 10, 2019...
--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)

January 11, 2019 at 8:00 am

#2018700
RE: New SQL Saturday presentation ideas?

Grant Fritchey - Friday, January 11, 2019 6:37 AM
It doesn't matter that you're not an MVP or whatever. You can teach beginners...
--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)

January 11, 2019 at 7:46 am

#2018697
RE: Log file and data file growth

Sal Young - Thursday, January 10, 2019 4:04 PM
Here is what I use to see data & log file growth
/*
-------------------------------------------------------------------------------------------------
...
--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)

January 10, 2019 at 10:25 pm

#2018663
RE: Files with larger disk consumption

Junior GalvÃ£o - MVP - Thursday, January 10, 2019 3:43 PM
Jeff Moden - Thursday, January 10, 2019...
--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)

January 10, 2019 at 10:21 pm

#2018662
RE: The Basics of iTVFs

The Dixie Flatline - Thursday, January 10, 2019 2:56 PM
Nico,
While I agree with Jeff's first two points about data duplication and...
--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)

January 10, 2019 at 10:10 pm

#2018661
RE: Badly Trained AI

Rod at work - Thursday, January 10, 2019 2:56 PM
Eric M Russell - Thursday, January 10, 2019...
--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)

January 10, 2019 at 9:54 pm

#2018659
RE: Month T-1

girl_bj - Thursday, January 10, 2019 7:14 PM
pietlinden - Thursday, January 10, 2019 7:05 PM
--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)

January 10, 2019 at 9:50 pm

#2018658
RE: Month T-1

girl_bj - Thursday, January 10, 2019 9:01 AM
Jeff Moden - Thursday, January 10, 2019 8:57 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)

January 10, 2019 at 9:41 am

#2018569
RE: New SQL Saturday presentation ideas?

How about one on strategic and tactical persuasion? Like how to persuade Ray K to learn more about T-SQL and SQL Server so he has more subject matter to choose...
--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)

January 10, 2019 at 9:38 am

#2018568
RE: Badly Trained AI

xsevensinzx - Thursday, January 10, 2019 8:35 AM
Jeff Moden - Thursday, January 10, 2019 8:19 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)

January 10, 2019 at 9:31 am

#2018564
RE: SQL Quiz

Heh... Changing times, indeed. It's seems that cheating on assignments/interviews has become the norm.
--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)

January 10, 2019 at 9:24 am

#2018559

Viewing 15 posts - 10,066 through 10,080 (of 59,093 total)