Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,641 through 5,655 (of 59,072 total)

Reply To: Convert International Character-String Date Formats

Heh... and there was a response in the morning's email right next to this one that drives the point home for the bottom line above. The "devil's in the data". ...
--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)

February 13, 2021 at 3:05 pm

#3844597
Reply To: Convert International Character-String Date Formats

Kristen-173977 wrote:
Jeff Moden wrote:
Such a list exists in SQL Server in the sys.syslanguages system compatibility view
Much better idea 🙂 That will also bring to light, and allow checking for, any month...
--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)

February 13, 2021 at 3:01 pm

#3844596
Reply To: SQL newbie, question about primary key.

Ed Wagner wrote:
Everyone's already addressed the SSN and I'm glad it was hypothetical. Kristin hit the nail on the head regarding the PK. The only thing I'd say to watch out...
--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)

February 13, 2021 at 4:57 am

#3844475
Reply To: Looking to Role Models

From the Article:
The SQL Server community has shared, inspired, and supported each other in a way I haven't seen in other areas.
You're one of the people that started that, Steve. ...
--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)

February 13, 2021 at 4:48 am

#3844474
Reply To: Convert International Character-String Date Formats

Kristen-173977 wrote:
If each individual file is not language specific (i.e. dates within the file are mixture of languages) my inclination would be to extract all the DISTINCT month names, ideally...
--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)

February 13, 2021 at 4:12 am

#3844473
Reply To: Convert International Character-String Date Formats

DB_Newbie2007 wrote:
Does anyone know of a method to try and convert dates into a us-english format?
Heh... I didn't until an hour or so ago. 🙂
This should help a bit. Don't...
--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)

February 13, 2021 at 4:02 am

#3844472
Reply To: Retrieve data from First 25 and last 25 data pages from the Database

Heh... might as well show that you're flexible, as well. Ask them if they want that in logical page order or physical page order. 😀
--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)

February 11, 2021 at 11:31 pm

#3844019
Reply To: Long running report- kill the session

khushbu wrote:
yea we are on it for improving /re designing.
Until then is there a way to identify the ask?
You will never fix it if you do such a thing. 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)

February 11, 2021 at 10:26 pm

#3844004
Reply To: Why I have problem with adding IDENTITY in my table?

jcelko212 32090 wrote:
...the name of the table should be a plural or collective noun and not a singular noun
If you're going to cite a spec, do it properly with Part, Section,...
--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)

February 11, 2021 at 10:20 pm

#3844002
Reply To: Retrieve data from First 25 and last 25 data pages from the Database

MillionQueries wrote:
I agree @ken and @kristen
But is it even possible to get the first 25 and last 25 pages of data from the data pages since Data pages constantly keeps...
--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)

February 11, 2021 at 10:02 pm

#3844001
Reply To: GRANT permission to SYNONYM and DENY to underlying object?

Jeffrey Williams wrote:
It appears that you are performing QA testing on the production system - which to me is the root of the problem. For QA testing - a secondary system...
--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)

February 11, 2021 at 9:53 pm

#3843992
Reply To: Query optimization

Like I said above, changing the clustered index to support these DELETEs would certainly help these deletes A LOT. But, changing the clustered index without knowing "the rest of 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)

February 9, 2021 at 4:12 pm

#3842971
Reply To: Audit

David Burrows wrote:
Jeff Moden wrote:
I can't help but notice the irony here.. Interesting question coming from someone with a handle of "sqlguru". 😉
Maybe you should change your handle to SQL God cos...
--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)

February 9, 2021 at 3:39 pm

#3842965
Reply To: Allow SQLSaturdays to personalize

Steve Jones - SSC Editor wrote:
I agree with allowing customization of logos, colors, taglines, etc.
I think you can have any logo, color, taglines you want provided that it doesn't shed any negativity on 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)

February 9, 2021 at 3:25 pm

#3842957
Reply To: Intellisense for dropping temp tables?

I just checked my system. That setting is on and, apparently, defaults to being on.
--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)

February 9, 2021 at 3:53 am

#3842763

Viewing 15 posts - 5,641 through 5,655 (of 59,072 total)