SQL Server Archives - Page 130 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Copy Data from One Table to Another Table – SQL in Sixty Seconds #031 – Video

October 31, 2012

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

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…

SQL SERVER – UNION ALL and ORDER BY – How to Order Table Separately While Using UNION ALL

October 30, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices

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…

SQLAuthority News – Windows Efficiency Tricks and Tips – Personal Technology Tip

October 29, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Personal Technology

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…

SQL SERVER – Storing Variable Values in Temporary Array or Temporary List

October 27, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…

SQL SERVER – Last Two Days to Get FREE Book – Joes 2 Pros Certification 70-433

October 25, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Joes 2 Pros

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…

SQL SERVER – Resolving SQL Server Connection Errors – SQL in Sixty Seconds #030 – Video

October 24, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

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…

SQLAuthority News – Windows Azure Training Kit Updated October 2012

October 21, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Azure, SQL Download

Microsoft has recently released the updated to Windows Azure Training Kit. Earlier this month they have updated the kit and included quite a lot of things. Now the training kit contains 47 hands-on labs, 24 demos and 38 presentations. The best part is that the kit is now available to download…