Viewing 15 posts - 1 through 15 (of 1,583 total)
Found the issue... the user who found the issue provided me with the code... which I just modified here to reproduce it "as-is"... when I copied the same code into...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 8, 2025 at 10:26 pm
Sure...
USE [TempDB]
GO
DROP TABLE IF EXISTS #Results
SELECT 'A' [Column1], 'B' [Column2] INTO #Results
SELECT * FROM #Results
SELECT * FROM #Results
WHERE 1=1 AND [Column1] in ('A') AND [Column2] = 'B'
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 8, 2025 at 10:12 pm
My understanding of how the engine interprets "equals" versus "IN()" is pretty much the same. The IN operator is used to compare a column value against a set of values...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 8, 2025 at 9:15 pm
I did come across this... which does explain it... but geeez, never in 24 years have I been bitten by this in a VIEW
"Operators can always change precision scale..."
<table>
<thead>
<tr>
<th>Operation</th>
<th>Result precision</th>
<th>Result...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 24, 2023 at 3:53 pm
Thanks for the response - it's great to see the old names replying all the time 🙂
I have considered this and we've actually used it and an alternate (SQLSafe Virtual...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 31, 2023 at 4:44 pm
Great stuff! Thanks for the advice thus far....I'll play with this a bit and see if it works for this scenario
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 15, 2022 at 4:38 pm
Can you please post/attach your entire script?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 26, 2021 at 3:08 am
Thanks for everyone's comments thus far, that's the current plan - restore to a different server, different storage, sans Vormetric and see if the corruption is still present. Just so...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
September 1, 2021 at 6:23 pm
I wanted to also note that Vormetric encrypts the data at the OS/folder level
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 31, 2021 at 6:27 pm
Wow this is a blast from the past! If it's sending a blank email it's because one of the values being assigned to a parameter is NULL. I would check...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 28, 2021 at 1:26 pm
Rewriting it using the temp table is an option I did consider but was hoping for one of those “a ha” moments ??
The execution plan is not that bad and...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 1, 2021 at 1:47 pm
I realize this is a very, very old post but did you ever get this resolved? If so, what steps did you take?
My team just got plagued with the same...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 16, 2020 at 4:41 pm
Thanks Steve, was just seeking confirmation. I realize this isn't a "standard" or best practice per say, but always have added it in to facilitate server builds across large distributed...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 21, 2020 at 2:42 pm
Is there any negative impact to adding trace flags to a server startup proc? More of as a failsafe that anything...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 21, 2020 at 1:45 pm
Resolving this issue for me was simply a matter or placing the DB in EMERGENCY mode and bringing it back online:ALTER DATABASE PROBLEM_CHILD SET EMERGENCY
GO
Once...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 13, 2018 at 8:25 pm
Viewing 15 posts - 1 through 15 (of 1,583 total)