Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,771 through 4,785 (of 59,101 total)

Reply To: Indexes deleted

juliava wrote:
Is it anyway to see if ever existed in table, and if they did, how/when they were deleted?
If it happened kind of recently, you could read the transaction log...
--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)

August 25, 2021 at 5:11 pm

#3923967
Reply To: Is that a reason DBA should Install SQL Server

It IS small and I love it.
What do you folks do where you need 750 servers and half of those are "prod"?
--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)

August 25, 2021 at 4:59 pm

#3923958
Reply To: Capture Login activity

Michael L John wrote:
Why don't you ask this question in the original thread?
That's almost funny, Michael... how many times have we seen people say "start a new thread for a different question"...
--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)

August 25, 2021 at 3:47 am

#3923713
Reply To: SQL Function

Hello and welcome aboard. To get some really good help quickly, please read the article at the first link in my signature line below for how to create "readily consumable...
--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)

August 25, 2021 at 3:32 am

#3923712
Reply To: Is it possible to migrate a solution from SSMS to SSDT?

I don't use "solutions" in SSMS. They just seem to make life difficult. That's not a personal bit of experience, though. I never knew about them for the longest time...
--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)

August 25, 2021 at 3:26 am

#3923711
Reply To: Copy an existing table to a new table...

In SQL Server, you have a couple of things working against you.
A table starting with a numeric digit is against the "normal naming convention" for objects in SQL server. 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)

August 25, 2021 at 3:21 am

#3923710
Reply To: Generate script

wrote:
I also have the same case, thanks for this solution!
Uh-huh... Sounds like a precursor to spam.
--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)

August 24, 2021 at 6:37 pm

#3923614
Reply To: Not getting expected index seek.

Looking at the Clustered Index for the oeordlin_sql table, I'm a wee bit concerned (especially for insert and update performance) over having the leading column be in the "ultra low...
--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)

August 24, 2021 at 6:34 pm

#3923608
Reply To: Detach - reattach database on a new drive on same server

I do the same as what Anthony posted.
There might be at least one caveat to be aware of. My disclaimer is that I've not had to try it and I'm...
--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)

August 24, 2021 at 5:59 pm

#3923598
Reply To: Is that a reason DBA should Install SQL Server

Our situation appears to be quite a bit different than yours (and no... neither is wrong, IMHO... they're just different because of different business requirements). My best friend, who 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)

August 24, 2021 at 5:47 pm

#3923593
Reply To: Advantage of having multiple files is a filegroup designated for LOBs ?

I've probably just not had enough coffee yet, Johan, but the data you posted doesn't look like a performance comparison to me. It looks like measurements from a single run.
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)

August 24, 2021 at 4:00 pm

#3923551
Reply To: A Lack of Error Handling

Kazoo1989 wrote:
Our company uses EF and stored procedures with error handling. Our standard is to require Try/Catch blocks in all stored procedures. While I agree with Jeff Moden's point 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)

August 24, 2021 at 7:20 am

#3923387
Reply To: Is that a reason DBA should Install SQL Server

Correct. We never do multiple named instances on a server. Heh... they still haven't found the body of the last person that tried to do that on our servers. 😀
Instead...
--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)

August 24, 2021 at 7:12 am

#3923385
Reply To: Update stats

If you are using REORGANIZE on any rowstore index that is fragmenting, STOP IT! PERIOD!. REORGANIZE does not work like you probably think it works. It can 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)

August 23, 2021 at 10:42 pm

#3923317
Reply To: Are the posted questions getting worse?

Luis Cazares wrote:
Count me as one of the people that left because of the changes in the site. I keep coming to read the thread, but with the decline of questions...
--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)

August 23, 2021 at 9:32 pm

#3923301

Viewing 15 posts - 4,771 through 4,785 (of 59,101 total)