I found how I should do it. I'm adding the answer just in case that it might help someone in the future.

select *

from dbo.UnPivotSourceTable

pivot

(

MIN(ColumnValue) --I have only one value...

IIF is an access function that doesn’t exist in SQL Server. You can use the CASE function to check if the phone number begins with 9 and then decide...

After trigger is executed after the DML operation (insert, update or delete) was executed on the table. Instead of trigger runs Instead of the DML operation that was...

As far as I know, you can’t define the file group and it will be created on the default file group.

Adi

You can find the answer for your question here – http://blogs.msdn.com/sqlreleaseservices/archive/2008/02/15/end-of-mainstream-support-for-sql-server-2005-sp1-and-sql-server-2000-sp4.aspx

Adi

Notice that I’m using to functions. The first function is GETUTCDATE() that shows the UTC time. The second function is GETDATE() that shows the local time. I...

You can do it with the dateadd and datediff function. With datediff function you can calculate the difference in minutes between the local time and UTC time. With...

You are missing an alias to the select statement in the left join. You did use an alias for the openquery function, but you also need to use an...

I don’t think that DBCC DBReIndex supports working with schemas. DBCC DBReIndex was used in SQL Server versions that didn’t have schemas at all. The schemas were...

Sorry, I never worked with DB2, so I can't help you with that.

Adi

Take into consideration that the query plans go...

constraint that will prevent using any character that is not a digit. Bellow is a demonstration of such a code:

use tempdb

go

--creating the check constraint that limits the values of...

I think that you are looking for sp_spaceused. If you’ll run it with a parameter that contains table name, it will give you the (among other things) the...

I think that you’ll have to use some third party products such as Lumigent’s Log explorer or Red Gate’s SQL Log Rescue. Another alternative is to create a logging...

Barkingdog (4/15/2010)

You wrote

>>>

Most chances are that when you added the other column to the index, the index was a covering index. A covering index is an index that is...