Jeff Moden

Forum Replies Created

Viewing 15 posts - 796 through 810 (of 59,063 total)

Reply To: Size of DB Log File

The problem is very likely that you're simply not doing any log file backups. Full backups do nothing to clear the log file.
If you want to be able to do...
--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 31, 2024 at 12:13 am

#4370433
Reply To: How to Insert array data through storeproceduare

You need single quotes around the data that you're passing for @tempdata. I've added them in Red... one before the starting bracket and one after the ending bracket. Otherwise, your...
--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 30, 2024 at 11:52 pm

#4370418
Reply To: SQL Pivot query help

The method that both Ken and Phil are using is an arcane method known as a CROSSTAB and is a much more flexible manifestation than a PIVOT.
You can read 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)

January 30, 2024 at 11:39 pm

#4370417
Reply To: Combine rows into pivoted output

Another name for "conditional aggregation" is a CROSSTAB. MS use to carry a full entry in BOL on it until they came out with PIVOT. You'll be able to tell...
--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 30, 2024 at 11:30 pm

#4370416
Reply To: Take A Vote and Accept Your Loss

Publish well written standards, Enforce them. Period.
--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, 2024 at 5:06 am

#4368932
Reply To: recovery model for model database

I leave it at FULL because my database backups will try to do log file backups on any database not in the SIMPLE recovery model. That proc is also setup...
--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 24, 2024 at 6:46 pm

#4367179
Reply To: DB with MDF and multiple NDFs vs a single large MDF - all on same Logical Drive.

SteveOC wrote:
Honestly not fussed on the harshness of response if it contributes to moving the discussion forward - obviously meant in good humour.
It does sound like there are different opinions...
--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 23, 2024 at 5:59 pm

#4366523
Reply To: List Procedure That Creates A Table
RonMexico wrote:
I also put something like that together where it would look like this
```
where ([definition] like '%INTO [tableName]%' or ([definition] like '%update [tableName]%')
```
That got me the closest...
--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 23, 2024 at 5:51 pm

#4366521
Reply To: DB with MDF and multiple NDFs vs a single large MDF - all on same Logical Drive.

Phil Parkin wrote:
Jeff Moden wrote:
The real key here is... are people going to carry you down the hall on their shoulders if you make any changes here?
In a coffin?
A bit harsh!
Heh......
--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 23, 2024 at 4:09 pm

#4366488
Reply To: SQL Server 2012 - not accepting new connections on occasion ...

It also sounds like a possible "connection leak" in the applications that are hitting the 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 23, 2024 at 4:01 pm

#4366487
Reply To: SQL to insert row with RefNum to be the next numeric number

Coung wrote:
Unfortunately, I don't have a say about the structure of the table. It's populated via an ETL process. I just want to create dummy data for testing so want...
--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 23, 2024 at 3:59 pm

#4366485
Reply To: List Procedure That Creates A Table

You could just search the "definition" column of sys.sql_modules for the table name with the understanding that it won't find ad hoc queries.
--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 23, 2024 at 3:54 pm

#4366483
Reply To: DB with MDF and multiple NDFs vs a single large MDF - all on same Logical Drive.

The real key here is... are people going to carry you down the hall on their shoulders if you make any changes here? If not, I'd leave it all be. ...
--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 23, 2024 at 3:20 pm

#4366453
Reply To: Does INSERT's affect performance depending on INSERT order?

Jonathan AC Roberts wrote:
Jeff Moden wrote:
Jonathan AC Roberts wrote:
Well you can test that too.
My point is... the OP hasn't identified the scenario accurately enough to even try to determine which kind of...
--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 22, 2024 at 4:57 am

#4365570
Reply To: Learning NoSQL

You missed my point... and that's actually OK. I wasn't suggesting one of the other... I was pointing out that a whole lot of other people do and it's usually...
--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 22, 2024 at 4:52 am

#4365569

Viewing 15 posts - 796 through 810 (of 59,063 total)