I would create a table that stores the information of to be deleted jobs (job name and date of deletion).

Then I would create a daily job that uses that information...

What if you run the configuration manager as Administrator? (shift+right-click shortcut)

Is the SQL Server service listed in services.msc?

c.ajitkumar (1/27/2014)

---

Hi All,

in my one of the server the sql server and sql sevrer agent service is not showing in configuration manager only browser service is listed there.

I checked all...

That would hide real failures.

@roryoflynn1: it's...

mea99sdp (1/27/2014)

---

SELECTCust_No,

Date,

(SELECT Financialyear FROM Financial_year_master_table WHERE Date BETWEEN Year_start_date AND Year_end_date) AS Financial_year

FROMDetail_table

You could do it this way, but you doing query for each row, so performance might not...

Personally I would go for option 1. I don't really like keys to other fact tables in the design.

And I would add the entire history in the new fact table,...

Do these new dimensions change the grain of the fact table?

Did you try any googling at all? There are thousands of code samples on the internet on how to delete duplicates.

Split up transactions in smaller chunks so that you don't have...

A...

hisakimatama (1/24/2014)

---

Actually, I thought I faintly remembered reading something similar at some point; after doing some digging, it turns out it was (incorrectly) attributed to Brent Ozar's site in my...

2 points for such an easy question. W00t! 😎 :w00t:

It depends on which queries are used against the table.

The unique index is useful as a check constraint to make sure the natural key (the combination of those three columns)...

The folder called "Data Sources". It's what is default specified for the TargetDataSourceFolder property.

It seems to me weekdays calculates days, not the number of Mondays.