Corruption is when something is actually wrong with the database. For example a page is corrupt and cannot be read anymore from disk.

Inconsisteny is a problem within the data itself...

You're dealing with type-specific stars. (see chapter 13 of Star Schema - The complete reference).

There are 3 options:

* create one dimension to support both. (option B) This is a good...

Great, detailed article. Thanks.

First you got to help us so that we can help you.

It would be great if you could post the DDL for the table and some sample data + desired...

What's the question?

At first sight it seems you're experiencing network issues.

Are you running the package on the same server where the database is?

Easy question, but the way it is formulated it seems backups are entirely not possible (the MSDN page gives the same expression) and that your data is not safe. Azure...

I'd be very...

GilaMonster (1/13/2014)

---

Rodd, do you know anything about the next SQL Bits? I've asked on twitter, silence, web site hasn't been updated in ages. Was hoping to visit the UK for...

That's too bad.

If you'd store the connection files on a shared drive, you'd be able to update the connection string once and every Excel workbook would pick up the changes.

The connections inside the Excel sheets should not be saved inside the Excel workbook itself, but in an external connection file. If this is the case, you can just modify...

Check the job history to see if the job failed. (did the job even start?)

CREATE TABLE #TEMP(Category NVARCHAR(100),Item NVARCHAR(100),Value NVARCHAR(100));

INSERT INTO #TEMP values('Small','PilotA1','AjJCC');

INSERT INTO #TEMP values('Large','PilotA1','ACC');

INSERT INTO #TEMP values('Small','PilotA2','BKC');

WITH CTE_T1 AS

(

SELECT Item, Value

FROM #TEMP

WHERE Category = 'SMALL'

)

,CTE_T2 AS

(

SELECT Item, Value

FROM #TEMP

WHERE Category = 'LARGE'

)

SELECT...

Right-click on Agent in SSMS. If "Start" has been greyed out, it is already running.

Just do a backup and restore for simply copying a database.

When you want to attach an MDF file without LDF, you need to remove the LDF file at the bottom...