I appreciate this is an old post but thought it may be worth replying.

IOPS provisioning is optional and if you provision a set value you will be charged for it....

Amazon web services supports the building of virtual machines using there EC2 functionality, there is free layer servers that you can build that have SQL express installed. The also...

Open the properties of your publication, go to articles, select your table, click on the button "Article properties", select "set properties of highlighted article". With the properties change...

This should help:

SELECTCourseGroup,

Title_Offering,

No_People_attended,

ROW_NUMBER() OVER (PARTITION BY CourseGroup ORder By No_People_Attended DESC) AS RowNumberResults,

RANK() OVER (PARTITION BY CourseGroup ORder By No_People_Attended DESC) AS RankedResults,

DENSE_RANK() OVER (PARTITION BY CourseGroup ORder...

Can you provide a sample output of what you would expect given your data? I am struggling to understand what data you want returned.

Using a combination of Jeff and I's solution, you can replace DENSE_RANK() WITH RANK() should you not mind gaps in the ordering when you have more than 1 instance of...

here you go, I'll let Jeff update his solution:

**** removed my code *** that didn't work. . Will post back

What parameters is the procedure expecting? Run sp_help then the name of the procedure to get a list. Chances are your procedure expects more than the one parameter...

As far as I am aware SQL will only write to the application log, its not possible to write to the security log.

So all lastnames that are the same will get the same incremental number?

I.e. All surnames of Jones become Lastname1 and all surnames of Taylor get LastName2

SQL Nexus is a good tool to evaluate the performance of a server whilst perfoming a load test.

http://sqlnexus.codeplex.com/

To evaluate the IO subsystem there is a utility called SQLIO:

http://www.microsoft.com/en-us/download/details.aspx?id=20163

I assume by...

Something like this:

USE tempdb

GO

IF EXISTS (SELECT * FROM sys.tables WHERE name = 'Names')

DROP TABLE Names

GO

CREATE TABLE Names (

PKID INT IDENTITY(1,1),

LastName nvarchar(100)

)

GO

INSERT INTO Names (LastName)

SELECT 'Jones' UNION ALL

SELECT 'Smith' UNION ALL

SELECT...

Actually found a few flaws in my first attempt, try this:

USE tempdb

GO

IF EXISTS (SELECT * FROM sys.tables WHERE name = 'TestData')

DROP TABLE TestData

GO

CREATE TABLE TestData (

ID INT,

PRODUCT NVARCHAR(100),

ProdID int,

STRTAGE int,

ENDAGE...

Given that you did not post any DDL, how about this as a solution. You will need to tweak it to suit your code:

USE tempdb

GO

CREATE TABLE TestData (

ID INT,

PRODUCT...

Can you post up some sample code for creating the table and data and any solution you have attempted so far. It will make helping you much easier.