Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,281 through 8,295 (of 59,072 total)

Reply To: How Bad are Bad Page Splits?

John Mitchell-245523 wrote:
Thanks for setting up the tests and crunching the numbers, Mike!
I just wanted to take issue with this (emphasis mine):
Data can be added row by row to a page...
--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)

November 26, 2019 at 6:17 pm

#3701182
Reply To: SQL Cursor Trouble

tripleAxe wrote:
Use the LAG function
https://docs.microsoft.com/en-us/sql/t-sql/functions/lag-transact-sql?view=sql-server-ver15
The OP posted readily consumable test data... show us the code to use LAG to solve this.
--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)

November 26, 2019 at 3:44 pm

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

Phil Parkin wrote:
Thom A wrote:
Don't you just love it when you get a "urgent" work request that needs to be done "NOW", because it's impacting staff productivity, so you get the work...
--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)

November 26, 2019 at 3:03 pm

#3701093
Reply To: Is there such a thing as database file bloating?

tarr94 wrote:
Hello,
I'm still fairly new to SQL Server. We have a production database at our company that has grown from about 40gb to 100gb over the course of about five...
--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)

November 26, 2019 at 2:53 pm

#3701091
Reply To: How to backup the Xmldata table in sql server 2016

polo.csit wrote:
Database is Full Recovery Model...it is not possible to change Bulk logged recovery model
My other question, which has still been unanswered is... can we create another database for 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)

November 25, 2019 at 8:19 am

#3700420
Reply To: How Bad are Bad Page Splits?

Nice job, Mike.
One of the biggest problems is that there are a huge number of common circumstances where lowing the FILL FACTOR will do absolutely nothing to prevent the page...
--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)

November 25, 2019 at 6:55 am

#3700387
Reply To: how to lock the record

OK... You still haven't answered my question but, based on your acceptance of Jonathan's good code, I'll assume the answer is "Yes, that's all correct".
You asked for correction if you...
--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)

November 25, 2019 at 4:43 am

#3700363
Reply To: Oops, I deleted that data
Carlo Romagnano wrote:
I prefer "implicit transaction", they are more safe than "begin tran" in case you use "GO" in the script.
```
SET IMPLICIT_TRANSACTIONS ON
;with a
as
(
SELECT * FROM dbo.account WHERE...
```
--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)
November 25, 2019 at 2:30 am

#3700361
Reply To: How to backup the Xmldata table in sql server 2016

polo.csit wrote:
I am using the query is
SELECT id,name,xmldata INTO New_Table Name from TableName
Yep... you said that from the git. Can you answer my previous questions so I can best help...
--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)

November 24, 2019 at 8:15 pm

#3700340
Reply To: SSIS For each Loop not finding files when deployed

Did you actually try the solution you found? I ask because it may be that the package isn't actually running as you as you think. I'm not an SSIS kind...
--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)

November 24, 2019 at 7:54 pm

#3700336
Reply To: how to lock the record

KGJ-Dev wrote:
Hi Jeff,
as you mentioned in the previous thread, you came across this situation and you have solved this issue in different way. would you be able to pitch 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)

November 24, 2019 at 7:27 pm

#3700334
Reply To: Future Proof

I'll be the first to admit that I'm a bit of a T-SQL zealot when it comes to doing things with data. A part of the reason is that I've...
--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)

November 24, 2019 at 7:01 pm

#3700333
Reply To: look for the most efficient method

to go along with what the other folks have written...
The biggest difference is that it will not be possible to get index seeks on the 3 column index if 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)

November 23, 2019 at 3:08 am

#3700193
Reply To: One machine is not able to connect to sql server while others connect fine

We had that happen to us the other day... exact same symptoms. It turned out to be a cable where a partial connection in an RJ-45 jack finally backed out...
--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)

November 23, 2019 at 2:16 am

#3700190
Reply To: Previous Day (Business Day Only) Needed for Auto Tableau Server Script

What's really stupid is that Jonathan is absolutely correct (and, NO, I'm NOT saying Jonathan is stupid... Jonathan is far from stupid and only occasionally resorts to RBAR :D...
--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)

November 23, 2019 at 1:50 am

#3700185

Viewing 15 posts - 8,281 through 8,295 (of 59,072 total)