I recommend that you download XLeratorDB and try this problem along with me, this is going to be a fun exercise and something new to learn about Business Days.
SQL SERVER – How to Allow Only Alphabets in Column – Create Check Constraint to Insert Only Alphabets
Here is the question I just received in email. “Pinal, I searched your blog at https://blog.sqlauthority.com/search-sqlauthority/ but I could not find a solution to my problem. I have a column where I only want to allow alphabets. If anyone wants to insert number or any other value in that table,…
Read MoreSQLAuthority News – Notes from SQLLive 360 – Orlando, Nov 2013 – A Great Experience
Earlier I wrote about my 3 technical session at SQL Live in the event at Orlando, Florida in Nov19-20, 2013. I had a great time presenting at the SQL Live event. I presented following three sessions at the event Presenting 3 Session at SQL Server Live, Orlando, Florida. SQT10 “What…
Read MorePersonal Technology – How to do Exercise and Stay Relaxed while in Office – Tips for Developers
While the modern day worker is usually no longer subjected to 10, 12, or 20 hour shifts, and can look forward to much more pleasant working conditions, modern office life has its own fair share of health and safety concerns. For example, sitting at a desk and staring at a…
Read MoreSQL SERVER – Wrap on Series of Temporary Statistics
This is the final post in the series of the Temporary Statistics. I have previously written about this subject in a few posts. I have received quite a few questions about this series so I decided to include all the questions in this one blog post. Before you read this…
Read MoreSQL SERVER – Finding Frequently Running Query and Elapsed Time – Notes from the Field #005
[Note from Pinal]: This is a fifth episode of Notes from the Field series. What happens when your server performs badly. The very first reaction is identifying what is running on the server. Once you identify what is running on the server we want to identify two of the most…
Read MoreSQL SERVER – Scripting Statistics for Read-Only Database and Making it Permanent
This is a follow up blog post to my earlier blog posts about statistics for Read-Only Database. Please read the following blog post in this series to get further idea about this subject: SQL SERVER – Statistics for Read-Only Database are in TempDB SQL SERVER – How to Script Statistics…
Read More