SQL Archives - Page 170 of 519 - SQL Authority with Pinal Dave

MySQL – Introduction to CONCAT and CONCAT_WS functions

June 7, 2014

MySQL supports two types of concatenation functions. They are CONCAT and CONCAT_WS CONCAT function just concats all the argument values as such SELECT CONCAT('Television','Mobile','Furniture'); The above code returns the following TelevisionMobileFurniture If you want to concatenate them with a comma, either you need to specify the comma at the end…

SQL SERVER – What are Actions in SSAS and How to Make a Reporting Action

June 6, 2014

Pinal Dave

SQL

SQL Analysis Services, SSAS

Actions are used for customized browsing and drilling of data for the end-user. It’s an event that a user can raise while accessing the cube data. They are used in cube browsers like excel and are triggered when a user with a client tool clicks on a particular member, level, dimension, cells or may be the cube itself. For example a user might be able to see a reporting services report, open a web page or drill through to detailed information related to the cube data. Let us learn about how make a reporting action.

SQL SERVER – Repair a SQL Server Database Using a Transaction Log Explorer

June 3, 2014

Pinal Dave

SQL

ApexSQL

In this blog, I’ll show how to use ApexSQL Log, a SQL Server transaction log viewer. You can download it for free, install, and play along. But first, let’s describe some disaster recovery scenarios where it’s useful.

SQL SERVER – Iridium I/O – SQL Server Deduplication that Shrinks Databases and Improves Performance

June 2, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Database performance is a common problem for SQL Server DBA’s. It seems like we spend more time on performance than just about anything else. In many cases, we use scripts or tools that point out performance bottlenecks but we don’t have any way to fix them. For example, what do…

SQL SERVER – Faster SQL Server Databases and Applications – Power and Control with SafePeak Caching Options

June 2, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Safepeak

Update: This blog post is written based on the SafePeak, which is available for free download. Today, I’d like to examine more closely one of my preferred technologies for accelerating SQL Server databases, SafePeak. Safepeak’s software provides a variety of advanced data caching options, techniques and tools to accelerate the…

MySQL – Introduction to User Defined Variables

May 31, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

MySQL supports user defined variables to have some data that can be used later part of your query. You can save a value to a variable using a SELECT statement and later you can access its value. Unlike other RDBMSs, you do not need to declare the data type for…

SQL SERVER – Merge Two Columns into a Single Column

May 30, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Here is a question which I have received from user yesterday. Hi Pinal, I want to build queries in SQL server that merge two columns of the table If I have two columns like, Column1 | Column2 1 5 2 6 3 7 4 8 I want to output like, Column1…