Celebrating 6th Anniversary! Six years ago, I started this SQLAuthority.com blog. There are so many things I want to say today – it is very very emotional. Instead of writing long I am including few images and cartoons.
SQL SERVER – Copy Data from One Table to Another Table – SQL in Sixty Seconds #031 – Video
Copy data from one table to another table is one of the most requested questions on forums, Facebook and Twitter. The question has come in many formats and there are places I have seen developers are using cursor instead of this direct method. Earlier I have written the similar article…
Read MoreSQL SERVER – UNION ALL and ORDER BY – How to Order Table Separately While Using UNION ALL
I often see developers trying following syntax while using ORDER BY. SELECT Columns FROM TABLE1 ORDER BYÂ Columns UNION ALL SELECT Columns FROM TABLE2 ORDER BYÂ Columns However the above query will return following error. Msg 156, Level 15, State 1, Line 5 Incorrect syntax near the keyword ‘ORDER’. It is not…
Read MoreSQLAuthority News – Windows Efficiency Tricks and Tips – Personal Technology Tip
This is the second post in my series about my favorite Technology Tips, and I wanted to focus on my favorite Microsoft product. Choosing just one topic to cover was too hard, though. There are so many interesting things I have to share that I am forced to turn this…
Read More
SQL SERVER – Move Database Files MDF and LDF to Another Location
When a novice DBA or Developer create a database they use SQL Server Management Studio to create new database. Additionally, the T-SQL script to create a database is very easy as well. You can just write CREATE DATABASE DatabaseName and it will create new database for you. The point to remember here is that it will create the database at the default location specified in SQL Server Instance (this default instance, can be changed and we will see that in future blog posts). Now, once the database files goes in production it will start to grow.
SQL SERVER – Storing Variable Values in Temporary Array or Temporary List
SQL Server does not support arrays or a dynamic length storage mechanism like list. Absolutely there are some clever workarounds and few extra-ordinary solutions but everybody can;t come up with such solution. Additionally, sometime the requirements are very simple that doing extraordinary coding is not required. Here is the simple…
Read More
SQL SERVER – Introduction to Big Data
Big Data, as the name suggests, is about data that is BIG in nature. The data is BIG in terms of size, and it is difficult to manage such enormous data with relational database management systems that are quite popular these days.
SQL SERVER – Last Two Days to Get FREE Book – Joes 2 Pros Certification 70-433
Earlier this week we announced that we will be giving away FREE SQL Wait Stats book to everybody who will get SQL Server Joes 2 Pros Combo Kit. We had a fantastic response to the contest. We got an overwhelming response to the offer. We knew there would be a…
Read MoreSQL SERVER – Resolving SQL Server Connection Errors – SQL in Sixty Seconds #030 – Video
One of the most famous errors related to SQL Server is about connecting to SQL Server itself. Here is how it goes, most of the time developers have worked with SQL Server and knows pretty much every error which they face during development language. However, hardly they install fresh SQL…
Read More
SQL SERVER – Order By Numeric Values Formatted as String
When I was writing this blog post I had a hard time to come up with the title of the blog post so I did my best to come up with one. Here is the reason why? I wrote a blog post earlier SQL SERVER – Find First Non-Numeric Character from String. One of the questions was that how that blog can be useful in real life scenario. This blog post is the answer to that question. Let us first see a problem.