Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,376 through 12,390 (of 59,099 total)

RE: Automated Indexes

Stewart "Arturius" Campbell - Thursday, May 10, 2018 4:52 AM
Jeff Moden - Thursday, May 10, 2018 12:28...
--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 10, 2018 at 5:10 am

#1990002
RE: One Million Tables

Heh... I advise people against trying to display a million rows even in the Grid and it has no meta-data to resolve. I wouldn't expect the Explorer window to deal...
--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 10, 2018 at 5:03 am

#1990000
RE: Automated Indexes

And yet they can't do a shrinkfile like Peter Norton did 30 years ago and nor can they rebuild an index without temporarily doubling its size and blowing out 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 10, 2018 at 12:28 am

#1989992
RE: Friday the 13th

sgriffin-681047 - Wednesday, May 9, 2018 12:00 PM
A fun challenge! Here's a solution using a recursive cte:
DECLARE @FirstMonth DATE = GETDATE();
;WITH [cte]...
--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 9, 2018 at 8:03 pm

#1989982
RE: SQL Server 2017 CU5 and CU6 Analysis Services Processing Task Error - Solution

I don't use that part of SQL Server but awesome job, Giovanni. Ya just gotta love the people in this community. ...
--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 9, 2018 at 7:55 pm

#1989981
RE: Pride in Azure SQL Database

As a bit of a sidebar, leave it to this great community to come up with a fix. Hope MS is listening.
https://www.sqlservercentral.com/Forums/1935282/SQL-Server-2017-CU5-and-CU6-Analysis-Services-Processing-Task-Error-Solution
--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 9, 2018 at 7:53 pm

#1989980
RE: Pride in Azure SQL Database

Here we go again... another possible bum SP for 2016.
https://www.sqlservercentral.com/Forums/1935421/Service-Pack-2-for-SQL-Server-2016
The OP wouldn't have a choice if they were on Azure, would they?
--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 9, 2018 at 7:51 pm

#1989979
RE: Performance issue with the table having 40M rows

You're also using a GROUP BY as a replacement for DISTINCT. That usually means that the criteria is insufficient for the job.
Also, what you posted is an estimated...
--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 9, 2018 at 7:44 pm

#1989978
RE: Compare XML column to XML variable (The XML data type cannot be compared or sorted, except when using the IS NULL operator).???????

If you have to do the conversion anyway, maybe convert through HASHBYTES??? It's not quite a guarantee of things that are identical but, if the result of hasbytes is different,...
--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 9, 2018 at 7:24 pm

#1989976
RE: Compatibility Level versus the Real Version

I agree with DHeath above. It doesn't matter what any of us think or say. It only matters what the vendor says. Ask them to verify and then sign off...
--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 9, 2018 at 7:21 pm

#1989975
RE: Odd behavior -- execution plan different when I execute in the target database vs not in the target database

llevity - Tuesday, May 8, 2018 11:29 AM
To clarify, I'm running the exact same query, against the exact same database target. 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)

May 9, 2018 at 6:58 pm

#1989974
RE: Pride in Azure SQL Database

Steve Jones - SSC Editor - Wednesday, May 9, 2018 5:06 PM
I'm still unsure of your complaint. If they hadn't done something...
--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 9, 2018 at 6:47 pm

#1989973
RE: Running total with a twist

siggemannen - Sunday, May 6, 2018 6:31 AM
Doh, of course, recursive CTE! Thanks!
I added some more testdata and rewrote your code to...
--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 9, 2018 at 2:35 pm

#1989957
RE: Pride in Azure SQL Database

Steve Jones - SSC Editor - Monday, May 7, 2018 9:02 AM
Jeff Moden - Saturday, May 5,...
--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 9, 2018 at 2:33 pm

#1989955
RE: Updating datetime2 column not working

WebTechie - Monday, May 7, 2018 3:19 PM
Hello,
Trying to update some datetime2 columns.
UPDATE T_MYTABLE SET dateTransferred = '2018-03-26 05.00.00' where id =...
--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 9, 2018 at 2:23 pm

#1989952

Viewing 15 posts - 12,376 through 12,390 (of 59,099 total)