Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,986 through 12,000 (of 59,102 total)

RE: How to find errros for backup using ola.hallengren solution

I'm pretty sure that the only way that a DIF will fail like this is...
1. The original backup wasn't actually taken and the "apparent" original backup file wasn't actually for...
--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)

June 28, 2018 at 1:15 pm

#1995722
RE: Exam 70-461

dbman - Wednesday, March 6, 2013 2:50 AM
Hi,Ive just ordered the book: Querying SQL Server 2012 Training Kit. I am planning to...
--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)

June 28, 2018 at 1:02 pm

#1995719
RE: Rollup/Aggregate tables and maintenance

Do indexed views work on the cloud? If they do, then that will likely have all of the features you seek for this.
--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)

June 28, 2018 at 12:49 pm

#1995717
RE: Adding a Qualifier inside a format file .xml

Does column 5 make consistent use of being wrapped in double quotes?
--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)

June 28, 2018 at 12:47 pm

#1995716
RE: Are the posted questions getting worse?

I've spit out a whole lot of craft beers and imports. Although I'll freely admit to an unsophisticated palette, I've never spit out a Bud or PBR. As for warm...
--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)

June 28, 2018 at 12:35 pm

#1995715
RE: Sort column without ORDER BY

ravikanth_b - Thursday, June 28, 2018 11:48 AM
I spent more than 15 years working on Oracle/SQL Server/MySQL and Big Data/NoSQL in architecture...
--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)

June 28, 2018 at 12:27 pm

#1995714
RE: Sort column without ORDER BY

ravikanth_b - Thursday, June 28, 2018 12:16 AM
I told the all the possible answers, she dint like it. I even asked 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)

June 28, 2018 at 8:54 am

#1995644
RE: Sort column without ORDER BY

DesNorton - Wednesday, June 27, 2018 11:52 PM
If you add a ROW_NUMBER() it will return in the sort order of the ROW_NUMBER.
Technically,...
--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)

June 28, 2018 at 12:08 am

#1995556
RE: Sort column without ORDER BY

ravikanth_b - Wednesday, June 27, 2018 10:26 PM
I was patiently trying to work with her with possible solution but you have to...
--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)

June 27, 2018 at 11:20 pm

#1995550
RE: Sort column without ORDER BY

Yes. It can actually be done rather reliably but MS will never support it. You need to do several things...
1. The table must have a Clustered Index that is...
--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)

June 27, 2018 at 11:13 pm

#1995549
RE: Automating activity logging

EMtwo - Wednesday, June 27, 2018 1:20 PM
Lynn Pettis - Wednesday, June 27, 2018 11:00 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)

June 27, 2018 at 10:39 pm

#1995546
RE: URGENT NEED :: Senior SQL Server Developer in Boston, MA area.

Ah... Ok. Understood. Thanks for the feedback.
--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)

June 27, 2018 at 10:21 am

#1995484
RE: Automating activity logging

EMtwo - Wednesday, June 27, 2018 9:27 AM
Thank you. Your help is appreciated. I'd like to load the result from this...
--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)

June 27, 2018 at 10:04 am

#1995479
RE: URGENT NEED :: Senior SQL Server Developer in Boston, MA area.

vishaldiaspark22 - Wednesday, June 27, 2018 8:33 AM
We are looking for a Senior SQL Server Developer
Type of hire: Contract to...
--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)

June 27, 2018 at 9:56 am

#1995478
RE: When it comes to salaries, I'm not average

Eric M Russell - Wednesday, June 27, 2018 8:45 AM
If you're interviewing to fill an experienced T-SQL developer position, and only 1...
--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)

June 27, 2018 at 9:33 am

#1995471

Viewing 15 posts - 11,986 through 12,000 (of 59,102 total)