Jeff Moden

Forum Replies Created

Viewing 15 posts - 1,711 through 1,725 (of 59,067 total)

Reply To: Use a flag, or calculate, to retrieve counts

Steve Collins wrote:
Imo it depends on whether or not Approved is exactly equivalent to Taken. Could a user be officially approved and yet not take the day? If there's an exact...
--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)

March 14, 2023 at 9:29 pm

#4160773
Reply To: system_versioning = on/off permissions

With the proviso that I don't know the exact situation...
The purpose of such a table is to audit what's happening to the data, no matter what. Are you absolutely 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)

March 14, 2023 at 9:22 pm

#4160771
Reply To: system_versioning = on/off permissions

as_1234 wrote:
All,
I would like to give a user permission to set system_versioning on or off on a table. I know that one way to do this is to give them...
--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)

March 14, 2023 at 6:57 pm

#4160706
Reply To: Automation of t-sql executions requests.

Thanks, for the feedback, Warren. I was worried for ya! 😀
--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)

March 14, 2023 at 6:21 pm

#4160692
Reply To: Commvault thinks log chain broken, launches full backup during business day

Yowch. That doesn't seem right. Thank you for the feedback.
--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)

March 14, 2023 at 6:19 pm

#4160691
Reply To: SQL Repeating Node

I don't use SSRS so I ask the following question in earnest... why do you need to use XML for this 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)

March 14, 2023 at 5:28 pm

#4160680
Reply To: Commvault thinks log chain broken, launches full backup during business day

As a bit of a sidebar, have you checked for code that either takes a backup somewhere outside of CommVault and have you checked to make sure no one wrote...
--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)

March 14, 2023 at 5:25 pm

#4160679
Reply To: Triggers In Sql

The example posted is the beginning of a RBAR trigger. INSERTs in SQL Server will fire the trigger only once per INSERT even if the INSERT inserts thousands of rows. ...
--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)

March 14, 2023 at 4:19 pm

#4160632
Reply To: Stop deployment of SQL DACPAC if there is DROP statements

Does this mean that, ultimately, the new code will go essentially directly from the Developer to Prod without going through QA and UAT. If so, that's a really, really bad...
--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)

March 14, 2023 at 4:11 pm

#4160631
Reply To: Automation of t-sql executions requests.

Warren Peace wrote:
We get a bunch of tasks/requests to run t-sql scripts to update views or stored procs or bad data.
Does anyone know of a server product that can automate 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)

March 14, 2023 at 3:42 pm

#4160623
Reply To: How to make sure for each ID there was no records exists with text

jcelko212 32090 wrote:
And this is why we want posters to always put the DDL for their tables where we can see them. After 30+ years of doing SQL and RDBMS, 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)

March 14, 2023 at 4:32 am

#4160393
Reply To: How to make sure for each ID there was no records exists with text

jcelko212 32090 wrote:
I am assuming that the foobars have a key made of the foo_description in the foo_id.
SELECT foobar_id
FROM Foobars
WHERE foobar_description IN ( 'Apex', 'Bill', 'Sierra' )
GROUP BY foobar_id
HAVING COUNT (*)...
--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)

March 13, 2023 at 6:18 pm

#4160250
Reply To: Sql server data export to csv with 100,000 row filesize limit

FlyingSquid wrote:
I'm using sql statements to query data from multiple tables and exporting them into csv files, then importing that file somewhere else.
I have to ask "Why" here. What 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)

March 12, 2023 at 7:41 am

#4159815
Reply To: Stored Procedure to Output CSV from Select Query

water490 wrote:
Jeff Moden wrote:
It doesn't close any "security hole". Only the people that can enable it can use it. Turning it off won't prevent that.
As to your "access denied" error, where...
--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)

March 12, 2023 at 7:32 am

#4159813
Reply To: Sources of Inspiration

mschluper wrote:
Meeting customers' needs. That's all I want.
Any technology push stinks. And resume building is detestable.
We are here to serve. If we can't relate our activities to a specific customer...
--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)

March 12, 2023 at 7:25 am

#4159806

Viewing 15 posts - 1,711 through 1,725 (of 59,067 total)