Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,451 through 15,465 (of 59,097 total)

RE: Use date and time in sql statement for join, but not required in the output

jcelko212 32090 - Friday, March 10, 2017 2:26 PM
Jeff Moden - Monday, March 6, 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)

March 11, 2017 at 7:28 am

#1932813
RE: Need SQL query to get hierarchical structure of Employees

acmedeepak - Thursday, March 9, 2017 9:19 AM
I have a table with two columns:
Employee, Superior with their names in it.
Now, 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 10, 2017 at 6:50 pm

#1932807
RE: SQL Server 2016 DBA Training

Thanks, Daniel. I'll look into it.
--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 10, 2017 at 10:49 am

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

Sean Lange - Friday, March 10, 2017 9:13 AM
ScottPletcher - Friday, March 10, 2017 9:02 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 10, 2017 at 10:44 am

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

Viewing 15 posts - 15,451 through 15,465 (of 59,097 total)