The first shop to stop in for this kind of problems is SSIS, Sql Server Integration Services.

😎

Quick question, which version of SQL Server Migration Assistant (SSMA) are you using and does it support the Oracle version in question?

😎

For more information on SSMA, have a look at...

Quick question, can you post the DDL (create table) for the tables, sample data as an insert statement and the expected result set. This problem is trivial but in order...

BLOB_EATER (8/1/2016)

---

Eirikur Eiriksson (8/1/2016)

---

Thanks for this fine piece Daniel!

😎

My thought is that there are many out there which have Azure SQL databases but don't have local SQL Server instances to...

You are very welcome

😎

For further information on the subject, I suggest having a look at Jeff Moden's excellent articles, Cross Tabs and Pivots[/url].

Thanks for this fine piece Daniel!

😎

My thought is that there are many out there which have Azure SQL databases but don't have local SQL Server instances to run the scheduled...

Quick example

😎

USE TEEST;

GO

SET NOCOUNT ON;

-- THE NAME OF THE COLUMN WHICH WE WANT TO CHECK IF EXISTS OR NOT

DECLARE @COL_TO_LOOK_FOR NVARCHAR(128) = N'MY_NEW_COL';

-- TABLE THAT DOES NOT...

GilaMonster (8/1/2016)

---

In this case no data would have been lost, the repair rebuilt...

You are very welcome and thanks for the feedback.

😎

Quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

--

;WITH SAMPLE_DATA(Date,Client,QType,Answer) AS

(SELECT Date,Client,QType,Answer

FROM (VALUES

('11.01.16',1,'Q1',100)

,('11.01.16',1,'Q2',150)

,('11.01.16',1,'Q3',75 )

,('11.01.16',2,'Q1',250)

...

Quick suggestion, post some sample data, the expected output and...

Quick question, did you take any kind of a backup before you started the repair exercise?

😎

Ooops, so you ran DBCC CheckDB ('DatabaseName',...

Start by running DBCC CheckDB ('DatabaseName') WITH NO_INFOMSGS, ALL_ERRORMSGS and post the full and unedited output.

At this point DO NOT detach the database!

😎

Quick questions, what else is running on the server? What are the sql server memory configurations? Any relevant entries in the Windows Event Log? What is the storage configuration? Any...