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

MySQL – Date and Time Related System Functions

December 19, 2015

MySQL supports lot of functions to get current date and time. The following are some of the system functions. There are two functions to get current date SELECT curdate(),current_date(); There are two functions to get current time SELECT curtime(),current_time(); There are two functions to get current date along with time…

SQL SERVER – Recompiling InMemory OLTP with SQL Server 2016

December 18, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In-Memory OLTP

I wrote an intetresting trivia about InMemory OLTP code previously, SQL SERVER – How to take InMemory – OLTP FileGroup Offline?. Post this one of the reader was curious enough to ask me a counter question. He wrote back stating the recovery of the same is easy but he wanted…

SQL SERVER – Server Side and Client Side Trace

December 15, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

I don’t know where to start, I get to learn things from the most unusual of places. Most of the learnings is based on challenging the statuesque of our understanding. During my interactions with various DBAs one of the common misunderstanding is about server side and client side trace. One…

Interview Question of the Week #049 – Taking Database Offline

December 13, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Scripts

Here is the conversation which I observed the other day. Question: How do we take database off-line? Answer: Well, we can run following script to take the database offline. ALTER DATABASE [mydb] SET OFFLINE WITH ROLLBACK IMMEDIATE Question: Let us assume that your boss suggest that you should wait 30…

SQL SERVER – Discussion on understanding NUMA

December 12, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL CPU

At the SQLPass conference I have had the opportunity to meet a number of you and you folks have inspired me to learn and share after every trip to this conference. This year, I was fortunate to do a number of sessions this year too. Just the preparation for these…

SQL SERVER – Connecting to Azure SQL DB

December 11, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Azure

Learning new methods of working with SQL Server can always be challenging. I found the new learning coming my way while connecting to Azure SQL DB. I was confronted with an error and I was not sure where to start. So this blog is like a travel log of my…

SQL SERVER – Getting Started with Project Versions in the SSIS Catalog – Notes from the Field #106

December 10, 2015

Pinal Dave

SQL Tips and Tricks

Notes from the Field, SQL Server, SSIS

[Notes from Pinal]: We are human and we make mistakes. However, sometimes mistakes are so big that we can’t reverse it. Version control is our rescue when we make mistakes. In my life I have been fortunate few times when I deleted something important and version controlled saved me. Similarly, for SSIS Catalog version control is very important as well.