Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,021 through 7,035 (of 59,091 total)

Reply To: Find Space occupied by a Row

T.Ashish wrote:
My objective is to find out the space occupied by each record in a table ...
To what end? What will such information be used for? I ask because 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)

May 29, 2020 at 3:07 pm

#3758702
Reply To: how to remove null values from pivot sql

The method that Phil posted is known as a "CROSSTAB" and was the way we did pivots long before the PIVOT operator became available. CROSSTABs are also generally faster than...
--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 28, 2020 at 5:57 pm

#3758259
Reply To: I need to delete a duplicate line

Sounds like a plan... especially the part about validation before deletion. Thanks for the feedback.

--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 28, 2020 at 5:53 pm

#3758258
Reply To: Career Advice: Data Warehouse Architect/Modeler

I'd say that DW in the Cloud is on the rise and is probably a safe bet.
That, notwithstanding, ask yourself what your passion is (not to mention the finances 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)

May 28, 2020 at 5:47 pm

#3758257
Reply To: How often are DB names ever referenced outside of connection strings?

I've been living with similarly named databases that have different suffixes based on the environment for a very long time. I say "living"... what I really mean is "enforcing". 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)

May 28, 2020 at 5:38 pm

#3758255
Reply To: Need help with a BCP statement

What does the print statement yield?
--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 27, 2020 at 2:56 pm

#3757743
Reply To: High sensitivity of SQL server 2016 to statistics ?

martinreiser wrote:
Today I have a peformance issue where setting legacy cardinality estimator ON helps.
From 100s to 1 sec. Really interesting.

Heh... that's not just "help"... that's a freakin' miracle 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)

May 27, 2020 at 1:45 pm

#3757718
Reply To: Run critical job during upgrade window - SQL Agent stopped

Why not write a query that finds all enabled jobs, makes a list (table of them), and then disable all jobs except for that critical one you're talking about?
--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 27, 2020 at 3:12 am

#3757601
Reply To: I need to delete a duplicate line
I think this will be a bit more safe... details are in the comments in the code
```
 WITH cteEnumerate AS
(--==== Number each set of rows in descending...
```
--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 27, 2020 at 2:20 am

#3757597
Reply To: I need to delete a duplicate line

pietlinden wrote:
I need to delete the rows where status = 1
DELETE
FROM TestPO
WHERE Status=1;
?
From your description, it's not at all clear what records you really want deleted. Which record(s) are duplicates?...
--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 27, 2020 at 2:12 am

#3757596
Reply To: Index Maintenance

Lowell wrote:
well i remember a time where we used to provide scripts, and then an explanation of what not to do....
Ah, lordy... be careful, Lowell...
It's not that I don't want...
--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 26, 2020 at 11:44 pm

#3757570
Reply To: Index Maintenance

Sorry, Brian... I don't know if that came out the wrong way but, to be sure, I didn't mean to make it sound like I was talking about you specifically. ...
--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 26, 2020 at 8:01 pm

#3757526
Reply To: Index Maintenance

My take on this is that if you have to ask for scripts to do this, you're probably not qualified to use the scripts. I don't mean that as 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 26, 2020 at 6:23 pm

#3757507
Reply To: EF Code-First

You should write an article on it and submit it.

--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 26, 2020 at 4:39 pm

#3757487
Reply To: sys.dm_db_file_space_usage

DBAless wrote:
Yes, that's what I've seen on the internet. But I don't believe I have that much space in reality. To convert to GB you would divide by 256, right?
No. ...
--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 26, 2020 at 4:35 pm

#3757486

Viewing 15 posts - 7,021 through 7,035 (of 59,091 total)