Are the posted questions getting worse?
-
MVDBA (Mike Vessey) wrote:
could be worse jeff - I called a colleague over for some guidance on who wrote some code... he talked me through the 5000 line long proc with cursors, functions, triggers and all of the stuff that happens on Halloween... I put my head in my hands and said " which idiot wrote this pile of ****"
the reply was "me"
There are days when you feel like jeff and that was mine 🙂
now i'm waiting for a joe celko day 🙂
I have that sort of day frequently when looking at some of the developers code that makes it through testing, IPAT, and finally into production where I finally get to see when the customer complains about the slow code. I look at the code, throw it to the side with the comment that the code sucks.
I end up rewriting it to improve the processing. Just think, this could be avoided if the developers would let me review the code early in development.
Oh well, not going to be our problem shortly as we didn't win the contract that would keep us developing/maintaining the system.
-
Hell it's not just posted questions that are getting worse it's within our dev team
anyone else here wants to kill who ever invented Linq
just look at the end of the code sample - this is why we have DBAs and not entity frameworks
someone asked me if this was good code - I won't sleep tonight seeing that level of nesting and poor code
exec sp_executesql N'SELECT
[Project29].[ID] AS [ID],
[Project29].[AccountCode] AS [AccountCode],
[Project29].[ID1] AS [ID1],
[Project29].[AccountCode1] AS [AccountCode1],
[Project29].[C1] AS [C1],
[Project29].[Name] AS [Name],
[Project29].[TerritoryID] AS [TerritoryID],
[Project29].[ShortName] AS [ShortName],
[Project29].[C3] AS [C2],
[Project29].[C4] AS [C3],
[Project29].[C5] AS [C4],
[Project29].[C6] AS [C5],
[Project29].[C7] AS [C6],
[Project29].[C8] AS [C7],
[Project29].[C9] AS [C8],
[Project29].[C10] AS [C9],
[Project29].[C18] AS [C10],
[Project29].[C11] AS [C11],
[Project29].[C12] AS [C12],
[Project29].[C13] AS [C13],
[Project29].[C19] AS [C14],
[Project29].[C20] AS [C15],
[Project29].[C14] AS [C16],
[Project29].[C15] AS [C17],
[Project29].[C16] AS [C18],
[Project29].[C17] AS [C19],
[Project29].[C2] AS [C20]
FROM ( SELECT
[Project27].[AccountCode] AS [AccountCode],
[Project27].[ID] AS [ID],
[Project27].[Name] AS [Name],
[Project27].[TerritoryID] AS [TerritoryID],
[Project27].[ID1] AS [ID1],
[Project27].[AccountCode1] AS [AccountCode1],
[Project27].[ShortName] AS [ShortName],
[Project27].[C1] AS [C1],
CASE WHEN ([Extent26].[AccountCode] IS NULL) THEN CAST(NULL AS varchar(1)) ELSE LOWER([Extent26].[UserName]) END AS [C2],
[Project27].[C2] AS [C3],
[Project27].[C3] AS [C4],
[Project27].[C4] AS [C5],
[Project27].[C5] AS [C6],
[Project27].[C6] AS [C7],
[Project27].[C7] AS [C8],
[Project27].[C8] AS [C9],
[Project27].[C9] AS [C10],
[Project27].[C10] AS [C11],
[Project27].[C11] AS [C12],
[Project27].[C12] AS [C13],
[Project27].[C13] AS [C14],
[Project27].[C14] AS [C15],
[Project27].[C15] AS [C16],
CASE WHEN ([Extent26].[AccountCode] IS NULL) THEN CAST(NULL AS int) ELSE 1 END AS [C17],
[Project27].[C16] AS [C18],
[Project27].[C17] AS [C19],
[Project27].[C18] AS [C20]
FROM (SELECT
[Project15].[AccountCode] AS [AccountCode],
[Project15].[ID] AS [ID],
[Project15].[Name] AS [Name],
[Project15].[TerritoryID] AS [TerritoryID],
[Project15].[ID1] AS [ID1],
[Project15].[AccountCode1] AS [AccountCode1],
[Project15].[ShortName] AS [ShortName],
1 AS [C1],
CASE WHEN ( EXISTS (SELECT
1 AS [C1]
FROM ( SELECT
[Extent15].[AccountCode] AS [AccountCode],
[Extent15].[TemplateHeaderID] AS [TemplateHeaderID],
[Extent16].[AccountCode] AS [AccountCode1],
[Extent16].[ID] AS [ID],
[Extent16].[TemplateTypeID] AS [TemplateTypeID]
FROM [dbo].[TemplateHeaderCampaignAllocation] AS [Extent15]
INNER JOIN [dbo].[TemplateHeader] AS [Extent16] ON ([Extent15].[TemplateHeaderID] = [Extent16].[ID]) AND ([Extent15].[AccountCode] = [Extent16].[AccountCode])
WHERE ([Project15].[AccountCode] = [Extent15].[AccountCode]) AND ([Project15].[ID] = [Extent15].[StoreID])
) AS [Project16]
WHERE ([Project16].[TemplateTypeID] IN (225,226)) AND ( EXISTS (SELECT
1 AS [C1]
FROM [dbo].[CampaignDespatchTerritoryTemplate] AS [Extent17]
WHERE ([Project16].[AccountCode] = [Extent17].[AccountCode]) AND ([Project16].[TemplateHeaderID] = [Extent17].[TemplateHeaderID]) AND ([Extent17].[TerritoryID] = [Project15].[TerritoryID]) AND ([Extent17].[despatch_group] = @p__linq__1)
))
)) THEN cast(1 as bit) ELSE cast(0 as bit) END AS [C2],
CASE WHEN ( EXISTS (SELECT
1 AS [C1]
FROM ( SELECT
[Extent18].[AccountCode] AS [AccountCode],
[Extent18].[TemplateHeaderID] AS [TemplateHeaderID],
[Extent19].[AccountCode] AS [AccountCode1],
[Extent19].[ID] AS [ID],
[Extent19].[TemplateTypeID] AS [TemplateTypeID]
FROM [dbo].[TemplateHeaderCampaignAllocation] AS [Extent18]
INNER JOIN [dbo].[TemplateHeader] AS [Extent19] ON ([Extent18].[TemplateHeaderID] = [Extent19].[ID]) AND ([Extent18].[AccountCode] = [Extent19].[AccountCode])
WHERE ([Project15].[AccountCode] = [Extent18].[AccountCode]) AND ([Project15].[ID] = [Extent18].[StoreID])
) AS [Project19]
WHERE (191 = [Project19].[TemplateTypeID]) AND ( EXISTS (SELECT
1 AS [C1]
FROM [dbo].[CampaignDespatchTerritoryTemplate] AS [Extent20]
WHERE ([Project19].[AccountCode] = [Extent20].[AccountCode]) AND ([Project19].[TemplateHeaderID] = [Extent20].[TemplateHeaderID]) AND ([Extent20].[TerritoryID] = [Project15].[TerritoryID]) AND ([Extent20].[despatch_group] = @p__linq__2)
))
)) THEN cast(1 as bit) ELSE cast(0 as bit) END AS [C3],
CASE WHEN ( EXISTS (SELECT
1 AS [C1]
FROM [dbo].[CampaignDespatchStoreConfirmation] AS [Extent21]
WHERE ([Project15].[AccountCode] = [Extent21].[AccountCode]) AND ([Project15].[ID] = [Extent21].[StoreID]) AND ([Extent21].[despatch_group] = @p__linq__3) AND (1 = [Extent21].[StepID])
)) THEN cast(1 as bit) ELSE cast(0 as bit) END AS [C4],
CAST( [Project15].[C1] AS datetime2) AS [C5],
CASE WHEN ( EXISTS (SELECT
1 AS [C1]
FROM [dbo].[CampaignDespatchStoreConfirmation] AS [Extent22]
WHERE ([Project15].[AccountCode] = [Extent22].[AccountCode]) AND ([Project15].[ID] = [Extent22].[StoreID]) AND ([Extent22].[despatch_group] = @p__linq__5) AND (2 = [Extent22].[StepID])
)) THEN cast(1 as bit) ELSE cast(0 as bit) END AS [C6],
CAST( [Project15].[C2] AS datetime2) AS [C7],
CASE WHEN ( EXISTS (SELECT
1 AS [C1]
FROM [dbo].[CampaignDespatchStoreConfirmation] AS [Extent23]
WHERE ([Project15].[AccountCode] = [Extent23].[AccountCode]) AND ([Project15].[ID] = [Extent23].[StoreID]) AND ([Extent23].[despatch_group] = @p__linq__7) AND (3 = [Extent23].[StepID])
)) THEN cast(1 as bit) ELSE cast(0 as bit) END AS [C8],
CAST( [Project15].[C3] AS datetime2) AS [C9],
CAST( [Project15].[C5] AS datetime2) AS [C10],
CASE WHEN ( EXISTS (SELECT
1 AS [C1]
FROM [dbo].[CampaignDespatchStoreConfirmation] AS [Extent24]
WHERE ([Project15].[AccountCode] = [Extent24].[AccountCode]) AND ([Project15].[ID] = [Extent24].[StoreID]) AND ([Extent24].[despatch_group] = @p__linq__11) AND (5 = [Extent24].[StepID])
)) THEN cast(1 as bit) ELSE cast(0 as bit) END AS [C11],
CAST( [Project15].[C6] AS datetime2) AS [C12],
CAST( [Project15].[C9] AS datetime2) AS [C13],
CASE WHEN ( EXISTS (SELECT
1 AS [C1]
FROM [dbo].[CampaignDespatchStoreConfirmation] AS [Extent25]
WHERE ([Project15].[AccountCode] = [Extent25].[AccountCode]) AND ([Project15].[ID] = [Extent25].[StoreID]) AND ([Extent25].[despatch_group] = @p__linq__16) AND (7 = [Extent25].[StepID])
)) THEN cast(1 as bit) ELSE cast(0 as bit) END AS [C14],
CAST( [Project15].[C10] AS datetime2) AS [C15],
[Project15].[C4] AS [C16],
[Project15].[C7] AS [C17],
[Project15].[C8] AS [C18]
FROM ( SELECT
[Project14].[AccountCode] AS [AccountCode],
[Project14].[ID] AS [ID],
[Project14].[Name] AS [Name],
[Project14].[TerritoryID] AS [TerritoryID],
[Project14].[ID1] AS [ID1],
[Project14].[AccountCode1] AS [AccountCode1],
[Project14].[ShortName] AS [ShortName],
[Project14].[C1] AS [C1],
[Project14].[C2] AS [C2],
[Project14].[C3] AS [C3],
[Project14].[C4] AS [C4],
[Project14].[C5] AS [C5],
[Project14].[C6] AS [C6],
[Project14].[C7] AS [C7],
[Project14].[C8] AS [C8],
[Project14].[C9] AS [C9],
(SELECT
MAX([Extent14].[CreatedDateTime]) AS [A1]
FROM [dbo].[CampaignDespatchStoreConfirmation] AS [Extent14]
WHERE ([Project14].[AccountCode] = [Extent14].[AccountCode]) AND ([Project14].[ID] = [Extent14].[StoreID]) AND ([Extent14].[despatch_group] = @p__linq__17) AND (7 = [Extent14].[StepID])) AS [C10]
FROM ( SELECT
[Project13].[AccountCode] AS [AccountCode],
[Project13].[ID] AS [ID],
[Project13].[Name] AS [Name],
[Project13].[TerritoryID] AS [TerritoryID],
[Project13].[ID1] AS [ID1],
[Project13].[AccountCode1] AS [AccountCode1],
[Project13].[ShortName] AS [ShortName],
[Project13].[C1] AS [C1],
[Project13].[C2] AS [C2],
[Project13].[C3] AS [C3],
[Project13].[C4] AS [C4],
[Project13].[C5] AS [C5],
[Project13].[C6] AS [C6],
[Project13].[C7] AS [C7],
[Project13].[C8] AS [C8],
(SELECT
MAX([Extent13].[CreatedDateTime]) AS [A1]
FROM [dbo].[CampaignDespatchStoreConfirmation] AS [Extent13]
WHERE ([Project13].[AccountCode] = [Extent13].[AccountCode]) AND ([Project13].[ID] = [Extent13].[StoreID]) AND ([Extent13].[despatch_group] = @p__linq__15) AND (6 = [Extent13].[StepID])) AS [C9]
FROM ( SELECT
[Project11].[AccountCode] AS [AccountCode],
[Project11].[ID] AS [ID],
[Project11].[Name] AS [Name],
[Project11].[TerritoryID] AS [TerritoryID],
[Project11].[ID1] AS [ID1],
[Project11].[AccountCode1] AS [AccountCode1],
[Project11].[ShortName] AS [ShortName],
[Project11].[C1] AS [C1],
[Project11].[C2] AS [C2],
[Project11].[C3] AS [C3],
[Project11].[C4] AS [C4],
[Project11].[C5] AS [C5],
[Project11].[C6] AS [C6],
[Project11].[C7] AS [C7],
(SELECT
COUNT(1) AS [A1]
FROM ( SELECT DISTINCT
[Extent12].[TemplateTypeID] AS [TemplateTypeID]
FROM [dbo].[CampaignDespatchStoreConfirmation] AS [Extent12]
WHERE ([Project11].[AccountCode] = [Extent12].[AccountCode]) AND ([Project11].[ID] = [Extent12].[StoreID]) AND ([Extent12].[despatch_group] = @p__linq__14) AND (6 = [Extent12].[StepID])
) AS [Distinct3]) AS [C8]
FROM ( SELECT
[Project7].[AccountCode] AS [AccountCode],
[Project7].[ID] AS [ID],
[Project7].[Name] AS [Name],
[Project7].[TerritoryID] AS [TerritoryID],
[Project7].[ID1] AS [ID1],
[Project7].[AccountCode1] AS [AccountCode1],
[Project7].[ShortName] AS [ShortName],
[Project7].[C1] AS [C1],
[Project7].[C2] AS [C2],
[Project7].[C3] AS [C3],
[Project7].[C4] AS [C4],
[Project7].[C5] AS [C5],
[Project7].[C6] AS [C6],
(SELECT
COUNT(1) AS [A1]
FROM ( SELECT DISTINCT
[Project8].[TemplateTypeID] AS [TemplateTypeID]
FROM ( SELECT
[Extent9].[AccountCode] AS [AccountCode],
[Extent9].[TemplateHeaderID] AS [TemplateHeaderID],
[Extent9].[Qty] AS [Qty],
[Extent10].[AccountCode] AS [AccountCode1],
[Extent10].[ID] AS [ID],
[Extent10].[TemplateTypeID] AS [TemplateTypeID]
FROM [dbo].[TemplateHeaderCampaignAllocation] AS [Extent9]
INNER JOIN [dbo].[TemplateHeader] AS [Extent10] ON ([Extent9].[TemplateHeaderID] = [Extent10].[ID]) AND ([Extent9].[AccountCode] = [Extent10].[AccountCode])
WHERE ([Project7].[AccountCode] = [Extent9].[AccountCode]) AND ([Project7].[ID] = [Extent9].[StoreID])
) AS [Project8]
WHERE ([Project8].[Qty] > 0) AND ( EXISTS (SELECT
1 AS [C1]
FROM [dbo].[CampaignDespatchTerritoryTemplate] AS [Extent11]
WHERE ([Project8].[AccountCode] = [Extent11].[AccountCode]) AND ([Project8].[TemplateHeaderID] = [Extent11].[TemplateHeaderID]) AND ([Extent11].[despatch_group] = @p__linq__13) AND ([Extent11].[TerritoryID] = [Project7].[TerritoryID])
))
) AS [Distinct2]) AS [C7]
FROM ( SELECT
[Project6].[AccountCode] AS [AccountCode],
[Project6].[ID] AS [ID],
[Project6].[Name] AS [Name],
[Project6].[TerritoryID] AS [TerritoryID],
[Project6].[ID1] AS [ID1],
[Project6].[AccountCode1] AS [AccountCode1],
[Project6].[ShortName] AS [ShortName],
[Project6].[C1] AS [C1],
[Project6].[C2] AS [C2],
[Project6].[C3] AS [C3],
[Project6].[C4] AS [C4],
[Project6].[C5] AS [C5],
(SELECT
MAX([Extent8].[CreatedDateTime]) AS [A1]
FROM [dbo].[CampaignDespatchStoreConfirmation] AS [Extent8]
WHERE ([Project6].[AccountCode] = [Extent8].[AccountCode]) AND ([Project6].[ID] = [Extent8].[StoreID]) AND ([Extent8].[despatch_group] = @p__linq__12) AND (5 = [Extent8].[StepID])) AS [C6]
FROM ( SELECT
[Project5].[AccountCode] AS [AccountCode],
[Project5].[ID] AS [ID],
[Project5].[Name] AS [Name],
[Project5].[TerritoryID] AS [TerritoryID],
[Project5].[ID1] AS [ID1],
[Project5].[AccountCode1] AS [AccountCode1],
[Project5].[ShortName] AS [ShortName],
[Project5].[C1] AS [C1],
[Project5].[C2] AS [C2],
[Project5].[C3] AS [C3],
[Project5].[C4] AS [C4],
(SELECT
MAX([Extent7].[CreatedDateTime]) AS [A1]
FROM [dbo].[CampaignDespatchStoreConfirmation] AS [Extent7]
WHERE ([Project5].[AccountCode] = [Extent7].[AccountCode]) AND ([Project5].[ID] = [Extent7].[StoreID]) AND ([Extent7].[despatch_group] = @p__linq__10) AND (4 = [Extent7].[StepID])) AS [C5]
FROM ( SELECT
[Project3].[AccountCode] AS [AccountCode],
[Project3].[ID] AS [ID],
[Project3].[Name] AS [Name],
[Project3].[TerritoryID] AS [TerritoryID],
[Project3].[ID1] AS [ID1],
[Project3].[AccountCode1] AS [AccountCode1],
[Project3].[ShortName] AS [ShortName],
[Project3].[C1] AS [C1],
[Project3].[C2] AS [C2],
[Project3].[C3] AS [C3],
(SELECT
COUNT(1) AS [A1]
FROM ( SELECT DISTINCT
[Extent6].[TemplateTypeID] AS [TemplateTypeID]
FROM [dbo].[CampaignDespatchStoreConfirmation] AS [Extent6]
WHERE ([Project3].[AccountCode] = [Extent6].[AccountCode]) AND ([Project3].[ID] = [Extent6].[StoreID]) AND ([Extent6].[despatch_group] = @p__linq__9) AND (4 = [Extent6].[StepID])
) AS [Distinct1]) AS [C4]
FROM ( SELECT
[Project2].[AccountCode] AS [AccountCode],
[Project2].[ID] AS [ID],
[Project2].[Name] AS [Name],
[Project2].[TerritoryID] AS [TerritoryID],
[Project2].[ID1] AS [ID1],
[Project2].[AccountCode1] AS [AccountCode1],
[Project2].[ShortName] AS [ShortName],
[Project2].[C1] AS [C1],
[Project2].[C2] AS [C2],
(SELECT
MAX([Extent5].[CreatedDateTime]) AS [A1]
FROM [dbo].[CampaignDespatchStoreConfirmation] AS [Extent5]
WHERE ([Project2].[AccountCode] = [Extent5].[AccountCode]) AND ([Project2].[ID] = [Extent5].[StoreID]) AND ([Extent5].[despatch_group] = @p__linq__8) AND (3 = [Extent5].[StepID])) AS [C3]
FROM ( SELECT
[Project1].[AccountCode] AS [AccountCode],
[Project1].[ID] AS [ID],
[Project1].[Name] AS [Name],
[Project1].[TerritoryID] AS [TerritoryID],
[Project1].[ID1] AS [ID1],
[Project1].[AccountCode1] AS [AccountCode1],
[Project1].[ShortName] AS [ShortName],
[Project1].[C1] AS [C1],
(SELECT
MAX([Extent4].[CreatedDateTime]) AS [A1]
FROM [dbo].[CampaignDespatchStoreConfirmation] AS [Extent4]
WHERE ([Project1].[AccountCode] = [Extent4].[AccountCode]) AND ([Project1].[ID] = [Extent4].[StoreID]) AND ([Extent4].[despatch_group] = @p__linq__6) AND (2 = [Extent4].[StepID])) AS [C2]
FROM ( SELECT
[Extent1].[AccountCode] AS [AccountCode],
[Extent1].[ID] AS [ID],
[Extent1].[Name] AS [Name],
[Extent1].[TerritoryID] AS [TerritoryID],
[Extent2].[ID] AS [ID1],
[Extent2].[AccountCode] AS [AccountCode1],
[Extent2].[ShortName] AS [ShortName],
(SELECT
MAX([Extent3].[CreatedDateTime]) AS [A1]
FROM [dbo].[CampaignDespatchStoreConfirmation] AS [Extent3]
WHERE ([Extent1].[AccountCode] = [Extent3].[AccountCode]) AND ([Extent1].[ID] = [Extent3].[StoreID]) AND ([Extent3].[despatch_group] = @p__linq__4) AND (1 = [Extent3].[StepID])) AS [C1]
FROM [dbo].[Store] AS [Extent1]
INNER JOIN [dbo].[Territory] AS [Extent2] ON ([Extent1].[AccountCode] = [Extent2].[AccountCode]) AND ([Extent1].[TerritoryID] = [Extent2].[ID])
WHERE ([Extent1].[AccountCode] = @p__linq__0) AND ([Extent1].[Active] = 1)
) AS [Project1]
) AS [Project2]
) AS [Project3]
) AS [Project5]
) AS [Project6]
) AS [Project7]
) AS [Project11]
) AS [Project13]
) AS [Project14]
) AS [Project15] ) AS [Project27]
LEFT OUTER JOIN [dbo].[UserStore] AS [Extent26] ON ([Project27].[AccountCode] = [Extent26].[AccountCode]) AND ([Project27].[ID] = [Extent26].[StoreID])
WHERE EXISTS (SELECT
1 AS [C1]
FROM [dbo].[UserStore] AS [Extent27]
WHERE ([Project27].[AccountCode] = [Extent27].[AccountCode]) AND ([Project27].[ID] = [Extent27].[StoreID]) AND (LOWER([Extent27].[UserName]) IN (N''obfuscated for security')) AND (LOWER([Extent27].[UserName]) IS NOT NULL)
)
) AS [Project29]
ORDER BY [Project29].[ID] ASC, [Project29].[AccountCode] ASC, [Project29].[ID1] ASC, [Project29].[AccountCode1] ASC, [Project29].[C17] ASC',N'@p__linq__0 varchar(8000),@p__linq__4 varchar(8000),@p__linq__6 varchar(8000),@p__linq__8 varchar(8000),@p__linq__9 varchar(8000),@p__linq__10 varchar(8000),@p__linq__12 varchar(8000),@p__linq__13 varchar(8000),@p__linq__14 varchar(8000),@p__linq__15 varchar(8000),@p__linq__17 varchar(8000),@p__linq__1 varchar(8000),@p__linq__2 varchar(8000),@p__linq__3 varchar(8000),@p__linq__5 varchar(8000),@p__linq__7 varchar(8000),@p__linq__11 varchar(8000),@p__linq__16 varchar(8000)',@p__linq__0='STARBUCKS',@p__linq__4='Spring 2020',@p__linq__6='Spring 2020',@p__linq__8='Spring 2020',@p__linq__9='Spring 2020',@p__linq__10='Spring 2020',@p__linq__12='Spring 2020',@p__linq__13='Spring 2020',@p__linq__14='Spring 2020',@p__linq__15='Spring 2020',@p__linq__17='Spring 2020',@p__linq__1='Spring 2020',@p__linq__2='Spring 2020',@p__linq__3='Spring 2020',@p__linq__5='Spring 2020',@p__linq__7='Spring 2020',@p__linq__11='Spring 2020',@p__linq__16='Spring 2020'MVDBA
-
That's some bad code there Mike. I've seen some similar, but add a couple UNION statements and all with in an SSRS report. Talk about slow code.
I've also had that moment when I look at some code and say "Who wrote this crap?" Only to realize later it was me, about 10+ years ago. 😉
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret. -
I'm dealing with a crappy proc, and a crappy design, right now.
The devs did the "Code first" design. In other words, the ORM designed the database for them.
I can't post the code for the biggest offending proc, I don't feel like taking the time to obfuscate it. But, it does 16 selects into a temp table, of the same tables, with slightly differing WHERE clauses. it then selects distinct into another temp table, and then finally does a count and group by to get a count of each item.
There are 10 tables in this database. There are FORTY unused indexes in it. The devs keep trial and erroring adding indexes.
I could go on and on, but my fingers would get tired.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
below86 wrote:
That's some bad code there Mike. I've seen some similar, but add a couple UNION statements and all with in an SSRS report. Talk about slow code.
I've also had that moment when I look at some code and say "Who wrote this crap?" Only to realize later it was me, about 10+ years ago. 😉
Gee, I look at code I wrote 2 days ago and wonder the same thing!
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/ -
Michael L John wrote:below86 wrote:
That's some bad code there Mike. I've seen some similar, but add a couple UNION statements and all with in an SSRS report. Talk about slow code.
I've also had that moment when I look at some code and say "Who wrote this crap?" Only to realize later it was me, about 10+ years ago. 😉
Gee, I look at code I wrote 2 days ago and wonder the same thing!
In a similar vein, if I look at any code I wrote more than about two weeks ago, I always wonder: "What is this trying to do and how the hell does it work?"
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
-
MVDBA (Mike Vessey) wrote:Michael L John wrote:Jeff Moden wrote:MVDBA (Mike Vessey) wrote:Michael L John wrote:
Is this a good example of someone who may have picked the wrong thing to do with their lives?
https://qa.sqlservercentral.com/forums/topic/ssis-package-error-22
oh man i wish i was in that stream ... jeff can be quite direct.
Is that good or bad? 😀 I thought I was pretty nice about saying that he needs to slow down and read his code... especially in the areas that SQL Server was telling him to look.
His last post was the kicker. "The files empty". Uh, duh, did you fill it with anything?
good lad jeff.. you aren't dropping your standards
Heh... that wasn't me. That was Michael.
Seriously, though... I come across that tough? I thought I reserved that for JC.
--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)
Intro to Tally Tables and Functions -
Michael L John wrote:
I'm dealing with a crappy proc, and a crappy design, right now.
The devs did the "Code first" design. In other words, the ORM designed the database for them.
I can't post the code for the biggest offending proc, I don't feel like taking the time to obfuscate it. But, it does 16 selects into a temp table, of the same tables, with slightly differing WHERE clauses. it then selects distinct into another temp table, and then finally does a count and group by to get a count of each item.
There are 10 tables in this database. There are FORTY unused indexes in it. The devs keep trial and erroring adding indexes.
I could go on and on, but my fingers would get tired.
code first=don't care about database- someone elses problem
MVDBA
-
Jeff Moden wrote:
Seriously, though... I come across that tough? I thought I reserved that for JC.
nah, i know you are a big cuddly teddy bear underneath - now get back to be being meaner than jc... then i can rest easy knowing i'm the nice DBA - you could almost make the 7 dwarves out of us... Scary, mean,nice,ISO,little,shirts I just need one more 🙂
MVDBA
-
I can't remember who, but I remember someone in here saying that they were having problems with Powershell Core because of it's changed (lack of) functionality with Web Services.
As an FYI, Powershell 7.0.0 LTS was released yesterday, which adds a handy switch to
Import-Module, theUseWindowsPowerShellswitch. This gives you he below when you use it:Module ReportingServicesTools is loaded in Windows PowerShell using WinPSCompatSession remoting session; please note that all input and output of commands from this module will be deserialized objects. If you want to load this module into PowerShell Core please use 'Import-Module -SkipEditionCheck' syntax
This means you can now use Windows Powershell Commands in Powershell (they've dropped the Core in the name now), and they're run in a compatible remote session. Given it a go with a few commands/modules that weren't working for me and seems to work well.
For those interested: What's New in PowerShell 7.0
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
Thanks for mentioning that Powershell 7 is out
-
Phil Parkin wrote:Michael L John wrote:below86 wrote:
That's some bad code there Mike. I've seen some similar, but add a couple UNION statements and all with in an SSRS report. Talk about slow code.
I've also had that moment when I look at some code and say "Who wrote this crap?" Only to realize later it was me, about 10+ years ago. 😉
Gee, I look at code I wrote 2 days ago and wonder the same thing!
In a similar vein, if I look at any code I wrote more than about two weeks ago, I always wonder: "What is this trying to do and how the hell does it work?"
Well Phil, I really didn't want to admit to it, but what you said did happen to me this week. I wrote some code last month to do a complex calculation on each transaction record we received. Then I was looking back at it on Monday and thought How does this work? It's hell getting old. I guess some would say that is why you should put documentation in your code. The problem I usually run into is I write the code, look back at it at that time and think, "well that makes sense, no need for documentation". Hard to teach and old dog new tricks.
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret. -
MVDBA (Mike Vessey) wrote:Michael L John wrote:
I'm dealing with a crappy proc, and a crappy design, right now.
The devs did the "Code first" design. In other words, the ORM designed the database for them.
I can't post the code for the biggest offending proc, I don't feel like taking the time to obfuscate it. But, it does 16 selects into a temp table, of the same tables, with slightly differing WHERE clauses. it then selects distinct into another temp table, and then finally does a count and group by to get a count of each item.
There are 10 tables in this database. There are FORTY unused indexes in it. The devs keep trial and erroring adding indexes.
I could go on and on, but my fingers would get tired.
code first=don't care about database- someone elses problem
Heh... going for the 7th dwarf badge for "Acronyms"...
--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)
Intro to Tally Tables and Functions -
you can't be 2 of the dwarfs at the same time
MVDBA
-
below86 wrote:Phil Parkin wrote:Michael L John wrote:below86 wrote:
That's some bad code there Mike. I've seen some similar, but add a couple UNION statements and all with in an SSRS report. Talk about slow code.
I've also had that moment when I look at some code and say "Who wrote this crap?" Only to realize later it was me, about 10+ years ago. 😉
Gee, I look at code I wrote 2 days ago and wonder the same thing!
In a similar vein, if I look at any code I wrote more than about two weeks ago, I always wonder: "What is this trying to do and how the hell does it work?"
Well Phil, I really didn't want to admit to it, but what you said did happen to me this week. I wrote some code last month to do a complex calculation on each transaction record we received. Then I was looking back at it on Monday and thought How does this work? It's hell getting old. I guess some would say that is why you should put documentation in your code. The problem I usually run into is I write the code, look back at it at that time and think, "well that makes sense, no need for documentation". Hard to teach and old dog new tricks.
Old dog should find the most junior team member who has had nothing to do with it, and DON'T EXPLAIN IT TO THEM. Have them explain it to you after reviewing it for a few minutes. If they can't follow it, find out where they are stuck, comment appropriately.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
Viewing 15 posts - 64,561 through 64,575 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply