Viewing 15 posts - 676 through 690 (of 9,641 total)
I think this post might help you find the table it belongs to, http://www.sqlskills.com/blogs/paul/inside-the-storage-engine-how-are-allocation-unit-ids-calculated/
One issue is that the page type (m_type = 3) is a "text mix page", which I...
September 17, 2014 at 11:28 am
In order to do this with a constraint you'd have to write a UDF that would allow you to check the data in the other table.
A trigger may be a...
September 17, 2014 at 11:02 am
If you got the data from a trace or extended events session then you'd include the application name or appname in the output of the trace or XE session. ...
September 17, 2014 at 10:54 am
rob.delong (9/17/2014)
September 17, 2014 at 10:49 am
RenzoSQL (9/17/2014)
Unfortunately this is not possible with a Matrix and the ReportItems collection does not go outside the scope of the current date region. 🙁
That really makes ReportItems a lot...
September 17, 2014 at 10:37 am
Grant Fritchey (9/17/2014)
So this is happening[/url]. If any of the Threadizens are inclined to make a blog post (or three) in support, I'd be appreciative.
Just saw that in the PASS...
September 17, 2014 at 7:50 am
I think the way to do it is:
FEP:
=ReportItems!T1_FEPTotalTextBoxName.Value/ReportItems!T2_FEPTotalTextBoxName.Value
LocalBus:
=ReportItems!T1_LocolBusTotalTextBoxName.Value/ReportItems!T2_LocalBusTotalTextBoxName.Value
September 17, 2014 at 6:28 am
Gary Varga (9/17/2014)
Jack Corbett (1/5/2009)
...I worked for/with an excellent developer who did not document well...
In my opinion, that is an oxymoron. Excellent developers document well. The definition for...
September 17, 2014 at 6:23 am
Do you need the percentage only for the total row or for each detail row?
Is the data region a table or a matrix?
Can you post what the data in the...
September 16, 2014 at 12:18 pm
Sean Lange (9/16/2014)
Steve Jones - SSC Editor (9/16/2014)
September 16, 2014 at 12:06 pm
I believe what you have is a classic gaps and islands problem for which there have been many articles written. This search will point you to a few articles...
September 16, 2014 at 12:02 pm
Okay, a remote query is usually when you are accessing data across a linked server. Unless user setup to access the linked server has elevated permissions it does not...
September 16, 2014 at 11:52 am
Have you seen this, http://blogs.msdn.com/b/dbrowne/archive/2012/05/21/how-to-add-a-hostname-alias-for-a-sql-server-instance.aspx? It looks like it shows how to do exactly what you need to do.
September 16, 2014 at 11:47 am
Yes, the SQLSkills classes are probably the best out there. Brent Ozar Unlimited and PrgamaticWorks are 2 other companies that offer some good training classes usually taught by MVP's,...
September 16, 2014 at 11:40 am
I'm not sure I understand what you want for a final outcome.
Do you want to show a % per month of the total from T2 like:
January | ...
September 16, 2014 at 11:32 am
Viewing 15 posts - 676 through 690 (of 9,641 total)