Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,421 through 15,435 (of 59,063 total)

RE: need help writing the codes for this

sergehermane - Thursday, March 9, 2017 7:29 PM
1 - Write a query witch returns the following columns:
2 - a- OrderID
...
--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 9, 2017 at 9:08 pm

#1932641
RE: Today's Random Word!

ZZartin - Thursday, March 9, 2017 2:58 PM
Ed Wagner - Thursday, March 9, 2017 1:26 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 9, 2017 at 9:03 pm

#1932639
RE: Are the posted questions getting worse?

SQLRNNR - Thursday, March 9, 2017 11:31 AM
Hugo Kornelis - Thursday, March 9, 2017 1:44 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)

March 9, 2017 at 8:16 pm

#1932637
RE: SQL Server 2016 DBA Training

daniel.dolan - Thursday, March 9, 2017 7:07 AM
I recently took a 1 week bootcamp with Certification Camps in Sarasota, FL. All inclusive...
--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 9, 2017 at 7:53 pm

#1932634
RE: How to overcome the identity column "jump 1000" issue

Yep... me too, Scott. Decades of experience. Just, apparently, different experience and that's the key here. "It Depends".
--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 9, 2017 at 7:51 pm

#1932633
RE: How to overcome the identity column "jump 1000" issue

ScottPletcher - Thursday, March 9, 2017 11:53 AM
More than 50% of the time, identity is the wrong clustering key, because there's another...
--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 9, 2017 at 4:17 pm

#1932626
RE: Create Indexes on Computed Columns

nsadams87xx - Tuesday, March 7, 2017 11:47 AM
Once Persisted, won't this also start causing fragmentation in the index if the values change?
Fragmentation...
--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 8, 2017 at 8:33 pm

#1932448
RE: Request for sanity check of basic ETL process and database placement

xsevensinzx - Tuesday, March 7, 2017 6:31 AM
I mean, it seems pretty basic. You're starting off by logging your process then truncating...
--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 8, 2017 at 8:24 pm

#1932447
RE: T- SQL Query to fetch values -Pattern Matching

greeshatu - Tuesday, March 7, 2017 4:30 AM
I found a simple solution .. Thanks guys having a look at the query...
--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 8, 2017 at 8:08 pm

#1932445
RE: How to overcome the identity column "jump 1000" issue

Grant Fritchey - Tuesday, March 7, 2017 11:24 PM
Jeff Moden - Tuesday, March 7, 2017 1:00 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 8, 2017 at 8:00 pm

#1932444
RE: Are the posted questions getting worse?

djj - Wednesday, March 8, 2017 6:12 PM
Jeff Moden - Wednesday, March 8, 2017 4:42 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 8, 2017 at 7:19 pm

#1932442
RE: How to overcome the identity column "jump 1000" issue

GilaMonster - Wednesday, March 8, 2017 3:07 PM
GilaMonster - Wednesday, March 8, 2017 12:16 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)

March 8, 2017 at 5:02 pm

#1932435
RE: how to use following xml query with out prefix

rajemessage 14195 - Wednesday, March 8, 2017 8:38 AM
hi,
in following link
https://msdn.microsoft.com/en-us/library/ms175178.aspx
i found this cote
"This prefix is then used in...
--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 8, 2017 at 4:57 pm

#1932433
RE: Are the posted questions getting worse?

djj - Wednesday, March 8, 2017 1:02 PM
Well I have been out of a job for a few weeks now, and 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 8, 2017 at 4:42 pm

#1932430
RE: SQL Server 2016 DBA Training

Andy Reilly - Wednesday, March 8, 2017 3:19 AM
Hi Jeff,
You say to get the books - But unless I'm going blind there...
--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 8, 2017 at 4:35 pm

#1932429

Viewing 15 posts - 15,421 through 15,435 (of 59,063 total)