Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,571 through 3,585 (of 59,098 total)

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
Reply To: most efficient way to compare columns across separate tables

What is the primary key on these tables? And, are you really using 2019? If not, what version?
--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 2, 2022 at 11:48 pm

#4025714
Reply To: Downgrade SQL Server 2016 from Enterprise to Standard

Did you look?
https://www.google.com/search?q=downgrade+sql+server+enterprise+edition+to+standard+edition

--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 2, 2022 at 11:40 pm

#4025713
Reply To: RAM increase on server and sql instance

What size is your largest index, what Recovery Model are your databases in, and what, if any, index maintenance do you 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)

May 2, 2022 at 10:21 pm

#4025689
Reply To: How to add background color of row based to existing SP/query

SQLisAwe5oMe wrote:
Thank you Jeff, this is helpful.
You bet... thank you for the feedback. It also has one of the (IMHO) better SQL Tutorials (Not to mention the HTML and other...
--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 2, 2022 at 7:15 pm

#4025633

Viewing 15 posts - 3,571 through 3,585 (of 59,098 total)