Viewing 13 posts - 1 through 13 (of 13 total)
October 18, 2018 at 1:58 am
So for adhoc (i.e. SQL from the application), we can get the query from the plan cache? Excellent! I'm clearly behind on what's possible in SQL Server.
October 17, 2018 at 8:51 am
Hi John,Thanks for the reply.My problem is getting the full query for the statements. I assume I'm going to have to trawl the application source and stored procedures...
October 17, 2018 at 8:08 am
Thanks - that's what I thought.
The problem is the customer wants to put representative data in terms of volumes on the new system, but wants it anonymised. If it...
August 5, 2016 at 10:31 am
Thanks - that' really useful. I'll give it a go.
Having said that, I read late Friday that Azure 12 will accept indexes with FillFactor specified now. I'm checking with...
August 1, 2016 at 1:26 am
Thanks for the links - I hadn't found them despite some creative Googling. It appears from the 1st one that it's possible to reproduce this. To be honest, given that...
August 4, 2015 at 2:20 am
Thanks for the info - I'll take on board!
June 3, 2011 at 6:27 am
Perfect - just what I needed to know, thanks.
June 3, 2011 at 4:47 am
Thanks for the responses - they're very helpful.
August 30, 2010 at 10:05 am
Thanks - good point to just keep one trace. If I keep the output lightweight then there shouldn't be too much load on the server.
Thanks for the links - very...
December 24, 2009 at 2:30 am
Thanks, everyone, for the pointers.
You've confirmed my thoughts that the DMVs won't give enough/the right information for what I want.
I'm running my trace using sp_trace_create, which I...
December 23, 2009 at 9:21 am
Gift Peddie (12/23/2009)
James Lavery (12/23/2009)
In order to make this work with Windows 7 (we never bothered...
December 23, 2009 at 9:13 am
So just to be clear, you're saying that (notwithstanding any code changes I might have to make in my .NET 1.1 client to work with 2008) I should be able...
December 23, 2009 at 5:13 am