Viewing 15 posts - 16 through 30 (of 49 total)
ok, thanks. ( I already have it )
I found my problem, I needed to search the complete word to get the result.
Here's what I mean:
SELECT *
FROM SermonList
WHERE CONTAINS(DocumentContent,...
January 23, 2012 at 6:10 pm
It is SQL 2008
and this is what I can find from the logs:
No appropriate filter was found during full-text index population for table or indexed view '...'(table or indexed...
January 23, 2012 at 4:38 pm
ok, thanks, Craig.
April 7, 2011 at 4:06 pm
Based on the plans u can see they both have different plans.
The question still though is how come the view has a better plan than that of ...
March 14, 2011 at 3:19 pm
I've attached the plans for both: View and Sproc
Thanks.
March 14, 2011 at 1:14 pm
I did, and that's why I put the statistics for IO from the exec plans.
My question is why is it that the exec plan for a view is better than...
March 14, 2011 at 12:13 pm
ok. I assume this to be the "Audit Login" event.
Thanks for all ur help.
March 10, 2011 at 6:41 pm
ok, thanks...
I am trying to capture the eventclass: ExistingConnection, to get the connection settings -- but, when I turn on the profiler on, I see the first few entries for...
March 10, 2011 at 12:19 pm
I do see a different exec plan for when the app runs, and when I run it in SSMS!
So I guess as you have indicated, the client is probably affecting...
March 9, 2011 at 6:01 pm
ok.
Is there a way I can see these settings via Profiler?
thanks
March 9, 2011 at 5:44 pm
Sorry, but:
1. Running with exact same parms
2. Server not too busy
3. Same result set -- About 10 rows
March 9, 2011 at 5:23 pm
Great! Thank you so much.
March 9, 2011 at 1:07 pm
ok...
It says: exec sp_executesql N'....
Does it mean a dynamic sql sent from the client instead of a stored proc...
thanks again
March 9, 2011 at 12:57 pm
If I can tag along here, I have another issue:
We have so many reports in SSRS, and some of the users need a better/faster way of identifying the reports (the...
February 10, 2011 at 1:37 pm
Viewing 15 posts - 16 through 30 (of 49 total)