Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,021 through 13,035 (of 59,102 total)

RE: Calendar table

Darko Martinovic - Wednesday, January 31, 2018 2:25 PM
Jeff Moden - Wednesday, January 31, 2018 1:35 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 31, 2018 at 4:11 pm

#1978113
RE: Lowering the Noise

One of the best ways that I've found to lower the noise is the one that many shops avoid for some reason and that is to identify the code that'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)

January 31, 2018 at 1:40 pm

#1978098
RE: Calendar table

Darko Martinovic - Wednesday, January 31, 2018 1:27 PM
I was wondering why people are not so enthusiastic with 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)

January 31, 2018 at 1:35 pm

#1978096
RE: Calendar table

drew.allen - Tuesday, January 30, 2018 11:37 AM
K. Brian Kelley - Tuesday, January 30, 2018 11: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)

January 31, 2018 at 8:14 am

#1978033
RE: Lowering the Noise

jmlakar 69347 - Tuesday, January 30, 2018 8:45 AM
What I would give to see all client environments have just disk monitoring 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)

January 31, 2018 at 8:09 am

#1978031
RE: Today's Random Word!

Revenant - Tuesday, January 30, 2018 5:39 PM
ManicStar - Tuesday, January 30, 2018 9:17 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 30, 2018 at 8:08 pm

#1977988
RE: How to copy a database with one big mdf file to another server with smaller multiple drives.

Apparently, the OP has left the building.
--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 30, 2018 at 3:55 pm

#1977973
RE: How do the Experts Become Experts?

Matt Miller (4) - Tuesday, January 30, 2018 10:00 AM
While I agree with the "wolves in sheeps clothing" type comments from Jeff,...
--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 30, 2018 at 10:40 am

#1977910
RE: SQL Probe Bitmap 1008 high CPU

How many rows are actually in each table?
--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 30, 2018 at 6:52 am

#1977844
RE: Huge Latency in TempDB

Narine M - Tuesday, January 30, 2018 3:34 AM
Hi All,
We are facing a huge latency in tempdb, what will be the reason???
Latency
1174
1174
1166
1173
With...
--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 30, 2018 at 6:32 am

#1977840
RE: How do the Experts Become Experts?

Unfortunately, many "experts" are considered to be experts simply because they publish very often or have written a book on a subject that happens to sell well because the people...
--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 30, 2018 at 6:20 am

#1977839
RE: how to find if xp_cmdshell is being used or not

Sue_H - Monday, January 29, 2018 3:06 PM
ffarouqi - Monday, January 29, 2018 2:44 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 30, 2018 at 5:28 am

#1977836
RE: Data migration from one database to multiple databases

banda.sai - Monday, January 29, 2018 4:27 AM
Hello,
There are millions of records in one database and expecting to migrate records from two or...
--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 29, 2018 at 3:11 pm

#1977790
RE: how to find if xp_cmdshell is being used or not

ffarouqi - Monday, January 29, 2018 2:44 PM
Jeff Moden - Monday, January 29, 2018 2:30 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 29, 2018 at 3:01 pm

#1977785
RE: INSERT running slow in SQL 2016

P.S. The Trace Flag that I'm talking about is 9481. Do Google it before you use 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)

January 29, 2018 at 2:55 pm

#1977782

Viewing 15 posts - 13,021 through 13,035 (of 59,102 total)