reduce databse size

Hi Guys, I am new in analysis service. I just installed analysis service in my personal computer that has a sql server enterprise installed....

I have an issue where i can do the following Select count(*) from table and it returns 181,000 Select count(*) from table where ncolumn is n...

Hi Guys, I have question Regarding how to compress the data file. IN my company, the data file is getting bigger and bigger. Is that a way t...

Hi Guys, I have question Regarding how to compress the data file. IN my company, the data file is getting bigger and bigger. Is that a way t...

Hi Guys, I have question Regarding how to compress the data file. IN my company, the data file is getting bigger and bigger. Is that a way...

Hi, How frequently will the history tables get deleted in Merge Replication and Transactional Replication with updatable subscriptions? W...

Hello, we have full-text search service running under local system account and we removed Builtin/Administrators from our logins and now our...