The SQL Server SOS_SCHEDULER_YIELD is a fairly common wait type and it could indicate one of two things: SQL Server CPU scheduler is utilized properly and is working efficiently or There is a pressure on CPU. Read more at the SQL Shack from Nikola Dimitrijevic..
Startup options designate certain file locations needed during startup, and specify some server wide conditions. Most users do not need to specify startup options unless you are troubleshooting the Database Engine. It might also be useful to add trace flags to a startup options. Trace flags are used to temporarily set…
SQL Server 2016 is finally here. The quickest way to experience the magic of SQL Server 2016 is to create a test environment using an Azure SQL VM. You can also experience the full features through the free developer edition (you will be prompted to sign in to Visual Studio…
SQL Server databases consist of two physical files types; the data file in which the data and the database objects such as tables and indexes are stored, and the transaction log file in which SQL Server stores records for all transactions performed on that database. SQL Server transaction log contains…
The SQL Saturday team of Indianapolis would like to introduce the SQL Starter Track. An entire track of FREE sessions geared towards the ABSOLUTE BEGINNER. Be sure to sign up We have also started the #SQLStarter on Twitter. Find out more information on on our Sway Page.
Here is a Sneak Peek Preview of SQL Server 2016 and Cortana Intelligence by Tim Ford at SQL Server Magazine.The biggest features in the new edition of SQL Server are Always Encrypted, Stretch Database, integrated R language support in SQL Server, Cortana Intelligence, and the SandDance data visualization tool.
Wow, Paul Randal has put together probably the most comprehensive library of all wait types and latch classes that have existed since SQL Server 2005. This will be extremely important to all the Performance Tuners out there to really understand what is slowing your SQL code down. I can’t believe…
Register now for 24 Hours of PASS: Evolution of the Data Platform! From May 25-26, 2016 starting at 8am EST 24 one-hour webinars will be presented live back-to-back for you to enjoy from the comfort of your home or office! This edition will showcase cutting-edge technologies presented by a diverse mix of…
What an exciting line up of speakers and topics we have for this years’ SQL Saturday pre-conferences on Friday, August 12, 2016. If you are in the Indianapolis area, you definitely don’t want to miss these sessions.
Learning R can be tricky, especially if you have no programming experience or are more familiar working with point-and-click statistical software versus a real programming language. This learning path is mainly for novice R users that are just getting started but it will also cover some of the latest changes…