Jeff Moden

Forum Replies Created

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

Reply To: Calendar report for SQL Agent Jobs - what GUI do you recommend?

You say you want it to be displayed "just like the calendar entries are shown on a regular calendar". If you have 500 to 1000 jobs on a server lie...
--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 21, 2021 at 3:53 pm

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

First round of testing to 1, 2, 4, and 8 files on a single SSD drive of a minimally logged, single connection insert of 10,000,000 rows @89GB of a table...
--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 21, 2021 at 8:51 am

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

Heh... an early look scared-up the ol' "not unless they're on different physical spindles" adage. While I logically agree with that, I've never actually tried it and so I don't...
--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 21, 2021 at 5:36 am

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

Getting back to the original question, we're just guessing based on related information supposed "Best Practice" information and, by now, I'm sure everyone knows how I feel about "Best Practice"...
--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 21, 2021 at 5:16 am

#3922338
Reply To: A Lack of Error Handling

Just like index maintenance and a couple of other things, it's better to NOT do something than it is to do it wrong and, thanks to the poor examples 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 21, 2021 at 4:50 am

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

Brandie Tarvin wrote:
It's Friday. I've been overwhelmed for several days and now I'm just confused. Help here appreciated:
https://www.sqlservercentral.com/forums/topic/mysterious-ability-to-drop-create-stored-procedures
It's late, so I might be missing something here. Are you saying that...
--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 21, 2021 at 4:29 am

#3922334
Reply To: How to split string and separate the data with numbers and text

Ok. First, I cleaned up the code that provides the test table and data generation so it's easier to read/verify. I also changed it from a table variable to a...
--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 20, 2021 at 6:26 pm

#3922220
Reply To: How to split string and separate the data with numbers and text

Missed David's post, which he posted while I was still writing.
--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 20, 2021 at 5:01 pm

#3922206
Reply To: How to split string and separate the data with numbers and text

sqldevlearn wrote:
Here is the fiddle http://sqlfiddle.com/#!18/334d74/1/0
If you've not solved this yet, especially with the special condition for things like "30_000" where the underscore is actually a space, and no 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)

August 20, 2021 at 2:57 pm

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

Johan Bijnens wrote:
They are still image and text data types (legacy industrial tech "we will not change it for you" salesperson ). Out of row by default if I'm correct., but...
--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 20, 2021 at 2:54 pm

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

As a bit of a sidebar, if you're going to store LOBs in the database, do yourself a favor... force them to behave as they did with the old style...
--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 20, 2021 at 12:31 pm

#3922101
Reply To: How to split string and separate the data with numbers and text

Hettinger wrote:
Generic Formula to Get Position of First Number in String:
=MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},String_Ref&"0123456789")
In which dialect of SQL? That will not work in T-SQL (SQL Server).
--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 20, 2021 at 11:43 am

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

P Jones wrote:
Apologies in advance for the rant but I'm fed up with developers who go to great lengths to re-invent the wheel simply because they don't know how 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)

August 19, 2021 at 7:39 pm

#3921857
Reply To: How to get the detailed record and summary value at the same time

892717952 wrote:
Sorry! next time if have the same question I'll provide sample data, thanks!
So, you're happy with the answers you got on this thread?

--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 19, 2021 at 7:31 pm

#3921855
Reply To: Running SQL batch file, need confirmation of execution

Erland Sommarskog wrote:
As for T-SQL job step vs. running the .Bat file, that discussion is a little more complex. It could be that NorthernSky needs to run the same set 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)

August 19, 2021 at 7:28 pm

#3921854

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