Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,596 through 8,610 (of 59,098 total)

Reply To: How

Changing Phil's code to handle single digits is easy because of the nature of numeric strings, if your pattern is guaranteed. Except for the comments, the additional test data, 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)

September 30, 2019 at 12:21 am

#3684429
Reply To: In which order should we take the SQL stairways server tutorials?

The listed order of of the stairways have nothing to do with the order of a study plan. They're not collectively meant to be an "overall stairway" to learning SQLServer...
--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)

September 29, 2019 at 4:37 am

#3684363
Reply To: How

Phil's code works great for this but I do have a question...
Is there any chance of having less or more than 2 digits on either side of 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)

September 28, 2019 at 10:45 pm

#3684331
Reply To: Printing Dates

I think this question is an excellent example of why you should never rely on defaults. 😉
--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)

September 27, 2019 at 2:23 pm

#3684052
Reply To: Need advice for logs

jbeclapez wrote:
You pointed at me something I should have mentionned in my first post. Sorry : "That's a business decision, not a technical one"
We are OK to loose a day...
--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)

September 27, 2019 at 2:20 pm

#3684050
Reply To: Tried to pivot... but it executes faster when it is hardcoded

For the final result, do you need the format you've portrayed for the monthly column names or can we economize and clean those up a bit. For example, you have...
--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)

September 27, 2019 at 2:02 pm

#3684039
Reply To: How can a db_datareader database role create a table?

You say you were "about" to create a new table. Did you actually try to finish that task?
--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)

September 27, 2019 at 5:07 am

#3683842
Reply To: Catching a "kill job" event from within a SSIS package executed by that job.

Thanks, Sam. If you have the time, it would be interesting to know how you resolved the problem.
--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)

September 25, 2019 at 9:07 pm

#3683447
Reply To: What value need to be set for MAXDOP ?

Thanks for the feedback, Sam. I'd love to hear what you end up 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)

September 25, 2019 at 8:59 pm

#3683444
Reply To: Database mail not working.

trgrassijr wrote:
Thank you
I figured it out
It was the Server name was incorrect. The MSTDC setup on the Cluster was wrong after correcting that email starting working.
Thanks again for all 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)

September 25, 2019 at 8:56 pm

#3683441
Reply To: ASCII sql server

larimin55 wrote:
I want to block exponential numbers in sql, how can i do this?

I don't know because I don't know what you mean by "exponential numbers" nor what such numbers...
--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)

September 25, 2019 at 2:22 am

#3683163
Reply To: How to check the log of Export Import database wizard

I have to ask... what does the Export/Import Wizard have to do with a Database Restore?

A Database Restore should show up in the SQL Server 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)

September 25, 2019 at 2:14 am

#3683162
Reply To: User accounts

Ah... got it, Sue. It looked like you were referencing my reply. Sorry.
--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)

September 25, 2019 at 1:49 am

#3683159
Reply To: Database mail not working.

You don't give us much to go on except to say it's broke.
With that in mind, check the profile(s) and make sure one of them is setup as a default.
--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)

September 25, 2019 at 1:48 am

#3683158
Reply To: MERGING RECORDS

Itzik Ben-Gan wrote an incredible article on this subject. You can find it at the following URL:
https://blogs.solidq.com/en/sqlserver/packing-intervals/
Because you're not using SQL Server 2012 or above, we can't use his...
--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)

September 25, 2019 at 1:38 am

#3683157

Viewing 15 posts - 8,596 through 8,610 (of 59,098 total)