Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,786 through 7,800 (of 59,072 total)

Reply To: SQL Account cannot see the user database

Ed7 wrote:
I have inheritance SQL Server environment where the Server team, etc wanted to be System Admin on the SQL Server.
They might perform some upgrade.
And, I found the work-around.
https://support.microsoft.com/en-us/help/2163980/fix-the-sql-server-service-cannot-start-after-you-install-cumulative-u
That link...
--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)

February 4, 2020 at 2:30 am

#3722804
Reply To: Scientific number in varchar column

GrassHopper wrote:
Jeff, that would be the best case scenario, but we get many clients that give to us as is and don't want to do more. It is in excel...
--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)

February 4, 2020 at 2:25 am

#3722803
Reply To: Very large t-log with backups

Wow. Just WOW! Thanks for the feedback on what you found, Greg.
--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)

February 4, 2020 at 2:16 am

#3722802
Reply To: SQL Account cannot see the user database

Ed7 wrote:
Someone create a SQL Login and grant DBO permission to a user database "AppDB1".
I apologize for asking such an obvious question but have you actually verified that happened correctly? ...
--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)

February 3, 2020 at 3:08 pm

#3722632
Reply To: Surrender, Just a Little

I agree... I hate the "blame game". That's why I get pissed off when people, who frequently don't know much about databases, blame the DBA for being a supposed bottle-neck...
--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)

February 3, 2020 at 2:59 pm

#3722620
Reply To: Surrender, Just a Little

I absolutely agree that cooperation leads to learning. That's why I sit with the Developers and have a symbiosis with them. Cooperation does not mean letting bad stuff happen 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)

February 3, 2020 at 2:00 pm

#3722597
Reply To: Recruitment question

My favorite IT related job posting of all time was also the shortest, most honest, and most accurate one I've ever seen...
HELP WANTED
"Basically, we want someone that can look at...
--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)

February 2, 2020 at 8:37 pm

#3722430
Reply To: Surrender, Just a Little

GeorgeCopeland wrote:
Grant Fritchey wrote:
When the business overrides you, there really isn't much you can do. Education is key. However, I'm still very much on the side of being part 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)

February 1, 2020 at 3:16 am

#3722196
Reply To: Surrender, Just a Little

oogibah wrote:
GeorgeCopeland wrote:
Maybe you are right but I think there is also a cultural issue. A good default pose for a developer might be as a collaborator who wants data to...
--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, 2020 at 10:57 pm

#3722178
Reply To: Scientific number in varchar column

Phil Parkin wrote:
MVDBA (Mike Vessey) wrote:
sigh... my heart dies a little bit when we ignore the option of getting a provider of data to make it useable , I know they are often...
--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, 2020 at 3:39 pm

#3722059
Reply To: Scientific number in varchar column

GrassHopper wrote:
Jeff, that would be the best case scenario, but we get many clients that give to us as is and don't want to do more. It is in excel...
--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, 2020 at 3:36 pm

#3722057
Reply To: Parallel Load thousands csv Files

Thanks, Nicole. I'm sorry I missed this yesterday and today. I'm prepping for an SQL|Saturday that I'm driving to tomorrow and won't be back until Sunday. I'll give it 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)

January 31, 2020 at 4:07 am

#3721874
Reply To: Slow running "ranking" problem

jcelko212 32090 wrote:
To add to what Jeff said, it's really not that hard to write a bunch of stored procedures for the nested set model. I published a few of these...
--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, 2020 at 4:00 am

#3721871
Reply To: Scientific number in varchar column

What you really need to do is get with the people that are providing the data and have them give it to you correctly. Having some number like 9.38357E+27 isn'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)

January 31, 2020 at 3:38 am

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

Grant Fritchey wrote:
jonathan.crawford wrote:
But have either of you ever been to Belgium?
Let's just say, mussels, mayo on fries and a tripel is one of my favorite meals on the planet.
Mayo on...
--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, 2020 at 2:59 am

#3721852

Viewing 15 posts - 7,786 through 7,800 (of 59,072 total)