Jeff Moden

Forum Replies Created

Viewing 15 posts - 2,881 through 2,895 (of 59,067 total)

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 3 years, 9 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
Reply To: Create week numbers starting from Monday to Sunday

Nomvula wrote:
I need to create a query where the first of March will be Week 1 starting from Monday to Sunday from the date. If the first of the month...
--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 6:54 pm

#4080634
Reply To: SSMS access and code formatting

In the past, we've found a lot of problems with automated deployments that can be described by one, single, four letter word...
"Oops". 😀
--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 4:47 pm

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

I know... I'm weird... I couldn't stop laughing as I read the following article about AI and on-prem. I mean who knew that computationally intense processes on the cloud might...
--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 4:42 pm

#4080591
Reply To: Execution plan help

The Seek is probably a Seek followed by a range scan of the full table, which probably has little if any advantage over the scan. I only use the Execution...
--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 2:26 am

#4080330
Reply To: How to pass a variable in a folder path using TSQL

josetur12 wrote:
Martin, your solution worked.
Thanks,
So I can learn a bit, which one of Martin's replies does that cover?
--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 2:02 am

#4080327
Reply To: SSMS access and code formatting

On the formatting thing, you could try a free website such as PoorSQL.com with the understanding that there is no support if something goes awry. There are other sites that...
--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 24, 2022 at 7:28 pm

#4080274

Viewing 15 posts - 2,881 through 2,895 (of 59,067 total)