Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,561 through 4,575 (of 59,087 total)

Reply To: how much memory that we need for SQL

WhiteLotus wrote:
Hi All,
Our server has a Datawarehouse database is like 600 GB ( 500 GB for data file only ) and memory is ONLY 8 GB ( 5 GB for...
--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)

September 30, 2021 at 12:52 am

#3934848
Reply To: Adding a PRIMARY KEY CLUSTERED

DaveBriCam wrote:
Can this be done with a populated table with 24MM rows and 130 fields? I keep getting errors that the tempdb is full (?) I tried copying the 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)

September 30, 2021 at 12:17 am

#3934845
Reply To: Adding a PRIMARY KEY CLUSTERED

Michael L John wrote:
When y0u create an index, you will need at least as much space in tempdb as the size of the index. In this case, a clustered index IS 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)

September 29, 2021 at 11:59 pm

#3934842
Reply To: Implicit conversion from datetime to datetime2

Ok... there's one I didn't know. The trouble for me is that isn't an "improvement in accuracy" for me. It's a 0.0003333 ERROR in ACCURACY to me.
This is almost as...
--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)

September 29, 2021 at 11:03 pm

#3934833
Reply To: Right place for newly graduates?

p.s. I'm also the same as Grant... minding my own business and someone walks in and says I've got a week or two to learn SQL. Welcome to the Vini...
--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)

September 28, 2021 at 2:14 pm

#3933962
Reply To: Right place for newly graduates?

LeviHampton wrote:
Hi everyone, I have a brother who just graduated with a programming major. And he seems lost in his own world so i’m here asking y’all where is 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)

September 28, 2021 at 2:12 pm

#3933961
Reply To: help with script to calculate gaps and overlaps from list of times

Ok. There's a whole bunch of data in a whole bunch of tables that we have absolutely zero access to. With that in mind, the only problem I'm going 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)

September 28, 2021 at 7:33 am

#3933809
Reply To: Linked Server location?

pkarandi wrote:
Jeff Moden wrote:
Heh... call the folks that are on the infrastructure team. They'll know.
Ha! Yeah, that was going to be my last resort. Since I recently inherited this server, 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)

September 28, 2021 at 12:51 am

#3933738
Reply To: How to find if the database is not being used

david.edwards 76768 wrote:
Jeff Moden wrote:
I figured it might be better than my BSOFH method which is to take the database offline and wait for the email. 😀
I thought that was accepted "Best...
--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)

September 28, 2021 at 12:45 am

#3933737
Reply To: How show only first friday of every month

Jonathan AC Roberts wrote:
Jeff Moden wrote:
There is a serious problem with the "equivalent" code you wrote though. It's not "equivalent" in the results for the last 3 tests. The table code comes up...
--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)

September 28, 2021 at 12:41 am

#3933736
Reply To: How show only first friday of every month

@ Jonathan,
I modified your code and comments a bit to provide an easier to read output on SQL Profiler. I also made each snippet write to a throwaway variable 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)

September 27, 2021 at 4:54 pm

#3933605
Reply To: hierarchy related query

My belief is that you're doing this whole thing the wrong way. Have a look at how easy it can be at the following URL.
https://www.sqlservercentral.com/articles/hierarchies-on-steroids-1-convert-an-adjacency-list-to-nested-sets
Depending on your reporting requirements,...
--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)

September 27, 2021 at 3:25 pm

#3933556
Reply To: How to find if the database is not being used

I figured it might be better than my BSOFH method which is to take the database offline and wait for the email. 😀
--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)

September 27, 2021 at 3:01 pm

#3933543
Reply To: help with script to calculate gaps and overlaps from list of times

I've always considered the following article to be a must read on this subject.
https://www.itprotoday.com/sql-server/new-solution-packing-intervals-problem
--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)

September 27, 2021 at 11:47 am

#3933444
Reply To: How to find if the database is not being used

Alejandro Santana wrote:
The way we do it is that we don't check when was the last transaction, we put an extended event capturing anything that goes into the database and we...
--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)

September 27, 2021 at 11:35 am

#3933439

Viewing 15 posts - 4,561 through 4,575 (of 59,087 total)