Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,231 through 7,245 (of 59,072 total)

Reply To: Entity Relationship diagram - Path and Node entities

boolean wrote:
I do this in order to store an XML path
To be honest, that sounds like a slow and possibly error prone process being made to be slower and more...
--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)

April 23, 2020 at 4:56 pm

#3745741
Reply To: Design question on Columnstore indexing implementation.

VoldemarG wrote:
If my table has 1 Clustered Index (PK), and a dozen of non-clustered row-store indexes.
I drop constraint... (existing PK/Clustered Index), Create Clustered Columnstore index on the table.
After this should...
--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)

April 23, 2020 at 2:57 pm

#3745668
Reply To: Multi-Select Parameters with Large Number of Values

I'll second Grant's recommendation on Gail's articles. Personally, I consider them to be THE "Goto" articles on the subject especially since she's keen not only about performance but also on...
--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)

April 23, 2020 at 2:53 pm

#3745666
Reply To: Finding Lowercase Characters

Robert Sterbal wrote:
Just curious how many of us use case insensitive fields?
I generally have no need for case sensitive data. However, if I did, I'd likely NOT make the whole 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)

April 23, 2020 at 2:32 pm

#3745664
Reply To: A Solution for the Bin Packing Problem

First, and to be sure, I always appreciate anyone that steps up to the plate with an article, especially on such a topic.
I agree with Aaron. This is NOT 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)

April 23, 2020 at 2:03 pm

#3745650
Reply To: Agent Job never ending
I'll also add....
1. Might need an update on statistics.
2. Different or missing indexes.
3. Skewed data.
--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)
April 22, 2020 at 7:43 pm

#3745463
Reply To: SELECT Slow in production

ian 29141 wrote:
The run took just as long when using the CE alias in the update.
If you're running what you posted, it's not actually running. Like I said in my previous...
--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)

April 22, 2020 at 5:01 pm

#3745413
Reply To: Bulk Restore Issues

It's amazing to me how the visceral fear from the /90s and early 2Ks about xp_CmdShell still continues. Disabling xp_CmdShell does nothing for security except provide a 3ms speedbump in...
--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)

April 22, 2020 at 4:57 pm

#3745411
Reply To: Link Server

My question would be.... why do you NEED to go through the intermediate server to begin 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)

April 21, 2020 at 11:02 pm

#3745183
Reply To: Parameterizing database name in update query

You could create a synonym that points to a database, run your code, drop the synonym, recreate it pointing to another database, run the code, wash-rinse-repeat. It's dynamic without having...
--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)

April 21, 2020 at 11:00 pm

#3745177
Reply To: Bulk Restore Issues

Mr. Brian Gale wrote:
So mapping the drive with "net use" will map the drive for you not the SQL Server Service account.
You're absolutely correct about "net use" assigning according to the current...
--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)

April 21, 2020 at 10:56 pm

#3745176
Reply To: SELECT Slow in production

First of all, you define some variables and then do an insert and then you break the batch with a GO. That should mean that when you get to 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)

April 21, 2020 at 10:52 pm

#3745175
Reply To: How Much AI Do We Need?

I guess we'll have to agree to disagree on most of that.
--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)

April 21, 2020 at 10:32 pm

#3745172
Reply To: Real columns are comma separated instead of dot separated ?

gormus wrote:
Ok, found out what's causing it, but it doesn't make sense to me.
I ran my code on my other machine, which has SSMS v18.4. My code works fine, 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)

April 21, 2020 at 10:29 pm

#3745167
Reply To: Server Side SSMS

I cannot speak for others but me being almost permanently RDP'd into the server with an active session of SSMS already up and running has saved our caboose a couple...
--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)

April 21, 2020 at 4:12 am

#3744866

Viewing 15 posts - 7,231 through 7,245 (of 59,072 total)