Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,061 through 9,075 (of 59,067 total)

Reply To: Pivot account date list to account start and end dates with missing dates

For those who may be lurking on this thread and possibly not understanding how the code on this thread works, especially with the most recent corrections submitted by DesNorton above,...
--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)

July 6, 2019 at 3:07 am

#3660378
Reply To: Seeing a lot of HEAPS tables with large row counts on prod. Is this a problem ?

Check the usage on the heaps. If they're not being used, don't worry about their 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)

July 6, 2019 at 1:54 am

#3660364
Reply To: The MSSQL Standard edition, does it limit the number of Work Threads?

Enquiring minds want to know... with a monster system like what you have, why are you "cheaping out" with Standard Edition especially when you expect so many simultaneous connections?
--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)

July 6, 2019 at 1:24 am

#3660363
Reply To: T-SQL versus Python with Pandas

rchantler wrote:
So, a new employee is promoting the idea of migrating from T-SQL to Python with Pandas. The existing code base is a large set of calculations (hundreds) done 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)

July 5, 2019 at 10:11 pm

#3660326
Reply To: Select Query Weirdness

Phil Parkin wrote:
PB_BI wrote:
Phil Parkin wrote:
You must work in Toyland.
Where others use variations of "foobar" for things they can't think of a name for, I use variations of "noddy". You're not...
--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)

July 5, 2019 at 10:01 pm

#3660324
Reply To: Recover data after drop table

oskargunn wrote:
I have a database which is partitioned. Part of maintenance for a particular table is to switch a partition to another table in order to remove the unwanted oldest...
--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)

July 5, 2019 at 9:57 pm

#3660319
Reply To: T-SQl or Store Procedure which fit better

jcelko212 32090 wrote:
> my problem is that some positions have the max salary listed as hourly rate and some are annual amount. Therefore, I need to multiply the hourly rate by...
--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)

July 5, 2019 at 9:50 pm

#3660317
Reply To: Are the posted questions getting worse?

Michael L John wrote:
Jeff Moden wrote:
It's the law of home ownership, Steve... all 10 minutes jobs take at least 6 hours to complete. 😀
And 5 trips to the hardware store.
6 if...
--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)

July 3, 2019 at 6:55 pm

#3659907
Reply To: Are the posted questions getting worse?

It's the law of home ownership, Steve... all 10 minutes jobs take at least 6 hours to complete. 😀
--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)

July 3, 2019 at 4:59 pm

#3659871
Reply To: Indexing question

For both online and offline index REBUILDs (and assuming the index is over 128 extents (or 1024 pages), which is only 8MB), a brand new index will be created and...
--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)

July 2, 2019 at 2:27 pm

#3659314
Reply To: Are the posted questions getting worse?

Thom A wrote:
below86 wrote:
But just ripping into the site isn't going to help anything change; we all know that constructive feedback is far better received. We've all experienced users that only...
--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)

July 2, 2019 at 12:31 am

#3659181
Reply To: backup tool to check every daily if i have success on backup

almirfiorio wrote:
Dear Members I have more than 50 servers with sql server installed each of them runs a backup job every day at night Exists any backup tool I can...
--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)

July 1, 2019 at 11:09 pm

#3659131
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
I'll leave this here, as we're not going to agree.
...
I hope you all still find the site and community worth supporting and continue to do so, but if not,...
--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)

July 1, 2019 at 11:07 pm

#3659130
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Visually appealing is a personal preference. The people on this thread seem (to me and a few others) to be complaining as though the formatting is something that's right...
--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)

July 1, 2019 at 3:45 pm

#3658940
Reply To: Conditional trigger on column update

I believe that the UPDATE() function can help you a lot here. For example, if the UPDATE() function is NOT true, you can shortcut the trigger with an early exit. ...
--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 30, 2019 at 3:13 pm

#3658738

Viewing 15 posts - 9,061 through 9,075 (of 59,067 total)