Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,856 through 3,870 (of 59,067 total)

Reply To: Performing String Split on items which have been String Split

Thank you for the feedback. Just remember that the STRING_SPLIT() function does not currently guarantee any order in any version of on-prem SQL Server.. They finally figured that out and...
--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)

February 23, 2022 at 2:01 am

#3987222
Reply To: Avg Disk Queue Length Issues

Am I understanding correctly that you say there have been no data changes in the server instance for 5 months and no one has changed any code in the server...
--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)

February 23, 2022 at 1:53 am

#3987221
Reply To: lead and lag records

You're confused me and, perhaps, others. How is it that your test data now contains a -1 instead of a 0 in the Div_Status column? And what result do 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)

February 23, 2022 at 1:39 am

#3987220
Reply To: How to shrink LOB data in sql server 2017

Things look about as "packed" as they're going to get. Not including what you posted before (graphic below for convenience), how much drive space do you have left on that...
--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)

February 23, 2022 at 12:58 am

#3987203
Reply To: Proxy accounts failing to authenticate intermittently

I can't help here but I can tell you I'd be online with MS Support about this. This sounds like a bug to me.
--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)

February 22, 2022 at 12:48 am

#3986626
Reply To: When divide missing values from two tables it not display ?
Thank you for the readily consumable data. This should do it for you and it contains some protection from "Divide by Zero" issues...
```
 SELECT   companyid...
```
--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)
February 21, 2022 at 10:43 pm

#3986609
Reply To: Match and No Match(Gives same output)

yrstruly wrote:
I would like to match this source table: CREATE TABLE [dbo].['TMI Sites $']( [Advertiser] [nvarchar](255) NULL, [Designated Market Area (DMA)] [nvarchar](255) NULL, [DV360 Site] [nvarchar](255) NULL, [Impressions] [float] NULL,...
--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)

February 21, 2022 at 10:14 pm

#3986594
Reply To: Lots of data + HierarchyId performanceproblems

Can you post the CREATE TABLE statement for the table, please? I might have a time-saving idea for you if the structure is right for 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)

February 21, 2022 at 10:11 pm

#3986591
Reply To: Performing String Split on items which have been String Split
[EDIT] I just noticed that this is almost identical to @kaj's good code.
This should help and it will also help prevent mistakes with spaces (like ratbak also helped prevent in...
- This reply was modified 4 years, 4 months ago by Jeff Moden. Reason: I just noticed that this is almost identical to @kaj's good code
--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)
February 21, 2022 at 9:05 pm

#3986590
Reply To: lead and lag records

Shree23 wrote:
Attached excel sheet
See above.
--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)

February 21, 2022 at 8:23 pm

#3986572
Reply To: lead and lag records

Shree23 wrote:
Table is attached in excel sheet due to format issue
Please see the article at the first link in my signature line below for how to post "readily consumable" data...
--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)

February 21, 2022 at 8:15 pm

#3986571
Reply To: show percentage between 2 fileds

Bruin wrote:
Can you elaborate?
Thx.
Sure. Do a search for SQL Injection and try some of the methods for the way you're using @Table2 and @ColName. @Table1 may not have the same...
--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)

February 21, 2022 at 8:07 pm

#3986567
Reply To: SQL Files open in a new SSMS instance

In my case, I had to right click the icon in the actual windows menu, then click on "More", and then click on "Open File Location" and that took me...
--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)

February 21, 2022 at 8:01 pm

#3986566
Reply To: List 4 row into 4 column with same ID

Please see the following article if you want to know more about CROSSTAB queries and how they work.
https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-converting-rows-to-columns-1

--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)

February 21, 2022 at 9:30 am

#3986286
Reply To: How to shrink LOB data in sql server 2017

@olegserdia
Check the page density on the Clustered Index for your big table that you deleted images from. Because you used the IMAGE datatype, they should have gone "out-of-row" but it's...
--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)

February 21, 2022 at 9:26 am

#3986284

Viewing 15 posts - 3,856 through 3,870 (of 59,067 total)