Forum Replies Created
Viewing 15 posts - 3,751 through 3,765 (of 59,087 total)
-
Reply To: Error - A call to 'LogonUserW' failed with error code: '1909'
It sounds like you have to rebuild the "proxy" account to make it work.
And using xp_CmdShell isn't a "terrible security practice". Giving non-DBA users the privs to run it directly...
--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) -
Reply To: Permissions for Extended Events
BWAAA-HAAA-HAAA!!! (Sorry... couldn't help the laugh).
--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) -
Reply To: Are the posted questions getting worse?
Congratulations on the retirement. I've just about given up on SO. Discussions are discouraged... unless you happen to be a moderator. 🙁
--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) -
Reply To: Are the posted questions getting worse?
Shifting gears a bit... the following message started showing up on my machine some time ago (seems like at least a week) on every post thread and ONLY for this...
--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) -
Reply To: some rows go missing once in a while when querying for a batch
This all seems like it''s "just" a process timing issue and you haven't figured out the actual cause, yet. Is the process the creates the row actually finishing on 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) -
Reply To: SQL Select only business hours data
yogi123 wrote:Hi there,
I have task to select only data falls within business hours, meaning 9 am to 5 pm
CREATE TABLE #TEMP
(ID INT, LOADDATE DATETIME)
INSERT INTO #TEMP
SELECT 1,'2022-03-24...--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) -
Reply To: Multiple data types in column
Just store everything as FLOAT. Integers are exact when converted to Floats so long is you don't violate the precision. Better yet, change both to be Decimal(38,15).
Then ask yourself if...
--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) -
Reply To: Are the posted questions getting worse?
Steve Jones - SSC Editor wrote:SPAM is a problem now, and it's not a simple one. I've filed a ticket to work with the third party on what is not catching more than 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) -
Reply To: Create a Free Azure Account
"Give 'em the razor; sell 'em the blades"
--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) -
Reply To: Are the posted questions getting worse?
Thank all of you folks for the congrats and the well wishes. I'm just one person, though. This site wouldn't be worth a hill of beans without the rest 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) -
Reply To: Are the posted questions getting worse?
RBarryYoung wrote:
Geez, 1 MILLION?!?! Will this guy never stop talking?!?
Wow! Mr. R. Barry Young... source of the term "Pseudo Cursors" for me. How the heck are 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) -
Reply To: Is CosmosDB the One?
Steve Jones - SSC Editor wrote:Jeff Moden wrote:From the Article:
"I'd love to be able to insert data into a table, have it not available as a live value until committed on other nodes, 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) -
Reply To: Serious performance issue with our DR cloud site for iSeries AS400 ETL testing.
Something surprising shot people in the head on our AS400's prior to them upgrading to the new "Power Systems", also by IBM. They lasted a really long time and, one...
--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) -
Reply To: Serious performance issue with our DR cloud site for iSeries AS400 ETL testing.
Awesome. Thank you for the comeback on your own post. We may be going through something like what you did in the very near future and I've just book marked...
--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) -
Reply To: Looking to help DBA's and learn some SQL Server skills
To add to what Brian said, I've been a Director of MIS, a Software Development manager, and a couple of other highfalutin sounding titles and I'm kinda good at SQL...
--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)
Viewing 15 posts - 3,751 through 3,765 (of 59,087 total)