Viewing 15 posts - 2,326 through 2,340 (of 2,894 total)
Have you rebuild the fulltest index after removing WITH from stoplist?
You can try to diassociate stoplist from Index:
ALTER FULLTEXT INDEX ON table_name SET STOPLIST OFF
What is compatibility level of...
July 28, 2011 at 5:36 am
Brandie Tarvin (7/28/2011)
I don't know how well the new SSRS does drilldowns. I know in Crystal reports, you can hide the details and show summary lines which can be clicked...
July 28, 2011 at 5:13 am
If the data you have if so sensitive and you want to implement access audit in t-sql (which not the best design idea), you can do the following:
1. Remove SELECT...
July 28, 2011 at 5:03 am
1. If you re using SSRS to produce report, grouping can be done in SSRD itself
2. You was almost there 😀
select
...
July 28, 2011 at 4:57 am
Ninja's_RGR'us (7/27/2011)
CELKO (7/27/2011)
July 27, 2011 at 7:35 am
Would you mind to add data-population script, so tables would have sample data to play with. Also, sample of how expected results should look like will help a lot.
And just...
July 27, 2011 at 7:23 am
Personally I prefer to use:
SET STATISTICS TIME ON
and / or
SET STATISTICS IO ON
simple and informative 😀
July 27, 2011 at 6:22 am
OK, OK, Sorry! Just was in playfull mood (not snarky, was need to google up this word to translate:-)) ...
Should be just simple:
Give us the code!
July 27, 2011 at 6:19 am
Brandie Tarvin (7/27/2011)
Eugene Elutin (7/27/2011)
Brandie Tarvin (7/27/2011)
You can't have line item detail and a summary together that will display correctly in SSMS. You get to pick: Detail or Summary. Not...
July 27, 2011 at 6:01 am
Riskworks (7/26/2011)
When I call it from another Proc I get an error saying that there is an invalid column at line 268.
There is no reference to the column anywhere around...
July 27, 2011 at 5:53 am
Are you always using MAXDOP 1 in your queries?
You don't trust MS at all are you? 😀
It used to be that LEFT JOIN with check for NULL was...
July 27, 2011 at 5:43 am
He used square brackets arround server IP, so it should not be a problem for SQL Server to read it as a single name...
Also the error he would have in...
July 27, 2011 at 5:29 am
Brandie Tarvin (7/27/2011)
...You can't have line item detail and a summary together that will display correctly in SSMS. You get to pick: Detail or Summary. Not both.
...
You can display them...
July 27, 2011 at 5:23 am
SQL Profiler is a tracing tool, so it does show what has been executed. It's not a debugging tool.
So you will never see what the parameters values are if the...
July 27, 2011 at 4:58 am
Viewing 15 posts - 2,326 through 2,340 (of 2,894 total)