SQL Tips and Tricks Archives - Page 198 of 536 - SQL Authority with Pinal Dave

MySQL – How to Create Stored Procedure

December 13, 2013

If you are beginner with MySQL, you will face this particular issue while creating Stored Procedure. When I started with MySQL I had faced the similar situation as well. In MySQL we end every statement with semicolon. However, when we try to create stored procedure we face dilemmas that how…

SQL SERVER – Optimal Memory Settings for SQL Server – Notes from the Field #006

December 12, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Notes from Pinal]: Quite often we hear that my SQL Server is taking more memory or my server needs more memory as all the applications are running slow. The reality is that no matter how much memory you have it is never going to be enough. We all want more…

SQL Reporting – How to Add Excel and Word Reporting to Your Own Application – An Innovative Approach

December 11, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Reports, SSRS

To experience the awesomeness of OfficeWriter, I suggest you here to download the tool and work along with this blog post. The OfficeWriter API is a .NET library by SoftArtisans that makes it easy for developers to add Excel and Word reporting and document processing to their own applications. OfficeWriter…

SQL SERVER – How to Allow Only Alphabets in Column – Create Check Constraint to Insert Only Alphabets

December 9, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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,…

SQLAuthority News – Notes from SQLLive 360 – Orlando, Nov 2013 – A Great Experience

December 8, 2013

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

SQLAuthority Author Visit

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…

Personal Technology – How to do Exercise and Stay Relaxed while in Office – Tips for Developers

December 7, 2013

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

Personal Technology

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…

SQL SERVER – Wrap on Series of Temporary Statistics

December 6, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL 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…