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...

Hugo Kornelis (7/31/2016)

---

I think you already nailed it in your very first reply, but the OP either misunderstood...

Piling on Kevin's fine answer; production system tuning should not be an trial & error process but rather information gathering with careful interactions and modifications to the system. Knee jerks...

Slightly different flavor with the addition of "valid groups" instead of hard coding which values to combine

😎

USE TEEST;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(StateID,DistrictID,CityID,Grp,VoteCount) AS

(

SELECT 1 AS StateID, 1 AS DistrictID, 1 AS...