Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,931 through 9,945 (of 59,093 total)

RE: very slow select

ScottPletcher - Thursday, January 24, 2019 1:40 PM
No, you make the existing table a view with exactly the same format as...
--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)

January 27, 2019 at 1:47 pm

#2020229
RE: storing Image in Database (SQL Server ) vs File System

p.s. If you're "stuck" with an older Standard Edition of SQL Server, the partitioning can still be done using Partitioned Views and, IMHO, would be even more flexible overall than...
--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)

January 27, 2019 at 10:00 am

#2020227
RE: storing Image in Database (SQL Server ) vs File System

I have no experience in storing images in the "File System".
I do, however, have a huge amount of experience in storing "images" (WAV files, in my case)...
--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)

January 27, 2019 at 9:55 am

#2020226
RE: Entity Framework & RowVersion

I know this post is old enough where the horse has already left the barn but...
The root of this problem isn't what the Developer wants to design. 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)

January 27, 2019 at 8:11 am

#2020224
RE: BPE Limits

On a bit of a tangent, I find it ironic that BPE probably works best with SSDs and that SSDs may eliminate the need for BPE. I know it's 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)

January 27, 2019 at 7:46 am

#2020222
RE: Are the posted questions getting worse?

TomThomson - Saturday, January 26, 2019 6:57 PM
rodjkidd - Thursday, January 24, 2019 8:28 AM
--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)

January 27, 2019 at 7:35 am

#2020221
RE: sys.dm_db_index_physical_stats

sarahmp - Sunday, January 27, 2019 6:32 AM
Thank you both. The problem was indeed in the quotations.
Thank you for the feedback 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)

January 27, 2019 at 7:27 am

#2020220
RE: Doing the Right Thing

Great article and thoughts, Kathi.
One time after making a really big goof, I thought I was going to catch no end of being yelled at. Still, it was...
--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)

January 26, 2019 at 3:10 pm

#2020200
RE: Fast Enough

Shifting gears a bit but on the same subject, the code at the following link is a prime example of why it takes so long to make changes to 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)

January 26, 2019 at 7:48 am

#2020196
RE: Dim table showing NULL for date field, but source query to load table showing an actual date

This does us no good. You're showing a table missing something and a query that isn't. What you need to show us is the actual code that does the table...
--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)

January 25, 2019 at 6:24 pm

#2020188
RE: Dynamically outputting a set of columns based on another Tables records

jcelko212 32090 - Friday, January 25, 2019 1:39 PM
Weegee2017 - Friday, January 25, 2019 9:57 AM
--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)

January 25, 2019 at 4:25 pm

#2020185
RE: Try Catch Best Practice for Large Stored Procedure

When the step fails, you could have it execute a step to send you an email that the job failed. I typically don't do that, though.
What I end...
--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)

January 25, 2019 at 4:20 pm

#2020184
RE: Are the posted questions getting worse?

Luis Cazares - Friday, January 25, 2019 11:48 AM
drew.allen - Friday, January 25, 2019 9:46 AM
--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)

January 25, 2019 at 4:05 pm

#2020183
RE: DEV - Execution plan IF there were more CPUs

Luis Cazares - Friday, January 25, 2019 2:42 PM
Jeff Moden - Friday, January 25, 2019 2:32 PM
--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)

January 25, 2019 at 4:04 pm

#2020182
RE: TempDB

sqlfriends - Friday, January 25, 2019 2:23 PM
i am not ignoring the problem. Just want to separate the hdhoc, or self -service...
--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)

January 25, 2019 at 2:34 pm

#2020174

Viewing 15 posts - 9,931 through 9,945 (of 59,093 total)