Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,566 through 8,580 (of 59,091 total)

Reply To: Remove Cursors

It's actually much simpler than even that but that's it on any clues on this thread. Please PM the OP if anyone wants to help or discuss further. Help 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 3, 2019 at 1:04 pm

#3685690
Reply To: Deduplicating records from monthly table backups?

p.s. If you really want to do it right with Partitioned Views, create each period's FileGroup and File in a separate database using the exact same naming convention but with...
--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 3, 2019 at 12:47 pm

#3685658
Reply To: Deduplicating records from monthly table backups?

heb1014 wrote:
Hey Jeff. Great idea! I'm going to add this to my notes.
When you have a new historical period, you create a new table and modify the view definition?
Actually, it's...
--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 3, 2019 at 12:36 pm

#3685655
Reply To: Can a clustered server backup to unc

MVDBA is spot on but I'll add that you MUST backup to a different physical machine than where your database files live. If backup compression is available, definitely use 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)

October 3, 2019 at 12:33 pm

#3685650
Reply To: Deduplicating records from monthly table backups?

Better than what Carey Hower just proposed, why not just leave the table named as HugeTable with no date marker and just back that up? What they're doing is insane.
I...
--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 3, 2019 at 12:01 pm

#3685634
Reply To: Remove Cursors

To be honest, I'm totally opposed to publishing answers to interview questions that some company obviously feels important about. Such answers would make it pretty easy for other people to...
--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 3, 2019 at 2:42 am

#3685532
Reply To: Getting a List of the Striped Backup Files

Hi Steve...
Thanks for taking the time to write and publish this article. I am curious, though. What is the link to Brent's article?
--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 3, 2019 at 2:24 am

#3685530
Reply To: Index Theories on adding new columns (Not Nullable)

5% doesn't prevent you from rebuilding an index. The settings you pass to your defrag software might.
The term "corrupted" is the wrong term here. The index is not being corrupted. ...
--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 3, 2019 at 1:50 am

#3685527
Reply To: Guaranteed Varchar to Date conversion

Any format containing yyyy-mm-dd can also throw you for a loop if the data had French origins because SQL Server uses YYYY-DD-MM with the French Language.
There is NO WAY to...
--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 2, 2019 at 9:53 pm

#3685471
Reply To: Index Theories on adding new columns (Not Nullable)

What do you mean by "As the data moves on the pages the index is getting corrupted"?
--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 2, 2019 at 9:49 pm

#3685470
Reply To: Deduplicating records from monthly table backups?

Kevlarmpowered wrote:
I have a database that has monthly backups of a table for the past five years... i.e., they copied the table at the end of the month to 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 2, 2019 at 3:49 pm

#3685345
Reply To: Deduplicating records from monthly table backups?

jcelko212 32090 wrote:
Have you looked at archive tools? This is not a SQL job.
Actually, it's the perfect job for SQL Server.
--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 2, 2019 at 3:42 pm

#3685344
Reply To: Why no posts?

To answer both of your questions for what I'm currently doing... 100% on-prem for SQL Server.
As for the MS versions of machine learning in general, the only thing I've done...
--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 1, 2019 at 10:59 pm

#3685157
Reply To: Create index ... online=ON

If I had to guess, my guess would be that they're using the default settings instead of actual settings. That's terrible, of course, but I see little that can 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)

October 1, 2019 at 10:45 pm

#3685156
Reply To: How

Thanks, Luis. I appreciate the feedback. If you get the chance, let us know how it all works out for you even if you don't use the code I posted...
--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 1, 2019 at 9:12 pm

#3685136

Viewing 15 posts - 8,566 through 8,580 (of 59,091 total)