Viewing 15 posts - 48,031 through 48,045 (of 49,571 total)
Floats are inaccurate data types. Numerics are precise.
From Books online
The float and real data types are known as approximate data types. The behavior of float and real follows the IEEE...
December 18, 2007 at 3:46 am
Since you're using SQL 2005, look up Pivot in Books Online. Does exactly what you want.
December 18, 2007 at 3:41 am
What defines which invoices are considered top for each account? Invoice daet? Amount? Number of items ordered?
Can you please post the schema of the tables involved, some sample data and...
December 18, 2007 at 3:33 am
Philip Horan (12/17/2007)
Back up Database (Full) / Shrink Database / Rebuild Index / Reorganize Index
Don't shrink your production databases. It's a waste of time and resources and it...
December 17, 2007 at 2:03 pm
DTS. Fast load and limit the number of rows in each batch.
If possible, switch to bulk-logged mode before and switch back to full (and take a full DB backup) once...
December 17, 2007 at 1:53 pm
Since you're using SQL 2005, look up Pivot in books online.
Does exactly what you're looking for.
p.s. Why the restriction on not using temp tables, functions, etc?
December 17, 2007 at 5:32 am
The reason he got the error is, as I mentioned above, due to the subquery only working if there is 1 row in it. It's due to the equality.
The...
December 17, 2007 at 5:29 am
sven.blackwood (12/16/2007)
December 17, 2007 at 1:28 am
Take a look at SQL profiler. There are counters for object access. Be warned, they are fairly high-frequency events, so you'll get lots and lots of trace data.
If you go...
December 17, 2007 at 1:26 am
Than rather move the contents of the stored proc into the trigger, so you don't have to call the proc for each updated row, but can operate on all rows...
December 16, 2007 at 11:59 am
If they're on the same LUN, not much. You'll only see a real performance gain (in physical IO speed) if the files are on separate LUNs
December 16, 2007 at 5:36 am
WILLIAM MITCHELL (12/15/2007)
So according to MS, the app devs don't need to know anything about the database.:sick:
Personally, I'd rather they didn't, and asked people who do to write them the...
December 16, 2007 at 5:27 am
Is the column in question the first column in that composite index? If yes, an index on it alone will be redundant. If no, then create it.
I'll second the comment...
December 16, 2007 at 5:13 am
Do you have any linked servers defined? If so, using what drivers?
I've encountered a number of memory leaks and memory scribbling coming from a DB2 driver (IA64 version)
December 14, 2007 at 2:50 pm
TaffyLewis (12/14/2007)
select t1.A, t1.C, t2.C
from t1 inner join t2
on t1.A = t2.A
and t1.C = t2.C
t2.c is the date field
t1.C and t2.C are the same values. Your join assures that....
December 14, 2007 at 2:48 pm
Viewing 15 posts - 48,031 through 48,045 (of 49,571 total)