Viewing 15 posts - 7,366 through 7,380 (of 59,072 total)
From what you've posted, you start off wanting to treat this data element as a string, but then you're storing it as a numeric. You also don't know that...
April 4, 2020 at 2:55 am
"Pfffft! *he* wrote it??? Not reading that!!"
LOL
What I meant was that you posted the correct answer first and I missed that. 😀
April 4, 2020 at 2:34 am
Thanks for the feedback but I'm, actually pretty late with my observation. pietlinden pretty much said in his first post what I was talking about and I simply didn't read...
April 4, 2020 at 12:37 am
p.s. It would be gentlemanly if you posted either the script or the link where you got the script that you claim helped you to identify columnstore indexing candidate tables.
April 4, 2020 at 12:05 am
Please read the following article. They have code to calculate "S" and "U" values that you could programmatically interpret. Combine that with the compression estimator code (documented in Books Online...
April 4, 2020 at 12:03 am
As a thought, do you have a linked server on Server1 that points back to Server1?
Great thought. It could also be a synonym between two servers that's using a...
April 3, 2020 at 10:02 pm
What I'm waiting for is to find out when you have an employee that owns more than one car. You need a "Bridge Table" that assigns vehicles to owners. And,...
April 3, 2020 at 9:57 pm
Seems crazy to me. Just out of curiosity, have you tried using the old cardinality estimator settings? You may have found a genuine bug with the new one.
April 3, 2020 at 9:43 pm
Lordy, no. That's one of the slowest methods possible. I'll be back to prove it. Just don't use FORMAT!
Jeff, maybe so, maybe so. It appears the OP's doing...
April 3, 2020 at 9:36 pm
Using FORMAT is the slowest method even for something this simple. Even STR, which is pretty bad, isn't nearly as bad (except that it will silently truncate and right pad...
April 3, 2020 at 8:56 pm
scdecade: that worked
select format(cast(@qtramt1 as bigint), 'd14');
Thank you
Lordy, no (Sorry, scdecade). That's one of the slowest methods possible. I'll be back to prove it. Just don't use FORMAT!
April 3, 2020 at 8:36 pm
I am getting the same output with this query
Select convert(date,saledate),sum(saleprice) from Data.SalesbyCountry
where convert(date,saledate) = eomonth(saledate) and year(saledate)='2016'
group by convert(date,saledate)Am I missing something ???
Yes, Sir. You're missing...
April 3, 2020 at 3:47 pm
Ok, with that being said, you could home-grow a solution pretty easily but take a look at "System-Versioned Temporal Tables" in SQL Server. I think that might be what you're...
April 3, 2020 at 3:10 pm
Is the original value of @qtramt1 = 94500 ??? Just making sure.
April 3, 2020 at 2:59 pm
Viewing 15 posts - 7,366 through 7,380 (of 59,072 total)