Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,966 through 10,980 (of 59,095 total)

RE: HOW TO GET FIRST DATE

Deny_Christian - Monday, September 17, 2018 12:54 AM
Dear all,
I have data like:

NAME ...
--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)

October 14, 2018 at 6:53 am

#2009506
RE: Are the posted questions getting worse?

GilaMonster - Saturday, October 13, 2018 11:43 AM
Jeff Moden - Saturday, October 13, 2018 10:15 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)

October 13, 2018 at 1:11 pm

#2009501
RE: Importing CSV Flat File defaults all columns to 50 chars

Duncan A. McRae - Saturday, October 13, 2018 9:19 AM
Same name, same issue. Any resolution in the 8 years since posted?
IMHO, you...
--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)

October 13, 2018 at 12:04 pm

#2009499
RE: A $3 Billion Donation

I'm not sure that's generosity on the part of Microsoft. Perhaps, and as many have, Microsoft finally woke up as to how much money it costs to police and protect...
--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)

October 13, 2018 at 11:48 am

#2009497
RE: What's wrong with my table?

frederico_fonseca - Friday, October 12, 2018 6:01 PM
Unless this is a datawarehouse (and even that not a must) then lots are wrong.
See...
--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)

October 13, 2018 at 11:04 am

#2009495
RE: What's wrong with my table?

Hmmm.... based on other posts by this op, this is all starting to sound a bit different than what the actual wording of the post might convey. Please see...
--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)

October 13, 2018 at 11:03 am

#2009494
RE: Are the posted questions getting worse?

frederico_fonseca - Saturday, October 13, 2018 10:52 AM
Jeff Moden - Saturday, October 13, 2018 10:15 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)

October 13, 2018 at 11:01 am

#2009493
RE: Anyone see a problem with this?

Hmmm.... this is all starting to sound a bit different than what the actual wording of the post might convey. Please see the following...
https://www.sqlservercentral.com/Forums/2002689/Query-slow-Help-improve?Update=1#bm2002914
--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)

October 13, 2018 at 10:36 am

#2009491
RE: Query slow. Help improve?

Heh... I just saw your other post on the monster wide table that violated every form of normalization there is and where every update was preserved without the benefit of proper historical...
--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)

October 13, 2018 at 10:25 am

#2009490
RE: Are the posted questions getting worse?

Jeff Moden - Saturday, October 13, 2018 9:42 AM
Eirikur Eiriksson - Saturday, October 13, 2018 3:54 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)

October 13, 2018 at 10:16 am

#2009488
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Saturday, October 13, 2018 3:54 AM
frederico_fonseca - Saturday, October 13, 2018 3:12 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)

October 13, 2018 at 9:42 am

#2009482
RE: Query slow. Help improve?

SQLStud 74876 - Friday, October 12, 2018 5:08 PM
I'm pretty good with SQL, so no newbs please.
Do you always walk into a...
--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)

October 13, 2018 at 9:33 am

#2009481
RE: Are Indexes Actually Changes to the System?

Paul Randal - Thursday, October 11, 2018 10:00 PM
We did a bunch of testing back in 1999 when the code was originally...
--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)

October 11, 2018 at 10:06 pm

#2009278
RE: Barracuda backups, VMWare and Backup Device Type 7

So, have you tried a restore yet?
--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)

October 11, 2018 at 9:59 pm

#2009276
RE: Are Indexes Actually Changes to the System?

Thanks for the feedback, Paul. I've admittedly got an environment that's quite a bit different than a synchronous AG/mirror environment and simply don't have access to such an environment. Do...
--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)

October 11, 2018 at 9:33 pm

#2009275

Viewing 15 posts - 10,966 through 10,980 (of 59,095 total)