Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,261 through 7,275 (of 59,091 total)

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
Reply To: How Much AI Do We Need?

To me, most machines/computers/whatever aren't "intelligent" nor are they able to "learn". At least, not yet. Don't get me wrong... there's some very, very clever programing being done out there...
--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 3:52 am

#3744864
Reply To: Get both Count and the data through single query to reduce time

John Mitchell-245523 wrote:
Jeff Moden wrote:
John Mitchell-245523 wrote:
Jeff Moden wrote:
John Mitchell-245523 wrote:
Have you tried getting the row count from the sys.partitions view?
John
In this case, I think that's a bad idea because that may not match 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 20, 2020 at 7:09 pm

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

Doctor Who 2 wrote:
I hear you, Steve. There's no one-size-fits-all type of AI. Your analogy of cooking and baking is excellent. I'm a terrible cook, so if I were left on my...
--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 20, 2020 at 6:54 pm

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

K. Thanks. I'll keep looking. This one has me stumped so far.

--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 20, 2020 at 6:40 pm

#3744766
Reply To: Get both Count and the data through single query to reduce time

binds wrote:
Yes. I got to know that Rowcount variable will not be updated until the complete control flow completes.
The sql table have millions of records.Is that the reason it is...
--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 20, 2020 at 6:38 pm

#3744765
Reply To: Stored Procedure that joins tables and accepts a parameter to filter the result

kaj wrote:
I don't know that we know that it's Social Security Numbers in clear text, do we? We only know that the name of the column is SSN, I think....
--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 20, 2020 at 5:04 pm

#3744736

Viewing 15 posts - 7,261 through 7,275 (of 59,091 total)