sp_dboption is a depreciated feature, user alter database instead

ALTER DATABASE myDB SET SINGLE_USER

Unsure what DB platform Amazon run off, but for SQL you could look at Full Text Indexing.

IIRC, I had an issue with online transfer with columns called ErrorCode, as it gets confused with the column vs the SSDT package ErrorCode output variable to say if the...

Do you log when a deadlock occurs?

From my experience I didn't start out with the training kits, I got chucked in at the deep end in sort of a sink or swim environment as it was...

A good place to start would be the Accidental DBA guide (link in my signature), good book on some of the common problems faced.

The stairways section of the site as...

diequintana (1/9/2013)

---

Thanks for your quick response.

I’ll modify the sub plan A avoiding recovery model to be changed from full to simple. However I’ll leave that task in sub plan B...

We dont use SSRS in the current company I am working for its all done via Cognos, but previously a minium SSRS server was 8GB RAM with 2 VCPUs.

Its a difficult one to say as we dont know what your going to be pushing through your report server, but deffinatly go heavy on CPU, it can get quite...

Please detail the problem and the solution, so that if anyone having the same issue, may try your solution.

The partition will restart the row number based on that you detail.

So in the examples on the MSDN article, Example C uses partition, so that you can see the top...

dwain.c (1/9/2013)

---

You are assuming sir that...

Can you explain which bits you are not clear on?

I would say this is where a calendar table like this one will come into best fit. http://www.sqlservercentral.com/scripts/Date/68389/

Then you can query it to find todays quarter, then lookup the previous...

Its a ranking function, which gives a list of rownumbers based on what you detail in the partitioning and ordering clauses.

The URL should explain it for you http://msdn.microsoft.com/en-us/library/ms186734.aspx