Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,961 through 6,975 (of 59,102 total)

Reply To: Double Half and Quarter

We have something that works great! We don't do continuous deployments to prod! 😀
--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)

June 8, 2020 at 8:02 pm

#3761450
Reply To: Sort already comma eparted value

Ummm... why does KSA come first in #1 results?
--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)

June 8, 2020 at 8:00 pm

#3761447
Reply To: Physical db changes stored in transaction log file?

Just to set expectations, I never backup to the server I'm backing up from. I backup to a NAS. My 1TB database takes about 30 minutes and I'm not splitting...
--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)

June 8, 2020 at 7:57 pm

#3761444
Reply To: Sql server index

If most of your indexes have a "0" (equivalent to a 100 Fill Factor) and you rebuilt or reorganized them and the tables don't have an "ever-increasing" key on all...
--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)

June 8, 2020 at 5:36 pm

#3761406
Reply To: how to check which tsql make increasing the log file size

p.s. If you're doing any index maintenance because of logical fragmentation on any index that has a "0" Fill Factor, you're only making fragmentation worse and, in fact, perpetuating 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)

June 8, 2020 at 4:15 pm

#3761368
Reply To: how to check which tsql make increasing the log file size

I have to agree with Sergiy. I'll also add that, if it is he index maintenance job, it's usually because of the "Death by Deframentation" horror that goes by 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)

June 8, 2020 at 4:07 pm

#3761366
Reply To: The Social Impact of Data

skeleton567 wrote:
Jeff Moden wrote:
What I've found is that "Data" is always correct. "Information" derived from the data is not. And even if the "Data" is skewed, it is still correct 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)

June 7, 2020 at 3:03 pm

#3761179
Reply To: Stress Testing

If you really want to stress test some hardware, just migrate your existing code to it. That's when you'll find out two things... your code really is crap and all...
--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)

June 6, 2020 at 11:49 pm

#3761137
Reply To: The Social Impact of Data

What I've found is that "Data" is always correct. "Information" derived from the data is not. And even if the "Data" is skewed, it is still correct but incomplete.
I love...
--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)

June 6, 2020 at 11:37 pm

#3761136
Reply To: How to generating Excel File with multi sheet by using SQL server 2012?

Thee are several methods for doing this but they're all too long to post here with any understanding. My recommendation is that you do a search for it and pick...
--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)

June 6, 2020 at 7:19 pm

#3761097
Reply To: performance tuning for a subquery

rohitkocharda wrote:
can moderator please delete my post with all html above? I apologize for that.
It would be quicker if you just edited the post and deleted the code block with...
--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)

June 6, 2020 at 7:14 pm

#3761095
Reply To: Creating a DB

Jeffrey Williams wrote:
Jeff Moden wrote:
Jeffrey Williams wrote:
I have no idea why Microsoft has kept that option in the product - auto shrink will cause massive fragmentation of the database every time it shrinks. ...
--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)

June 6, 2020 at 7:11 pm

#3761094
Reply To: performance tuning for a subquery

Just to confirm, COALESCE won't provide an improvement in performance over CASE, although it will make the code a whole lot easier. Behind the scenes, the optimizer converts a COALESCE...
--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)

June 6, 2020 at 3:20 pm

#3761070
Reply To: Creating a DB

Jeffrey Williams wrote:
I have no idea why Microsoft has kept that option in the product - auto shrink will cause massive fragmentation of the database every time it shrinks. It is...
--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)

June 6, 2020 at 2:57 pm

#3761068
Reply To: Covert a string to simple sql datetime format
Jonathan AC Roberts wrote:
DECLARE @DateString nvarchar(100)='Wed Jun 29 15:57:45 2019'
SELECT CONVERT(datetime,SUBSTRING(@DateString,5,100))
I've always been astounded by the implicit conversions of strings to DateTime that SQL Server handles correctly. It seriously...
--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)
June 6, 2020 at 2:08 pm

#3761059

Viewing 15 posts - 6,961 through 6,975 (of 59,102 total)