Viewing 15 posts - 4,996 through 5,010 (of 59,068 total)
Have a read of Jeff Moden's articles Cross Tabs and Pivots. They explain exactly how to achieve what you're after.
And the second article describes how to do it...
June 30, 2021 at 8:34 pm
I "love" some of the ads I've seen... they start with needing only 2 years of experience but want a full stack developer that is also an expert at database...
June 30, 2021 at 8:28 pm
After loaded to the cursor(BEGIN - Start Transaction) than there are other sp's used in the process before a final END. Thanks.
You posted the code that creates the cursor...
June 30, 2021 at 8:07 pm
Again, you haven't ever done an actual logical design, have you? Genuine data modeling, with no indexes, etc.., where you went through a true normalization process.
Heh... more than you...
June 30, 2021 at 7:46 pm
BWAAAA-HAAAA-HAAAA!!! Ok... I "get it". Yep... I agree... you never have to mention "IDENTITY" in a logical model. I have to tell you, though, that the idea of having a...
June 30, 2021 at 6:15 pm
Heh... and why would anyone in their right mind think that's going to be any better. Notice I didn't put a question mark after that statement. 😀
June 30, 2021 at 5:24 pm
Ads always ask for more than the job. I don't know that I've seen one that was accurate since I stopped tending bar.
If you think you have to meet...
June 30, 2021 at 5:23 pm
My opinion is that if a product has so many performance issues, perhaps it's better to find a different product. Atlassian is obviously aware of the performance problems, especially because...
June 30, 2021 at 3:50 pm
That's where you and I would differ... to me, the "customer number" would be the IDENTITY column. Or, perhaps, a Random GUID. 😀 Why would your "customer number"...
June 29, 2021 at 8:29 pm
That's where you and I would differ... to me, the "customer number" would be the IDENTITY column. Or, perhaps, a Random GUID. 😀 Why would your "customer number" not be...
June 29, 2021 at 7:19 pm
I notice that even if we don't restart SQL Service, the data of sys.dm_exec_query_stats( sys.dm_exec_sql_text() and sys.dm_exec_query_plan() ) will be reset or removed/refreshed. when the data of sys.dm_exec_query_stats will...
June 29, 2021 at 5:36 pm
It would be really interesting to see you design a Customer or Employee table without one. I'd also be interested in your claim of "it's literally impossible to normalize based...
June 29, 2021 at 5:07 pm
Heh... so THAT's the reason why so many people end up with "slow databases" and IDENTITY columns everywhere. 😉 A lot of the important stuff isn't even considered up front.
June 29, 2021 at 4:56 pm
Do you have an actual example of a 30 million row transaction where every row was actually required or you had to fail all 30 million rows? ...
June 29, 2021 at 4:53 pm
Viewing 15 posts - 4,996 through 5,010 (of 59,068 total)