Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,556 through 3,570 (of 59,087 total)

Reply To: SQL 2012 through 2019 in-place

fujitora19 wrote:
I've downloaded SQL Server Standard 2019 to upgrade our database because we have a Microsoft Campus Agreement, but I'm being asked for a license for SQL Server 2019 Reporting...
--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)

May 8, 2022 at 10:17 pm

#4029174
Reply To: DELETE

Is there more than 1 such occurrence per row in the table and what is the datatype of the column that this type of data is 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)

May 8, 2022 at 10:08 pm

#4029173
Reply To: Cummulative Updates in SQL 2017 & Free space calculataions

ramana3327 wrote:
If you have SSAS also installed with Database services on the server, do you need to apply cumulative updates separately or it will give you the option to select...
--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)

May 8, 2022 at 10:02 pm

#4029172
Reply To: NT Authority/System User failed to open Model database

ramana3327 wrote:
All jobs are running as sa only.
Just to ask the question, you DO have the "sa" login disabled, correct? And, yes, jobs can still run with sysadmin privs...
--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)

May 7, 2022 at 11:37 pm

#4028832
Reply To: Cummulative Updates in SQL 2017 & Free space calculataions

How did you know the answer to your latter question for SPs? If it isn't included in the documentation for the CU, then you have to assume that you need...
--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)

May 7, 2022 at 11:33 pm

#4028831
Reply To: Standards Matter

Without some form of enforcement, standards don't matter at all except, possibly, when it comes to needing a reason to fire someone. Urgencies are not justification not to follow 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)

May 7, 2022 at 11:18 pm

#4028813
Reply To: Login failed for user windows user and SQL user

Ed B wrote:
When we have a new server (aws so we create and delete them fairly often) and I am a local admin, but have not been granted sql access, 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)

May 7, 2022 at 10:21 pm

#4028805
Reply To: How is he seeing all the databases

Shot in the dark but, possibly an easy way to find out how he has access is to create a user using his windows login name and then use xp_logininfo...
--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)

May 6, 2022 at 11:12 pm

#4028372
Reply To: Flattening of hierarchy

To be honest, CTEs can suck real bad. They're not so bad at Hierarchies but, still, a well written While loop will be a little bit faster than a CTE...
--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)

May 6, 2022 at 11:06 pm

#4028369
Reply To: case when with count ms sql

ScottPletcher wrote:
Jeff Moden wrote:
... ,PercentOfWhole = CONVERT(DECIMAL(3,1),StatusCount*100.0/SUM(StatusCount) OVER ()) ...
I believe you want decimal(4, 1) rather than (3, 1) (at least I can't see any reason why 100% of 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)

May 4, 2022 at 6:01 pm

#4026806
Reply To: Voting for Sessions on GroupBy.Org closed and schedule published!

Heh... right after I posted above, I got an email from GROUPBY.Org that the schedule has been published. There are two tracks for the Americas on May 24th and two...
--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)

May 4, 2022 at 5:33 pm

#4026801
Reply To: Voting for Sessions on GroupBy.Org closed and schedule published!

My "Black Arts" Index Maintenance 1.2 presentation was selected on GroupBy.Org for May 24th, 2022. I don't know if my "ask" above had anything to do with that but 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)

May 4, 2022 at 5:21 pm

#4026762
Reply To: Case When statement When I assign a string, it say Conversion Failed from varcha

First of all, you didn't actually post the error you're getting.
Second, what are the datatypes for all of the columns involved"? That's actually super important to know here.
--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)

May 4, 2022 at 3:56 pm

#4026721
Reply To: case when with count ms sql
Here's another way to post "Readily Consumable Date" followed by a different solution that uses the SUM() Windowing Function.
Here's the test data construction...
```
--===== Create the test 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)
May 4, 2022 at 3:44 pm

#4026718
Reply To: case when with count ms sql

TheNewbie wrote:
Honestly, I don't end up with the #t, ct etc.
I tried to replace anything regarding my data but didnt work
Sorry
The #t that Phil is using is what you should...
--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)

May 4, 2022 at 3:24 pm

#4026708

Viewing 15 posts - 3,556 through 3,570 (of 59,087 total)