Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,671 through 5,685 (of 59,089 total)

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
Reply To: Audit

I can't help but notice the irony here.. Interesting question coming from someone with a handle of "sqlguru". 😉
--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 8, 2021 at 10:31 pm

#3842674
Reply To: Intellisense for dropping temp tables?

Cool. Thanks for the feedback. Funny setting name, though. I would never have thought to look under "Auto List Members". Members aren't Objects. Gotta love the lingo. 😀
That might also...
--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 8, 2021 at 10:02 pm

#3842672
Reply To: A Simple Formula to Calculate the ISO Week Number

Heh... I'm no longer surprised by such things. For example, the came out with EOMonth, which has the very problem we're talking about. They didn't come out with an SOMonth...
--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 8, 2021 at 6:59 pm

#3842603
Reply To: Intellisense for dropping temp tables?

A lot of things have changed in SSMS since it became a separate product and they continue to "ditz" with it and, so far, a lot of it has been,...
--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 8, 2021 at 6:38 pm

#3842596
Reply To: Query optimization

Apparently, the OP has left the building.
--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 8, 2021 at 4:21 pm

#3842532
Reply To: A Simple Formula to Calculate the ISO Week Number
Thanks. I'll look at it in a bit more detail later but my first impression is that the following line of code in the CROSSAPPLY is incorrect.
```
cast(dateadd(wk,datediff(wk,0,'01/04/'+iso.yr),0)+((iso.wk)*7)-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)
February 8, 2021 at 4:19 pm

#3842531
Reply To: A Simple Formula to Calculate the ISO Week Number

Steve Collins wrote:
Is this still the best way to do this in 2021? Google landed me at another SSC Forum from 2005, which I can't find anymore, and now I'm using...
--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 8, 2021 at 2:34 pm

#3842493
Reply To: Tough Interview Questions

I totally agree that "outlook, attitude, motivation and method" are incredibly important. However, there have to be technical questions/discussions, as well. I've found that they're actually important in me 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 8, 2021 at 2:30 pm

#3842492

Viewing 15 posts - 5,671 through 5,685 (of 59,089 total)