What is the two most important words that one should look for in SQL Server Execution plan? Scan ! Seek!
SCAN a big table is a disaster. The rescue is: try your best to let SQL Server SEEK a big table.
(William Wolf taught me this many many years ago at a SQL Saturday meeting. This knowledge is so powerful and it makes one of my query work so good that I want to share with you.)
Continue reading “Trick SQL Server to use the best Execution Plan”
Dynamic is one of my favorite search words. It is the opposite of “static”. A lot of time, SQL statements requires static input, such as column name and table name in SELECT. However, Dynamic SQL gives a way to overcome this requirement. This post I will share with you other two usages of ‘dynamic’.
Window functions of SQl server are very useful. Many webpage like this one https://www.brentozar.com/sql-syntax-examples/window-function-examples-sql-server/ have written how to use them. I want to share with you one segment of my sql code to get running total percentage using window functions.
It worked finally. My 12 queries was now 1 query. I only need to run it once to give my result. Yeah!
What did I do to make it work? I made an extra layer. First layer, select the result set as before. Then, select these result set and add rowID. Thirdly, select second layer result set by joining RowID.
Continue reading “Query Result side by side. Yes, finally!!”
I have twelve queries. Each of the query select 20 random account numbers that fits its own special where clauses. For twelve times, I need to copy the SQL code in TOAD, run the query in DB2, copy paste the 20 lines of result to one final excel file, which contains twelve columns.
Of course, I want to change it. I think it should not be too difficult.
Continue reading “query result side by side? NO!”
My kids and I love tongue twisters. We say tongue twister loudly in the car and they giggle and laugh loudly. I love to hear them giggle and laugh.
As I work full time as a SQL developer, I write and read SQL code much more often than when I was a SQL blogger. When I see SQL some code, I think: this is good. But, can you find a better way? Furthermore, what is the best way? These questions tickle my brain and when I find some answer, my brain giggles and laughs. I love that feeling.
Today, I want to share two SQL brain twisters (that comes from my work) with you. Continue reading “Brain Twister in SQL”
I found this serial posts about Power BI Q&A:
https://powerbi.microsoft.com/en-us/blog/demystifying-power-bi-q-amp-a-part-1/
All these three posts make perfect sense for a SQL developer, who, just same as Power BI Q&A, is happy to work with well-designed, normalized tables (this thought makes me terrified. who am I? A real intelligence or an artificial one?) Continue reading “AI and BI – Part 2”
Immediately after Xbox 1X was on the market, the price of Xbox 1S dropped dramatically. However, my son only wanted the newest model. It was OK for him not to have an Xbox at all, but it was not acceptable for him to have an older version of Xbox. I am in the same group with my son. I prefer to play the newest toy too. Excitedly, I announce my newest project: using AI (Artificial Intelligence) to answer BI (Business Intelligence) questions. Continue reading “AI and BI – Part 1”
I think these following steps are good for the exam preparation:
As I am trying to find a employment, after spending my last six years out of corporate world, recruiters suggest me to think two ways to prove that my technical skills are up-to-date: first way is to do some projects and get references current; second way is to get some certificate.
