Please I need help , I need to allcoate fixed memory to database ... suppose i have database called
xyz in SQL server 2005, I need to allocate certain memory for this database to utilize only 500MB from 4 GB available for the SQL server.
so I need to know how can I do that for database level NOT SQL server leverl.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.