Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,076 through 6,090 (of 59,072 total)

Reply To: SSRS 2019 reports are painfully slow

Network? Busy-ness of the machine it's 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)

November 16, 2020 at 5:57 pm

#3808384
Reply To: The Virtual Experience

david.edwards 76768 wrote:
David.Poole wrote:
I'm not good with time management. No matter what I am doing I feel I should be doing something else. This means that I am easily distracted. 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)

November 16, 2020 at 5:02 pm

#3808378
Reply To: IF IF IF versus IF Condition 1 and condition 2 and condition X
YSLGuru wrote:
I really hope this isn't a dumb question. Is there a reason other then style or preference as to why you'd do this:
```
IF @Var1 = @VarA...
```
--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)
November 16, 2020 at 4:46 pm

#3808361
Reply To: Daily Counts by Month based on Start/End date
SwePeso wrote:
My goal was to demonstrate you don't need two cross apply.
```
SELECT          SUBSTRING(CONVERT(CHAR(9), DATEADD(MONTH, DATEDIFF(MONTH, 0, t.thedate), 0),...
```
--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)
November 16, 2020 at 4:30 pm

#3808348
Reply To: The Virtual Experience

David.Poole wrote:
I'm not good with time management. No matter what I am doing I feel I should be doing something else.
This will sound strange but I'm actually really happy 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)

November 16, 2020 at 1:36 pm

#3808272
Reply To: Daily Counts by Month based on Start/End date

I'm actually quite a bit surprised at you using an incremental recursive CTE for this, Peter. Your code runs in < 1ms like the other two do but your code...
--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)

November 16, 2020 at 1:18 pm

#3808263
Reply To: Daily Counts by Month based on Start/End date

Using Steve's good test data, here's a slightly different method, which also provides the MMM DD format requested in the original post. It's also the very first time that 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)

November 16, 2020 at 7:50 am

#3808186
Reply To: Using If exists trying to assign the value to a variable when it exists.
Just my 2 cents...
```
 SELECT parent.*
        ,NewCol = CASE WHEN oa.Cnt > 0 THEN 'Mixed' ELSE 'Real' END
  ...
```
--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)
November 16, 2020 at 6:22 am

#3808173
Reply To: Can we know the detailed information of a table ?

892717952 wrote:
Jeff Moden wrote:
Ah, but it appears that may be operating under a really bad premise. Changing a VARCHAR(200) to a VARCHAR(100) will, by itself, DO NOTHING to save on space. ...
--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)

November 14, 2020 at 2:25 am

#3807751
Reply To: Can we know the detailed information of a table ?

Ah, but it appears that may be operating under a really bad premise. Changing a VARCHAR(200) to a VARCHAR(100) will, by itself, DO NOTHING to save on space. The only...
--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)

November 13, 2020 at 10:33 pm

#3807705
Reply To: Out of date Statistics

You, sir, are preaching to the choir. I wish your DBA understood the actual value of those system generated column stats.
--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)

November 13, 2020 at 9:37 pm

#3807689
Reply To: Can we know the detailed information of a table ?

892717952 wrote:
Jeff Moden wrote:
892717952 wrote:
I want if we can know how many pieces of data can be saved for each data page. thanks!
Thank you but the question above is basically...
--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)

November 13, 2020 at 1:06 am

#3807364
Reply To: Out of date Statistics

I hate blanket statements like what you say your DBA said. If he said that, he's wrong. Building enough indexes to negate the need for ANY such column statistics would...
--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)

November 12, 2020 at 6:48 pm

#3807268
Reply To: Table Performance Issues

Please see the following link...
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?view=sql-server-ver15
... and then search on that page for the words "doesn't reclaim" to answer your questions on why some of your actions made no difference.

--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)

November 12, 2020 at 2:57 am

#3807041
Reply To: Can we know the detailed information of a table ?

892717952 wrote:
I want if we can know how many pieces of data can be saved for each data page. thanks!
Thank you but the question above is basically just 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)

November 12, 2020 at 1:41 am

#3807030

Viewing 15 posts - 6,076 through 6,090 (of 59,072 total)