Viewing 15 posts - 1 through 15 (of 117 total)
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
Besides RedGate's SQL Prompt, we use AutoHotKey to automate certain key sequences. It is not a SSMS add-in but rather a Windows app, but we use it exclusively for SQL...
January 23, 2015 at 5:53 am
I was investigating the same issue and discovered that you need to do the following, when the login does not have dbo or sa permissions:
GRANT VIEW DEFINITION ON [Name...
November 19, 2014 at 12:04 pm
Thanks for the reply. However, what I am looking for is running this:
EXEC dbo.usp_MyStoredProcedure -?
The result would just list the parameters in the stored procedure and acceptable input(s) for...
August 29, 2014 at 8:53 am
Peter Brinkhaus (7/24/2014)
http://msdn.microsoft.com/en-us/library/dd207007(v=sql.105).aspxIf you have BOL installed, just lookup '\' in the index.
Peter, thanks for the link. Honestly, this is one case I never would have thought about checking BOL...
July 24, 2014 at 5:56 am
Viewing 15 posts - 1 through 15 (of 117 total)