Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,606 through 13,620 (of 59,101 total)

RE: Start Fixing Your DB with Better Code

seo.reputeinfosystems - Thursday, November 23, 2017 12:01 AM
I am currently working on a monitoring tool where the database "architecture" was...
--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 23, 2017 at 11:45 am

#1969362
RE: Choosing the Birthday of a Customer by month?

Sergiy - Thursday, November 23, 2017 1:45 AM
Jeff Moden - Tuesday, November 21, 2017 8:46 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 23, 2017 at 10:51 am

#1969359
RE: Better TSQL Performance

Lynn Pettis - Wednesday, November 22, 2017 3:55 PM
Jeff Moden - Wednesday, November 22, 2017 3:50 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 23, 2017 at 10:44 am

#1969357
RE: Table Design

Jason A. Long - Wednesday, November 22, 2017 3:57 PM
Grant Fritchey - Wednesday, November 22, 2017 9:57...
--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 23, 2017 at 9:20 am

#1969355
RE: Better TSQL Performance

drew.allen - Wednesday, November 22, 2017 8:25 AM
Jeff Moden - Wednesday, November 22, 2017 8:20 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 22, 2017 at 3:50 pm

#1969291
RE: Table Design

Remember or discover that the Clustered Index can have more than one use (didn't say more than one key) and is not necessarily the panacea of performance that people would sometimes...
--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 22, 2017 at 3:48 pm

#1969290
RE: Table Design

Bill Talada - Wednesday, November 22, 2017 9:14 AM
Primary keys should be non-human readable like a guid...at least in pure theory. I...
--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 22, 2017 at 3:43 pm

#1969289
RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

Lynn Pettis - Wednesday, November 22, 2017 11:33 AM
Jeff Moden - Wednesday, November 22, 2017 9:40 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 22, 2017 at 3:37 pm

#1969288
RE: Add New Column Based on Criteria

Thom A - Saturday, November 18, 2017 11:06 AM
Try:
ALTER TABLE #test_table ADD [Page] AS CONVERT(int,((CP - 1) / 10) + 1);
In regards...
--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 22, 2017 at 3:32 pm

#1969286
RE: Does anyone use views in this way?

I agree with Bill Talada... it's your server... you should be able to drop a table in wherever you need to. If it end up on a 3rd party database,...
--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 22, 2017 at 3:21 pm

#1969283
RE: Tool for SQL Server code tuning

ffarouqi - Wednesday, November 22, 2017 10:01 AM
Hello experts,
Is there a free or a paid tool/software that can be used to provide...
--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 22, 2017 at 2:42 pm

#1969277
RE: Backing up multiple SQL instance and databases using 3rd party software - Any recommendations

ffarouqi - Wednesday, November 22, 2017 12:23 PM
Hello,
We are looking to have a centralized software management tool for backing up SQL Server...
--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 22, 2017 at 2:34 pm

#1969275
RE: SQL server 2016 - Backup definition

guerrerocz87 - Wednesday, November 22, 2017 2:00 PM
Evgeny - Wednesday, November 22, 2017 1: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 22, 2017 at 2:29 pm

#1969274
RE: Statistics for crud operation

iseedeadpeople - Monday, November 20, 2017 6:03 AM
Hello guys, how can i get statistic for 2,3 days which operation like insert select...
--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 22, 2017 at 2:25 pm

#1969273
RE: Choosing the Birthday of a Customer by month?

saravanatn - Wednesday, November 22, 2017 8:24 AM
Hi Jeff,
Thanks for point it out and your contribution to SQL is immense . I...
--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 22, 2017 at 2:05 pm

#1969271

Viewing 15 posts - 13,606 through 13,620 (of 59,101 total)