Adaptive query processing is the latest query processing feature introduced in the SQL Server database engine, available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database. Read on to learn more.
2018-09-25
2,801 reads
Interleaved Execution allows SQL Server's query optimizer to get accurate cardinality estimates in places where it couldn't before.
2018-02-08
938 reads
Explore Batch Mode Memory Grant Feedback that was introduced in SQL Server 2017
2018-02-01
890 reads
Let's explore how SQL Server 2017 automatically adapts between nested loop and hash join operators
2018-01-25
1,105 reads
2005-04-29
I personally prefer to do all of my development in C#, but I think that's mostly due to my comfort with the language and the RAD tools I use with it.Since you're not going to use web interfaces, I would base my recommendation off of your deployment requirements. If your software will always be deployed […]
2005-04-29
Hi JoeWe all are still waiting for ur book. We would be highly grateful to ur kind help for Posting the book or sending it on email (sanjaymasawan@yahoo.com)Thanks ***** Hep Others To Help You *****
2005-04-26
I have never done this via DMO however, just from looking at the information provided I don't think that DMO is smart enough to realize that "I" am (local)....
2005-03-10
I stated that I can use SQL Mail fine. I don't use xp_sendmail - I just stated that I can. I don't understand why I cannot use the SQL Agent mail. I want to be able to create an Operator that can be emailed when something goes wrong. I cannot do that unless SQL Agent […]
2005-03-10
This is also a good reference for DB2 SQL that I keep bookmarked.https://aurora.vcu.edu/db2help/db2s0/frame3.htm
2005-03-10
1 reads
I am very excited and lucky to be speaking once again at SQLBits along...
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Monitoring for Problems The encryption of your existing data occurs as a background process...
Perhaps the biggest drawback of this type of formation is that two strikers will...
In Goodell's announcement on domestic violence earlier in the week: A few of the...
what are the best books to become a SQL developer?
Ask SSC