A common problem which occurs when going to allocate a new database in Microsoft SQL is an extremely long operation which will occur by default due to a disk zeroing operation that is performed when creating a new database. By default this will take a very long time even on the most powerful of database servers.
Posts Tagged ‘database’
Memacached is a high performance caching system mainly used for MySQL. It is used to speedup the dynamically loading web-pages by reducing the load on MySQL. Why it is important and how it works Suppose you are having a dynamic website which mainily works with databases. Each time a user accesses the website, database is [...]
What is a DAG? A DAG or database availability group is a new feature introduced in Exchange Server 2010 that enables high availability of Exchange mailbox databases. So what’s so great about a DAG? In previous versions of Exchange, high availability was possible, but required Exchange servers to be clustered when initially installed, required dedicated hardware [...]
Sharepoint comes with a fair amount of functionality built in for creating and editing lists. However, Sharepoint also allows users to open up a list in Access. Access has many more features for editing database lists. I found it most helpful recently for migrating data off of an old Access database for tracking inventory to a new Sharepoint [...]