Jeff Moden

Forum Replies Created

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

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

Ken McKelvey - Monday, January 28, 2019 10:16 AM
Thanks for this detailed post; it could affect how we design something later...
--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 28, 2019 at 12:00 pm

#2020319
RE: trying to learn SQL development

deep1 - Sunday, January 27, 2019 11:24 PM
can some one help me learn by asking some questions on query building basically tasks....
--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 28, 2019 at 10:17 am

#2020311
RE: Doing the Right Thing

Geoff.Sturdy - Monday, January 28, 2019 8:21 AM
So what did I learn today from this post ? absolutely nothing about 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)

January 28, 2019 at 9:30 am

#2020298
RE: very slow select

Tomys - Tuesday, January 22, 2019 9:23 AM
Dear sir, I am not sure if this proper for the columns you mentioned...
--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:24 pm

#2020237
RE: very slow select

Jonathan AC Roberts - Tuesday, January 22, 2019 9:50 AM
Tomys - Tuesday, January 22, 2019 9:23 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:11 pm

#2020235
RE: Query tuning with conditional aggregation

We're just guess here. Please post the full DDL for the Exampledb.dbo.SourceTable_EF278 table including all constraints and indexes.
It would also be helpful if you if you provided some...
--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 2:43 pm

#2020231
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

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