What you need to do isn't all that hard, but there are a lot of moving parts. I'd suggest that you tackle this in two ways.

1. Remove public

2. Fix permissions

You...

There are probably better ways, but I think this works:

; WITH AllActions (ItemID, ActionID)

AS

(

SELECT distinct

i.itemid

, a.actionid

FROM items i

CROSS APPLY

( select a.actionid

...

One thing you might examine is your waits for the various files. If you see waits stacking up, then you have IO issues.

A few more references for you:

http://www.simple-talk.com/sql/performance/sql-server-wait-events-taking-the-guesswork-out-of-performance-profiling/

http://www.simple-talk.com/sql/performance/a-performance-troubleshooting-methodology-for-sql-server/

http://www.sqlskills.com/blogs/paul/post/capturing-wait-stats-for-a-single-operation.aspx

The rules are a mess. You can place them (almost) anywhere, which is crazy.

I don't like the idea of them after BEGIN-like statements. I'd see rules as:

Begin try

--do stuff

End try

Begin...

Packages do not necessarily fail on a single error. They can have failure logic built in and still complete, but if an error bubbles up, it is returned to the...

You have a few problems. First if there is more than one .bak file, you have no guarantee of which one your script will find.

Second, you can't include a variable...

A file copy v a backup are two different processes. There's not much you can do to tune the backup process in SQL Server.

Can you show your script? ...

This should help you:

http://msdn.microsoft.com/en-us/library/ms143731.aspx

If you are at the target memory, then you are fairly close to what is needed.

Having heaps can be a problem for performance, but not necessarily. Is there a reason...

This is really an I/O subsystem issue, and less a query tuning issue. The load from your server exceeds what the I/O system can handle.

http://mssqlwiki.com/2012/08/27/io-requests-taking-longer-than-15-seconds-to-complete-on-file/

Tuning queries to use less reads...

You are missing some data here. How can you tell an actionid for an item has been completed when the first table doesn't have ItemIDs? You have two actionIds of...

Forecast this week

For a web application, you should need a per processor license, based on the number of cores.

I don't see anything on the ALTER TRIGGER syntax, but here's Merge: http://msdn.microsoft.com/en-us/library/bb510625%28v=SQL.100%29.aspx

The idea was that all statements would require a semi-colon, which might help the language mature and enable...

Miles Neale (12/17/2012)

---

Could Microsoft do that in a new area in the "Microsoft Store"? Could you view a page that using some form of AI asks you and assists...