Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,821 through 5,835 (of 59,072 total)

Reply To: question on Index Rebuilds

I don't know of a way to predict index REBUILD times. I can only tell you that I have a similar table that has a similar row count and slightly...
--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)

December 29, 2020 at 5:23 pm

#3825218
Reply To: Maintenance task for Rebuild index with fragmentation > 30%

With apologies for my ignorance on the subject, I'm not sure what's going on because I don't actually use index maintenance plans, mostly because of the many reported horrors 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)

December 29, 2020 at 5:03 pm

#3825213
Reply To: I need help with dates in the where clause I need to get data from 5pm to 5am

Just to add fuel to the fire, what do you want done if something overlaps the shift boundaries? Or is that simply not possible because you're truly only using 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)

December 29, 2020 at 4:57 pm

#3825198
Reply To: Find Average Row Size and Num of Rows per page for a table

GBeezy wrote:
All great answers and all of them very helpful!
I will be using the used_page_count for my calculations.
Again, I appreciate everyone's help!
That still won't be accurate for the reasons 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)

December 29, 2020 at 4:52 pm

#3825197
Reply To: Find Average Row Size and Num of Rows per page for a table

The problem with using "Reserved_Page_Count" is that it actually has little to do with row size. For example, if you have an index that has suffered a large number 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)

December 29, 2020 at 4:35 pm

#3825192
Reply To: Maintenance task for Rebuild index with fragmentation > 30%

My first question would be... how did you determine that all those indexes were rebuilt just because they had a frag level > 0?
Also, a screen shot of your "Rebuild...
--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)

December 29, 2020 at 3:27 pm

#3825155
Reply To: Deleting folder on a drive

It would appear that you forgot to attach the code but, based on the narrative above, it sounds like you're on the right track to a fix.
--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)

December 29, 2020 at 1:55 pm

#3825109
Reply To: Reaping the benefits of the Window functions in T-SQL

I'm one of those DBAs that will allow the use of CLR. I'm just not one to allow the use of CLR that doesn't make sense. I had one guy...
--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)

December 28, 2020 at 1:05 pm

#3824687
Reply To: While loop

Also, on the other thread for this subject, I posted a question...
Please, just so we know, why does this has to be a While loop? For example, will you be...
--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)

December 27, 2020 at 9:17 pm

#3824528
Reply To: While loop

mtz676 wrote:
The stored procedure takes Name, month or day as input
It would seem that the inputs are a wee bit important as to figuring out if the proc will be...
--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)

December 27, 2020 at 9:14 pm

#3824527
Reply To: Tally OH! An Improved SQL 8K “CSV Splitter” Function

@ Steve Collins,
Great try/good thinking. I'm thinking, though, that just about anything you add to it is going to slow it way down... especially since, if you read the article,...
--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)

December 27, 2020 at 5:18 pm

#3824496
Reply To: Converting MONEY

btio_3000 wrote:
oh... got it. Right, converting to VARCHAR does it. Got it.
Thank you
Technically, not. You can format with VARCHAR() but you have to use the correct "style" code rather 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)

December 24, 2020 at 8:52 pm

#3823894
Reply To: Converting MONEY

jcelko212 32090 wrote:
You might want to look up how the old Sybase money data types work. They round too soon and give the wrong answers. Google it. This is why competent...
--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)

December 24, 2020 at 8:40 pm

#3823893
Reply To: Merry Christmas 2020

timwell wrote:
I am curious why, given that RAND() is supposed to return random numbers, it always returns the same "random" numbers for the same query?. Is that by design 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)

December 24, 2020 at 8:15 pm

#3823890
Reply To: The case for SQL Server Agent 2.0

g.britton wrote:
@jeff how do you do parallelism in SQL driven by an Agent job? Note that I don't mean parallelism in execution plans; I mean actual parallel operations as in...
--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)

December 24, 2020 at 5:21 pm

#3823867

Viewing 15 posts - 5,821 through 5,835 (of 59,072 total)