Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,756 through 4,770 (of 59,098 total)

Reply To: grouping rows into sets

Thanks, JLS... your answers are great... especially the implied answer of "you're all set". I can "play" at my leisure, which I have disturbingly little time to do lately because...
--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 26, 2021 at 2:26 pm

#3924215
Reply To: grouping rows into sets
Shifting gears back to your good question, I'm curious...
1. What are you going to do with the t_Group and t_no columns once they've been generated?
2. How often will you need...
--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 26, 2021 at 5:18 am

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

The company I work for only has me. I do get some good help hardware wise from the Infrastructure Group and they're the ones that copy backups to tape, etc,...
--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 26, 2021 at 5:02 am

#3924100
Reply To: Indexes deleted

Heh... good lord. It's been so long since I looked at that built in report that I'd forgotten a couple major (IMHO) flaws it has...
First, It does NOT report 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)

August 26, 2021 at 4:30 am

#3924094
Reply To: Indexes deleted

Be VERY aware that the Schema Changes History report is based on the "Default Trace". The default trace "file" is actually incredibly small. Even with the 6 they roll through,...
--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 26, 2021 at 4:08 am

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

@stephen.aa ,
The bottom line here is that it looks like you might be coming to SQL Server from Oracle and I'll tell you that SQL <> SQL and, for sure,...
--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 26, 2021 at 4:00 am

#3924090
Reply To: private messages gone

That and the also-prevviously-reported-fact that "Followers" and "Following" have also disappeared. Are you good folks actually doing anything to fix this and doing something to prevent such things from happening...
--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 6:28 pm

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

frederico_fonseca wrote:
big financial group - lots of sub companies/teams
Do YOU maintain all of those servers or do most of the sub-companies have someone taking care of business for their own...
--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 6:22 pm

#3923991
Reply To: Create a delta from downloaded info

Bruin wrote:
When I run the piece for creating #staging:
Column name or number of supplied values does not match table definition.
Thx,
I'd gotten interrupted while I was working on the code. 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 25, 2021 at 5:58 pm

#3923985
Reply To: Not getting expected index seek.

Jackie Lowery wrote:
Jeff Moden wrote:
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...
--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:36 pm

#3923979
Reply To: grouping rows into sets

Heh... Welcome back again, JLS. As you can see, some things haven't changed. 😉
--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:21 pm

#3923972
Reply To: Complete permissions script

Tom Uellner wrote:
You can do something like this with dbatools.
http://www.dbatools.io
A little bit of PowerShell and you can script out all you're looking for.
Since there are a whole lot of individual...
--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:14 pm

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

Viewing 15 posts - 4,756 through 4,770 (of 59,098 total)