Viewing 15 posts - 571 through 585 (of 1,048 total)
Ho many rows are we talking about? You could try inserting these rows into a table variable using an order-by and run the aggregate against the table variable.That should run...
April 27, 2011 at 2:29 pm
An index can't be used for this: where name like '%Name1%'
anytime you are searching for a pattern somewhere in the middle of the column the index seek cannot...
April 27, 2011 at 9:21 am
You will not have issues that prevent you from taking advantage of the performance enhancements of SQL Server or the new 64bit hardware & more memory.
In fact most of the...
April 27, 2011 at 8:33 am
Well stated Sir.
"Do not spoil what you have by desiring what you have not;
Remember that what you now have was once among things you only hoped for."
~Epicurus
April 26, 2011 at 8:47 am
A 64bit platform can make a marginal design run well because it can put everything back in main memory again which makes everything run faster again (for a while anyway)....
April 22, 2011 at 1:54 pm
I believe what may be causing that is that when a database is restored it can end up with a new owner... if the login that restored it is different...
April 22, 2011 at 12:36 pm
The description of your architecture does not sound optimal for what you are doing. At the very least you should ditch the COM crap, and retrofit using using...
April 22, 2011 at 10:54 am
tell me more about these com objects you are using.
April 22, 2011 at 7:54 am
Well, the query is aggregating rows based upon these unique entities:
case when sugar=1 then 'sugar' else 'bread' end, sp1, cl1, da, d.m, m.cu, m.to
So I am thinking that maybe...
April 21, 2011 at 12:12 pm
If it were me I would make my best guess as to the proper type and do a trial insert into a table. To keep things simple and low overhead...
April 21, 2011 at 11:14 am
Without being able to test I might suggest the following:
select
case when sugar=1 then 'sugar' else 'bread' end as type,
sp1,
cl1 as pr,
da,
d.m,
m.cu,
m.to,
sum(case when sugar=1 then 1 else cast(init as float(10,2)) end)...
April 21, 2011 at 9:30 am
Heh heh, well, I was about to overlook your comment about the cats and dogs and commend you on your quality of preparation personal responsibility, but then I noticed you...
April 21, 2011 at 8:23 am
GilaMonster (4/21/2011)
??
It was meant as a joke.
April 21, 2011 at 8:02 am
An issue regarding the extensive use of software/firmware and intercommunication in new cars is not only that of security, but of survivability.
Systems subjected to EMP or high level of radiation...
April 21, 2011 at 7:58 am
You may not close any topics, especially of yourself. It will be used for evidence.
April 21, 2011 at 7:21 am
Viewing 15 posts - 571 through 585 (of 1,048 total)