Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,911 through 2,925 (of 59,098 total)

Reply To: sys.object

To be honest, we've been bouncing all over the place and you're posting snippets and a whole bunch of things. The only thing that I remember about of of this...
--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)

August 28, 2022 at 1:20 am

#4081269
Reply To: percentage of total trips broken down by month

lin123 wrote:
I have a massive data set which breaks down how many trips were taken on which days of which months for years 2016 & 2017.
What do YOU consider...
--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)

August 27, 2022 at 2:55 am

#4081101
Reply To: percentage of total trips broken down by month

lin123 wrote:
Sorry Phil - still doesn't work. Keeps coming up with syntax error, do you mind explaining to me what the purpose of the over command in line 3 of...
--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)

August 27, 2022 at 12:51 am

#4081087
Reply To: Cancel query and transactions

kuopaz wrote:
I open a new query window in SSMS and execute: EXEC stored procedure. The stored procedure contains BEGIN TRAN and COMMIT / ROLLBACK TRAN.
I hit the cancel button 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)

August 26, 2022 at 10:56 pm

#4081070
Reply To: between is not working the way I would think?

You should read the following article on the performance and other issues having to do with the STR() function.
And to those that say "Sometimes performance doesn't matter"... It always does......
--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)

August 26, 2022 at 7:10 pm

#4081036
Reply To: Clustered Index leaves a lot of empty space

Just as a bit of a sidebar, remember that page compression causes CI rebuilds to take about 3 times longer. I'm NOT saying that makes it not worth it but...
--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)

August 26, 2022 at 7:02 pm

#4081035
Reply To: Clustered Index leaves a lot of empty space

ScottPletcher wrote:
Actually, if you have LOB off-page data, that data will not be moved simply by CREATEing the clustered index on another filegroup.
To be sure, that's one of the many...
--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)

August 26, 2022 at 6:39 pm

#4081027
Reply To: SqL query help

sqlenthu 89358 wrote:
Helo friends, hope everyone is doing good. I am working on a project where I have a big fact table having data for 8 years and has around 8-10...
--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)

August 26, 2022 at 5:12 pm

#4081004
Reply To: SqL query help
sqlenthu 89358 wrote:
ratbak wrote:
You have datetime columns - don't use between!
```
where businessdate between '2022-08-01' and '2022-08-31'
```
means return everything through '2022-08-31 00:00:00.000 (excludes that entire last day 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)
August 26, 2022 at 4:59 pm

#4080995
Reply To: how to change the number of date in the same way collation does for varchar.
I'm not exactly sure what you're asking but, no matter the language, dates and times are stored as (binary data) Integers behind the scenes. How they're presented is totally up...
- This reply was modified 4 years, 1 months ago by Jeff Moden. Reason: Added some clarification
--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)
August 26, 2022 at 3:29 pm

#4080972
Reply To: Clustered Index leaves a lot of empty space

Thanks for the feedback. On this whole thing, remember that planning is the key. Shoot, the first time I did it, I actually drew a picture of what I wanted...
--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)

August 26, 2022 at 3:18 pm

#4080968
Reply To: Self join the table itself

Just to confirm, the code looks like you only have 1 row per week... is that correct?
If so, LAG would would a treat 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)

August 26, 2022 at 2:21 am

#4080703
Reply To: Clustered Index leaves a lot of empty space

p.s. The Sort_In_TempDB thing only takes care of the sorting aspect. You can leave that in if you want but consider the load it puts TempDB under for such 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)

August 26, 2022 at 2:04 am

#4080701
Reply To: Clustered Index leaves a lot of empty space

haahof wrote:
I have a fairly large table, billions of rows, that take up around 3TB of disk. I was tasked with creating a clustered index on this table. I performed...
--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)

August 26, 2022 at 1:55 am

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

I thought "cloud" was a polite way of saying "smoke and mirrors" where your wallet gets smoked and they use mirror to deflect your billing questions. 😀
--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)

August 25, 2022 at 8:05 pm

#4080649

Viewing 15 posts - 2,911 through 2,925 (of 59,098 total)