MAS90 is a database engine on its own. Yes I have installed the OLEDB driver for it. True there are no issues related to provider/ driver because whenever i test...

Experts I need your valuable advice. I am confused if I am missing something or is it a MAS90 issue.

Thanks a ton in advance

Default Storage mode is MOLAP.In this, data gets pulled from Relational DB and pushed to Analysis services after aggregations are created.It fetches only leaf level attributes. Super fast but consumes...

In somecases the developers request only the structural differences and least bothered about data (database refresh). In that case you need to compare the current copy of production database vs...

I think I was able to figure this out..

http://mssqlnuggets.wordpress.com/

Sean Lange (5/14/2013)

---

Seems a bit strange that you can put a trigger on a table but not a unique constraint. The constraint will perform better and is effectively doing the...

Experts I need your inputs.

Cool...Do you think there will be a free ecopy for this book. Thanks

Thanks

Lynn Pettis (4/16/2013)

---

Sapen (4/16/2013)

---

I am trying to convert into the below format

week number,

average of sunday,

average of monday,

average of tuesday,

average of wednesday,

average of thursday,

average of friday,

average of saturday,

The averages are nothing...

I am trying to convert into the below format

week number,

average of sunday,

average of monday,

average of tuesday,

average of wednesday,

average of thursday,

average of friday,

average of saturday,

The averages are nothing but average of...

Yes. Thanks.

Lowell (4/4/2013)

---

something like this seems to work for me, see how i modified it to sue sp_msForEachDb, and to INSERT INTO a #temp table, and read the results at

the...

alexkedrov (7/8/2010)

---

f.racionero (10/17/2007)

---

Normally I use this script to get all user information for a db

select

[Login Type]=

case sp.type

when 'u' then 'WIN'

when 's' then 'SQL'

when 'g' then 'GRP'

end,

convert(char(45),sp.name) as srvLogin,

convert(char(45),sp2.name)...

AccDba (2/6/2013)

---

I found the stored proc that needs to be modified. I am not sure where the changes have to be made and I need some help from experts on...