Viewing 15 posts - 1 through 15 (of 121 total)
Typically only update SSMS when we update the actual SQL version. Most of the users have 19.3 but there are still a few 18.x instances around here...
April 2, 2024 at 6:11 pm
That does suggest a permissions problem.
Yes... that is what I am thinking... but just have not figured out what/how. I posted here as we could not figure this out, so...
March 7, 2024 at 12:44 pm
I like, in general, ingimas, as I feel they help us learn and grow (and, for myself, the greater the challenge the more I dig my heals in to try...
February 12, 2024 at 6:25 pm
Somehow you left out the "SET @MyBit = 0" on one function?
No... all the functions come from a central location.
Strange part, if I script out the function and just execute...
February 12, 2024 at 12:32 pm
Thanks for all of the replies.
Unfortunately, we have little control over the format of the date field, since it is coming from a large international vendor's invoicing system. In the...
February 10, 2021 at 8:08 pm
Lordy. Thanks for the feedback on that. It's very timely as I was going to actually try column store on a table or two and then put them into production. ...
April 16, 2020 at 11:55 am
If the source definition for the column is varchar(20) - why are you trying to force that into a char(6) column?
Long story... but in a nutshell, the "source" table...
April 16, 2020 at 11:39 am
Jeff,
Thanks for the update. For the initial problem, we spent over 5 hours trying to look at the data to figure out what was going wrong.
• Len() and DataLength()
• Different...
April 15, 2020 at 7:45 pm
Jonathan,
Thanks for the suggestion. We did think of that early on and tried a few different combinations, i.e.,
AccountNo LIKE '%[^a-zA-Z0-9]%'
AccountNo LIKE '%'+CHAR(13)+'%' OR AccountNo LIKE '%'+CHAR(10)+'%' ...
April 15, 2020 at 11:32 am
We just discovered another process that is having a similar issue. It appears to be where the field size in the "source" table (which contains the non-clustered columnstore index) is...
April 14, 2020 at 6:18 pm
Its not just the data but how the data is used and the mathematical models they help to create. I suggest reading the book Weapons of Math Destruction by...
May 16, 2018 at 5:37 am
Thanks immensely, Steve! I sent the information to our development team so they can make the appropriate modifications to our table(s) and code.
I love surprises but *not* "gotchas"....
December 14, 2017 at 7:55 am
WOW! That is a lot of joins on the same table/view!
My experience has been, if you need to join on the same table but with multiple criteria, it might...
October 21, 2015 at 5:47 am
Thanks for all of the inputs so far.
FYI, since this is a somewhat ambiguous question...
• Almost all of the tables have INT/VARCHAR datatypes. Definitely no BLOB, Text, NText,...
July 23, 2015 at 1:10 pm
What's the best way to find the SQL statements you need to tune? Here are some of the things we do (and, as we get more knowledgeable, we grow and...
May 1, 2015 at 5:50 am
Viewing 15 posts - 1 through 15 (of 121 total)