Jeff Moden

Forum Replies Created

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

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
RE: CPU spike when executing a query in SQL

saum70 - Monday, November 13, 2017 5:56 AM
Jeff Moden - Sunday, November 5, 2017 7:04 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 13, 2017 at 8:31 am

#1967799
RE: Date format check

John Mitchell-245523 - Monday, November 13, 2017 3:27 AM
sqlenthu 89358 - Sunday, November 12, 2017 10:29 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 13, 2017 at 8:21 am

#1967796
RE: Rounding to the nearest 15 seconds

If both simplicity and performance are important AND the datetimes will always be > '2000-01-01', then the following will do the trick. (Replace the sample date with the column name).
--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 8:15 am

#1967794
RE: Are the posted questions getting worse?

Thom A - Monday, November 13, 2017 5:50 AM
Jeff Moden - Monday, November 13, 2017 5:42 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 6:21 am

#1967765
RE: what is causing tempdb to become full

Also Kiran, to John Mitchell's point, you ask a whole lot of questions on many forums that have simple and quick answers if you spend just a little time 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)

November 13, 2017 at 6:14 am

#1967762
RE: what is causing tempdb to become full

Except for an old bug for log file growth being set to 4,000MB which, according to most, has been repaired, that answer as to what is causing TempDB to grow...
--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 6:03 am

#1967759

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