Two things I know of to check:

1) Server properties - make sure you have set filestream access to full access

2) You must be using Windows Authentication to access...

Jeff Moden showed a way to do this, but I would caution you about doing this for your project. Creating a view with dynamic columns is going to cause...

Are your client tools upgraded to the same level as the server?

I don't think you will get the kind of numbers you are looking for with this. SQL Server will take as much memory as it needs - in fact,...

And here is the above cleaned up a little:

Declare @days int;

Declare @inputDate datetime;

Set @days = 10;

Set @inputDate = '20081225';

;With nums(n)

As (Select Top(@days + (@days / 5 + 1) * 2)...

The first thing you are going to want to do is get that data into a usable format. That would be - put the data into a table in...

Here is a small little modification to Jack's code which will give you what you want.

-- populate temp numbers table

SELECT TOP 100

IDENTITY(INT, 1,1) AS n

INTO

...

As suggested by Luke - review the articles that he gave you the links for. Those articles will show you how to solve your problem.

If not, then...

What are the min/max memory settings for each instance running on each node?

What is the Maximum Degree of Parallelism setting on each instance?

What was the previous system configuration?

And last, but...

madhu.arda (12/23/2008)

---

thank you

We 16GB in the server and total 16GB is allocated for SQL Server.Still we got couple of times the below error in last two months.

A significant part of...

Why do you have to loop? What is the requirement that states you have to process a single day at a time?

FWIW, you could build a stored procedure that...

As long as you are not...

No, the maintenance plan plug-ins do not have any real logic behind them. The rebuild plug-in generates the code to rebuild every single index in the database(s) selected. ...

Use msdb;

Select *

From dbo.restorehistory r

Inner Join dbo.backupset b2 On b2.backup_set_id = r.backup_set_id

Inner Join dbo.backupmediaset b3 On b3.media_set_id = b2.media_set_id

...

WebTechie38 (12/22/2008)

---

Hi,

I couldn't use SSMS because it was giving me an error message. I tried but since the tables had a lot of data, I couldn't just move the...