Jeff Moden

Forum Replies Created

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

RE: Abstract: Tech Writing for Techies

Ray K - Thursday, February 4, 2016 9:12 AM
Jeff Moden (1/28/2016)
I've found that many technologists that are in the business of writing...
--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 25, 2018 at 4:57 pm

#1984509
RE: Loading intermediate table

hoseam - Friday, March 23, 2018 6:10 AM
Hi,
I have these tables and data:
CREATE TABLE [Table1](
[PartnerSiteID] [int] IDENTITY(1,1) NOT NULL PK,
[PartnerID]...
--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 24, 2018 at 5:07 pm

#1984493
RE: Collation Question

r5d4 - Thursday, March 22, 2018 9:14 AM
Hiya,
I have a sql 2012 server set up with collation Latin1_General_CI_AS (default).
A vendor is performing an...
--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 24, 2018 at 5:03 pm

#1984492
RE: Use uniqueidentifier field in place of int

daniness - Friday, March 23, 2018 12:28 PM
Hi All,
I'm trying to populate a temp table. Here is the temp table:
[code...
--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 24, 2018 at 4:22 pm

#1984490
RE: Somebody Help! - T-SQL syntax help.

mw_sql_developer - Friday, March 23, 2018 3:03 PM
Jeff Moden - Friday, March 23, 2018 2:27 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 24, 2018 at 2:38 pm

#1984489
RE: Somebody Help! - T-SQL syntax help.

mw_sql_developer - Friday, March 23, 2018 10:09 AM

Here is what I need. I have s start date and a end date.
What...
--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 23, 2018 at 2:27 pm

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

rva.raghav - Thursday, March 22, 2018 8:11 PM
Hi sgmunson,
Thanks for the answer. Appreciate it. I would like to know how to write...
--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 9:45 pm

#1984375
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

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