One thing you also need to understand is that if that value is always a low value (e.g. .7 MB like you have), it is probably a good indication that...

Brandie Tarvin (6/9/2011)

---

Again, it depends, but I believe the blanket recommendation is to let SQL Server figure out memory allocation for itself unless you are having problems.

Too many people don't...

Barkingdog (6/9/2011)

---

The networking group (the guys with the tape backup unit) need me to backup certain databases on the the last workday of the last week of the month ("end...

npeters 86796 (6/7/2011)

---

I have the query below which will be used in ssrs.

the problem i have is that i need to query data using the month in the where clause...

They are stored in the database - not in the file system.

Your options are:

1) Use BIDS and deploy to the new system

2) Use a tool that will move it for...

If you have Enterprise Edition - you can install SSRS as a scale-out solution. Basically, you install SSRS on the active node, with the databases configured on an instance...

Looks like you have a space at the end of the database name. This is causing a problem when trying to access the folder location because you cannot have...

It is available in the Advanced version - but, there are restrictions so make sure you understand what they are.

Triality (6/6/2011)

---

What high availability options are available for those of us that just use the simple recovery model on our databases outside of manually taking a backup and manually restoring...

I believe what you are seeing is expected. SQL Server will utilize as much memory as you allow it.

What SQL Server does is loads data into the buffer cache...

Shark Energy (6/6/2011)

---

The way I understood it was that to get the best performance for SQL out of a SAN you would want to split Data and Logs on separate...

What do you mean you cannot access the database? How are you getting the data in the...

It sounds like you are backing up across the network - which is most likely the largest part of the problem. If possible, change the backups to local storage...

sunilg 95099 (6/4/2011)

---

Actually my problem is that date is coming in dd/mm/yyyy string format from database now when i am trying to convert it to any date format in ssrs,...

The...