Viewing 15 posts - 14,191 through 14,205 (of 15,381 total)
Just my 2¢ but I think you will find a lot more issues down the road trying to parse this out column by column. It is incredibly difficult to put...
August 23, 2011 at 1:16 pm
Lowell (8/23/2011)
Ninja's_RGR'us (8/23/2011)
August 23, 2011 at 11:57 am
Did you look in the windows event logs? It may give you some insight.
August 23, 2011 at 11:34 am
huh? Are you asking how to make a database not accept connections?
August 23, 2011 at 11:32 am
I certainly see why you say that based on your post earlier today where the suggestion was to look at google. Which of course did not even come close to...
August 23, 2011 at 10:23 am
nano2nd (8/23/2011)
id 1
Mask...
August 23, 2011 at 10:17 am
Another option, if you can be 100% certain you have valid time values is to sort by casting the column as a time datatype. This also assumes you are using...
August 23, 2011 at 9:56 am
But this does not really solve the OP's question.
Is there a way to search a string across values of all the columns of all the tables
It is WAY faster...
August 23, 2011 at 7:39 am
californication2704 (8/22/2011)
August 22, 2011 at 3:16 pm
It does appear that your function is the major bottleneck. Scalar functions are notorious for being huge hits on performance. There is a great thread here talking about the difference...
August 22, 2011 at 3:03 pm
If you can explain what the "results" are we can probably help. Nice job providing the ddl and sample data but it is totally unclear what you want out.
August 22, 2011 at 8:21 am
You really can't find a faster solution. I just wanted to make sure to warn you about it completely destroying your server before you ran it your production server during...
August 22, 2011 at 7:28 am
LOL. :hehe:
August 19, 2011 at 2:12 pm
As is typical around here can you share you solution so others who search your question later can find your resolution? Glad you solved it.
August 19, 2011 at 2:09 pm
Why don't get your grand total by itself first in a separate query? That seems like the easiest way.
select @GrandTotal = sum(MyStuff)
then your query.
[MYSTUFF] / @GrandTotal * 100 AS [GRAND...
August 19, 2011 at 2:04 pm
Viewing 15 posts - 14,191 through 14,205 (of 15,381 total)