Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,456 through 7,470 (of 59,098 total)

Reply To: extract all data with week

Awesome. Thank you both.
--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)

March 30, 2020 at 10:34 pm

#3739127
Reply To: extract all data with week

My question would be... has anyone run the PowerShell code to make sure it works (with replacements for the table name, etc, of course)? I ask because I'm no PowerShell...
--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)

March 30, 2020 at 9:00 pm

#3739096
Reply To: Index Optimize

That would be correct.
--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)

March 30, 2020 at 8:56 pm

#3739095
Reply To: Reaping the benefits of the Window functions in T-SQL

BWAAAA-HAAAA!!!! There's enough bad code out there for me to be really peeved about that I just don't care where the semi-colon is so long as it's there. In fact,...
--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)

March 30, 2020 at 7:53 pm

#3739085
Reply To: Index Optimize

Crap... I'm sorry Jeffrey. I hit "report" instead of "quote" on your post by mistake.
As for the partitioning, please don't put words in my mouth. The original decision to partition...
--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)

March 30, 2020 at 7:25 pm

#3739076
Reply To: DB Restore is very slow ....

vsamantha35 wrote:
Thanks everyone for the help.
You're welcome but what have you ended up doing?
--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)

March 30, 2020 at 2:04 pm

#3738952
Reply To: Importing csv file into SQL table

schleep wrote:
See Chad Miller's Powershell function Write-DataTable
Got a link?
--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)

March 30, 2020 at 2:02 pm

#3738947
Reply To: Delete Duplicates from table based on two columns

Never mind... I misread some code that was written in a strange fashion.
--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)

March 30, 2020 at 1:57 pm

#3738944
Reply To: sql server memory buffer cache building up question

To be honest, I'd be more worried about code that was using "1000's of DB's in production". Why do you have so many? Are you using (for example) one database...
--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)

March 29, 2020 at 7:49 pm

#3738742
Reply To: Index Optimize

Jeffrey Williams wrote:
As for reorganize...there are times when that is the only option available, especially when looking at non-Enterprise Editions that are required to be available 7/24/365 - and you cannot...
--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)

March 29, 2020 at 6:02 pm

#3738734
Reply To: DB Restore is very slow ....

frederico_fonseca wrote:
Jeff Moden wrote:
frederico_fonseca wrote:
thanks guys - I forgot about the number of VLF - one would expect that these days where this is well known fact that any DBA has...
--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)

March 28, 2020 at 5:59 pm

#3738652
Reply To: Index Optimize

Jeffrey Williams wrote:
If I read this correctly - it seems you are saying that index maintenance needs to be based on that system. And based upon the data access patterns 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)

March 28, 2020 at 5:30 pm

#3738651
Reply To: DB Restore is very slow ....

frederico_fonseca wrote:
thanks guys - I forgot about the number of VLF - one would expect that these days where this is well known fact that any DBA has already set...
--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)

March 28, 2020 at 3:11 pm

#3738636
Reply To: Design ideas for historic data & trending

I'm thinking that Type 6 SCD's may be better. With that, the use of Temporal Tables may be just what the doctor ordered here with the understanding that they won'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)

March 28, 2020 at 2:41 pm

#3738628
Reply To: Parse list of names from Outlook

I agree. Because there is no requirement for maintaining the order in which the parsed elements appear, String_Split() is the better choice here.
The thing is that you have to be...
--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)

March 28, 2020 at 2:33 pm

#3738627

Viewing 15 posts - 7,456 through 7,470 (of 59,098 total)