Jeff Moden

Forum Replies Created

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

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
RE: Choosing the Birthday of a Customer by month?

chef423 - Wednesday, November 22, 2017 10:12 AM
Lynn Pettis - Wednesday, November 22, 2017 8:52 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 1:55 pm

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

ScottPletcher - Wednesday, November 22, 2017 12:25 PM
Lynn Pettis - Wednesday, November 22, 2017 12: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)

November 22, 2017 at 1:52 pm

#1969264
RE: Are the posted questions getting worse?

Shifting gears a bit... I get a lot of spam from recruiters. Some of them are trying to be helpful and one of them sent an email about "WHAT TRAITS...
--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 9:53 am

#1969213
RE: Are the posted questions getting worse?

GilaMonster - Tuesday, November 21, 2017 10:23 AM
Ed Wagner - Tuesday, November 21, 2017 5:34 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 9:46 am

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

patrickmcginnis59 10839 - Tuesday, November 21, 2017 8:29 AM
Jeff Moden - Tuesday, November 21, 2017 8:13 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 9:40 am

#1969209
RE: Date Ranges - Simple, but seemingly impossible

whenriksen - Wednesday, November 22, 2017 7:33 AM
DO NOT "correct" the data from your source. It is very common for a...
--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 9:21 am

#1969206

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