Awesome advice, worked like a charm.

For reference, the Extended Events page on Jonathan's blog is:

http://sqlskills.com/blogs/jonathan/category/Extended-Events.aspx

Since am setting this up on SQL 2012, it is actually very easy and yields interesting...

Heya,

I reckon you need to use a combination of CROSS TAB (or PIVOT, whichever you are more comfortable with), and the DATEPART function to extract the HOUR.

So, combining these both,...

Recently I've been getting into the Joes 2 Pros SQL Server series, its a nice collection of small and very well written books.

Amazon UK Search for Joes 2 Pros

They are...

hmm, whether your calculations work or not depends on the Groupings you have setup in that SSRS report, and exactly on what level of the grouping are you adding these...

Not entirely sure what you are trying to do here, and whether this is a one-off task or if you want to regularly synchronize the DB with Outlook.

You could simply...

There are multiple reasons why a 503 might be returned from your SSRS Manager.

Now I assume you are trying to use an SSRS Manager (the URL of which you found...

Thanks for the quick reply Brandie!

Thats a pretty good suggestion, I'v not used this transformation before, interestingly (and by name) it seems like its used for Dimension tables, although am...

I have noticed that too on my servers.

Not entirely sure why though.

Not sure if this would work or not, don't have a test instance handy at the moment.

But you could possibly try using "HAVING" to filter in the inner query instead...

have a look at CROSSTAB or PIVOT

http://www.sqlservercentral.com/articles/T-SQL/63681/

You should be able to get both ROLLBACK and DEADLOCK from SQL Profiler, you'll need to capture for ROLLBACK:

> Event: Transaction:Transaction Log you'll find a Rollback or Commit in the...

Hey,

There is a couple of ways you can do this that I can immediately think of.

> With the current output that you have, you can Transpose the row data to...

Hey,

You can take a look at Bi Verdict[/url], they have useful comparison information on the top competitors offering BI frameworks.

Gartner also released an awesome piece of analysis on all the...

For alot of cases Cursors are fine.

If you are sending the same email multiple times then you might be better off concatenating all TO (or CC if you want to...

Well,

NORMINV(p, mu, sigma) = mu + sigma*NORMSINV(p)

So all you need to do is get a NORMSINV(p) UDF (one can be found at: SqlServerCentral[/url]) and implement the formula above in...