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

SQL SERVER – Error – Resolution – Could not allocate space for object in database because the filegroup is full

March 14, 2014

Just a day ago on my local box I received following error. Could not allocate space for object ‘<object_name>’ in database ‘<database_name>’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on…

SQL SERVER – SSIS Data Flow Troubleshooting – Part1 – Notes from the Field #019

March 13, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore, SSIS

[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. The tool may also be used…

MySQL – How to do Straight Join in MySQL?

March 12, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

In an earlier post, we have learnt a new type of join called NATURAL JOIN supported in MySQL. In this post will see another type of join called STRAIGHT_JOIN. STRAIGHT_JOIN is actually an INNER JOIN but it forces the order in which data should be processed. As per MySQL’s documentation…

SQL Contest – Win Amazon Gift Cards – Learn How to Get Started with ClustrixDB

March 11, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

It has been a long time since we contest where we can learn something new and win something cool. I reached out to the good folks of Clustrix with the request to help me to build a contest where readers can learn and explore new technology, while stand a good…

MySQL – How to do Natural Join in MySQL? – A Key Difference Between Inner Join and Natural Join

March 10, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Joins

As you know MySQL supports ANSI JOINs like INNER JOIN, OUTER JOIN, CROSS JOIN etc. Do you know that it supports NATURAL JOIN?. A NATURAL JOIN is a type of JOIN which automatically maps the similar columns from both the tables. Let us create the following tables CREATE TABLE items(item_id…

MySQL – Reset Row Number for Each Group – Partition By Row Number

March 9, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, Ranking Functions

In earlier post, we have learnt how to generate row number for each row using a variable as MySQL does not have any system function like SQLServer’s row_number() to generate the row number. In this post we will see how to reset row number for each group (Alternate method for…

SQL SERVER – Retrieve Maximum Length of Object Name with sp_server_info

March 7, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Stored Procedure

A very common question which I often receive is – “How big my table name can be?” The answer is simple 128. You can figure this out by executing stored procedure sp_server_info on SQL Server. Execute following stored procedure in SQL Server. EXEC sp_server_info It will return following resultset. attribute_id…