Viewing 15 posts - 46 through 60 (of 69 total)
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...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
June 15, 2012 at 10:10 am
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,...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
April 21, 2012 at 10:40 am
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...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
April 21, 2012 at 6:44 am
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...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
April 21, 2012 at 6:39 am
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...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
April 21, 2012 at 6:30 am
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...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
April 21, 2012 at 6:18 am
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...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
April 12, 2012 at 6:24 am
I have noticed that too on my servers.
Not entirely sure why though.
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
April 4, 2012 at 7:46 am
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...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 31, 2012 at 4:35 am
have a look at CROSSTAB or PIVOT
http://www.sqlservercentral.com/articles/T-SQL/63681/
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 30, 2012 at 4:34 am
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...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 28, 2012 at 11:19 am
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...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 27, 2012 at 2:09 pm
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...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 27, 2012 at 2:02 pm
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...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 27, 2012 at 1:57 pm
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...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 27, 2012 at 12:47 pm
Viewing 15 posts - 46 through 60 (of 69 total)