Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,661 through 12,675 (of 59,095 total)

RE: Interviews: Covering index

Frank W Fulton Jr - Wednesday, March 21, 2018 4:33 PM
Thanks Steve, Once again you have proved why I love your newsletter,...
--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)

March 22, 2018 at 4:03 pm

#1984367
RE: Index statistics update with full scan.

Don't forget about "Column Statistics", which aren't ever updated by rebuilding an index. Also don't forget that reorganizing an index will do nothing for any statistics.
Last but not least,...
--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)

March 22, 2018 at 3:51 pm

#1984364
RE: SELECT INTO doesn't update the tables recursively

rva.raghav - Wednesday, March 21, 2018 9:35 PM
I have the below query which merges 9 tables into a single table NBCVadodra but...
--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)

March 22, 2018 at 3:38 pm

#1984362
RE: Rebuilding Indexes very often is good?

mig28mx - Thursday, March 22, 2018 10:59 AM
Hello all,
This was very interesting ideas exchange about how often, defrag or not defrag indexes......
--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)

March 22, 2018 at 3:33 pm

#1984361
RE: how to modify another jobs without sa?

tony28 - Thursday, March 22, 2018 12:28 PM
Hello,
is any way how to do rights for user, and he will be possible modify...
--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)

March 22, 2018 at 3:28 pm

#1984360
RE: Rebuilding Indexes very often is good?

paul s-306273 - Thursday, March 22, 2018 3:38 AM
I read this response from Tom Kyte in 2002 on the rebuilding of indexes...
--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)

March 22, 2018 at 8:04 am

#1984282
RE: Rebuilding Indexes very often is good?

paul s-306273 - Wednesday, March 21, 2018 6:13 AM
Any comments on rebuilding all indexes once a week as a housekeeping task.
Our DBA...
--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)

March 21, 2018 at 7:35 pm

#1984214
RE: Trace Flags - What do you use regularly?

On anything < 2016, I use TF 1118 (always). Rather than me posting "why" I use it, please read about it.
https://www.sqlskills.com/blogs/paul/misconceptions-around-tf-1118/
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql
I also use the...
--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)

March 21, 2018 at 6:51 am

#1984110
RE: Scripting/logic help

Atyeo9 - Tuesday, March 20, 2018 10:14 AM
My head is well and truly mashed and I could do with some help please...
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)

March 20, 2018 at 3:28 pm

#1984068
RE: Set-Based String Splitting table function

bevanward - Tuesday, March 20, 2018 3:04 PM
Jeff Moden - Monday, March 19, 2018 7:06 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)

March 20, 2018 at 3:10 pm

#1984066
RE: Figuring out Disk Contention

cbeardsley - Tuesday, March 20, 2018 2:53 PM
Our current, old, due to be replaced, environment is very bogged down by the disk...
--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)

March 20, 2018 at 3:08 pm

#1984065
RE: Are the posted questions getting worse?

Sean Lange - Tuesday, March 20, 2018 1:41 PM
Jeff Moden - Tuesday, March 20, 2018 1:03 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)

March 20, 2018 at 2:26 pm

#1984047
RE: If only the US would follow ...

Eric M Russell - Tuesday, March 20, 2018 2:06 PM
jmlakar 69347 - Tuesday, March 20, 2018 1:05...
--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)

March 20, 2018 at 2:23 pm

#1984045
RE: who is sysadmin

Perry Whittle - Tuesday, March 20, 2018 2:02 PM
Ahh in place upgrade may be different, logins wont be deleted during this.Windows admins...
--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)

March 20, 2018 at 2:15 pm

#1984040
RE: who is sysadmin

Perry Whittle - Tuesday, March 20, 2018 8:48 AM
BUILTIN\ADMINISTRATORS has not been a built in sql account since sql server 2005,...
--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)

March 20, 2018 at 1:16 pm

#1984023

Viewing 15 posts - 12,661 through 12,675 (of 59,095 total)