Viewing 15 posts - 1,696 through 1,710 (of 18,926 total)
GSquared (10/26/2011)
The way you did is just fine.The T-SQL Pivot function is nearly useless, in my opinion. Don't bother with it.
How come?? Never bothered to learn it but...
October 26, 2011 at 9:29 am
This monitors jobs & blocking.
Free 14 days trial + available 14 days extension
October 26, 2011 at 9:20 am
GilaMonster (10/26/2011)
Ninja's_RGR'us (10/26/2011)
Worse comes to worst I can come in for a quick consult to try and figure it out for you.
Or I can do a remote perf review, or...
October 26, 2011 at 8:52 am
HTH & welcome to our little world!
October 26, 2011 at 8:49 am
jshurak (10/26/2011)
October 26, 2011 at 8:47 am
You're right. The information so so much wronger in the ebook version.
Wait another month before you get the "good" stuff.
:hehe:
P.S. Did I mention you're wife is right?
October 26, 2011 at 8:39 am
#1 get a copy of prod to your dev/qa machine.
#2 http://www.sqlskills.com/BLOGS/PAUL/post/Page-Life-Expectancy-isnt-what-you-think.aspx
#3 Keep tuning with this. Group & Sort by highest reads / writes and tune the worst offenders...
October 26, 2011 at 8:37 am
In ssrs 2005 I'm able to add a calculated field in the dataset as x1 and then another 1 as x1 + 1.
Then you can use those in the tables...
October 26, 2011 at 8:32 am
Thanks for the info.
As I said earlier, not really expert in xml :-).
October 26, 2011 at 8:11 am
BrainDonor (10/26/2011)
October 26, 2011 at 8:10 am
spidey73 (10/26/2011)
Why do you choose to not run the full checkdb?
I really don't know why. I inherited these servers and I never gave it a second thought.
(lame excuse, I know)
But,...
October 26, 2011 at 8:09 am
spidey73 (10/26/2011)
The command without a repair option: dbcc check (<database>) with physical_only.
Why do you choose to not run the full checkdb?
October 26, 2011 at 7:52 am
BrainDonor (10/26/2011)
GilaMonster (10/26/2011)
Chapter 8 of SQL Server MVP Deep Dives 2. </shameless plug>Two more weeks before Amazon in the UK have that. Not a happy bunny.
Available NOW
October 26, 2011 at 7:46 am
Thanks for the legwork Chris.
@StaintGr8, please notice how you can run the inner queries simply by highlighting then and hitting F5 (excluding the correlation... can't do that with the CTE...
October 26, 2011 at 7:46 am
Check the performance of that VS 2 outer applies.
CTE can become costly real fast when not used correctly and I think your setup is not optimal (going to members more...
October 26, 2011 at 7:39 am
Viewing 15 posts - 1,696 through 1,710 (of 18,926 total)