Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,726 through 13,740 (of 59,101 total)

RE: Delete syntax not working

sgmunson - Tuesday, November 14, 2017 10:22 AM
Luis Cazares - Tuesday, November 14, 2017 10: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)

November 14, 2017 at 12:46 pm

#1968073
RE: Interesting Datenames

As with AS on a previous problem, the best advice to answering this question is "MUST LOOK EYE!" 😉
--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)

November 14, 2017 at 9:18 am

#1968016
RE: Date Search

drew.allen - Tuesday, November 14, 2017 8:30 AM
gvoshol 73146 - Tuesday, November 14, 2017 8:08 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)

November 14, 2017 at 9:15 am

#1968015
RE: can I put more than one database per disk?

Blake McNeill - Tuesday, November 14, 2017 8:41 AM
Jeff Moden - Tuesday, November 14, 2017 8:29 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)

November 14, 2017 at 9:07 am

#1968009
RE: S?QL Server using 97% of RAM.

Also to point out and speaking from a bit of experience where I made a Phat Phinger mistake... BE VERY VERY CAREFUL WHEN MAKING THE SETTING CHANGE!!!! If you screw...
--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)

November 14, 2017 at 8:56 am

#1968002
RE: can I put more than one database per disk?

Blake McNeill - Tuesday, November 14, 2017 7:10 AM
If we have large databases or one that will be heavily used, then we...
--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)

November 14, 2017 at 8:29 am

#1967981
RE: Implications of slower writes with 64K pages using SSDs vs SAN

What I've found is that, although there is a benefit to having things on SSD, it's trivial compared to the larger problem. Main Memory (RAM) (comparatively) blows the doors off 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)

November 14, 2017 at 8:21 am

#1967975
RE: Trigger table read?

jayg359 - Tuesday, November 14, 2017 6:28 AM
Jeff Moden - Monday, November 13, 2017 10:53 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)

November 14, 2017 at 7:01 am

#1967953
RE: can I put more than one database per disk?

Phil Parkin - Tuesday, November 14, 2017 6:23 AM
dubem1-878067 - Tuesday, November 14, 2017 5:47 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)

November 14, 2017 at 6:57 am

#1967952
RE: Running Balance query

VSSGeorge - Tuesday, November 14, 2017 2:52 AM
GOT IT
SELECT t2.Date,
   t2.Credit,
   t2.Debit,
   SUM(COALESCE(t1.credit, 0) - COALESCE(t1.debit, 0))...
--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)

November 14, 2017 at 6:55 am

#1967950
RE: Trigger table read?

jayg359 - Monday, November 13, 2017 8:32 PM
Chris Harshman - Monday, November 13, 2017 10:21 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)

November 13, 2017 at 10:53 pm

#1967890
RE: what is causing tempdb to become full

coolchaitu - Monday, November 13, 2017 10:05 AM
Jeff Moden - Monday, November 13, 2017 6:14 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)

November 13, 2017 at 2:19 pm

#1967870
RE: Are the posted questions getting worse?

Michael L John - Monday, November 13, 2017 8:15 AM
Sean Lange - Monday, November 13, 2017 7:41...
--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)

November 13, 2017 at 12:58 pm

#1967860
RE: Are the posted questions getting worse?

Chris Harshman - Monday, November 13, 2017 10:57 AM
Phil Parkin - Monday, November 13, 2017 7:33 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)

November 13, 2017 at 12:43 pm

#1967857
RE: Rounding to the nearest 15 seconds

ScottPletcher - Monday, November 13, 2017 11:46 AM
Jeff Moden - Monday, November 13, 2017 8:15 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)

November 13, 2017 at 12:22 pm

#1967850

Viewing 15 posts - 13,726 through 13,740 (of 59,101 total)