"Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation...

Yu will need to register the SQL server under the SQL Server Group. Its local profile based so if you have never used Enterprise Manager on the server before...

Perry Whittle (7/2/2012)

No, it won't, as the remaining files in...

looks like you want to look at row level groupings in SSRS

http://msdn.microsoft.com/en-us/library/ms170246%28v=sql.90%29.aspx

Windows might be 64bit but is SQL 64bit?

add another file to the filegroup that way SQL will stripe the data across both files in an equal proportion

There are links in my signature on Cross Tabs, if you are stuck please follow the second link in my signature on posting code and data so that we can...

Hi

This is a Microsoft SQL Server forum, not a MySQL forum so you might be best asking MySQL questions on a dedicated MySQL forum.

But I am sure that there are...

enable auto growth

manually add space to the file

delete data

http://www.sqlservercentral.com/Forums/Topic1320505-391-1.aspx

looks like you have already posted the same question a number of times

http://www.sqlservercentral.com/Forums/Topic1320505-391-1.aspx

DECLARE @tblProductInfo TABLE (ProductID INT, ProjectID INT, SaleMemberID INT, SaleClosedPrice INT, SaleDate DATE)

INSERT INTO @tblProductInfo VALUES

(1,1,1,1000,'2012-04-01'),

(2,1,2,500,'2012-06-04'),

(3,1,4,500,'2012-05-06'),

(4,1,5,5000,'2012-08-06'),

(5,1,3,1000,'2012-09-01'),

(6,1,2,500,'2012-09-06'),

(7,1,4,500,'2012-07-06'),

(8,1,5,5000,'2012-09-06')

SELECT * FROM @tblProductInfo

DECLARE @FromDate DATE = '2012-06-07', @EndDate DATE = '2012-06-08'

SELECT

*

FROM

@tblProductInfo

WHERE

SaleDate BETWEEN @FromDate AND...

Add the column to the group by statement or remove the column from the select.

what is your dateformat MDY or DMY, also your @fromdate and @enddate look like they are the wrong way around

depends what the connections are doing, thats why you need to diagnose your CPU pressure, it could be that there is a bad query somewhere which is executed when a...