Viewing 15 posts - 1 through 15 (of 30 total)
This may work without looping :
select 'table1', * from t1 where name='Name1'
select 'table2', * from t2 where name='Name1'
select 'tableN', * from tN where name='Name1'
June 4, 2007 at 7:24 am
I agree with Colin when stating "It's really difficult to be precise but I'd probably consider 2000 tables vs 1 table as a really bad idea, as I say it's...
January 20, 2007 at 12:39 am
as a start,,,
Stored procedures are the only SURE way to guard against SQL Injection attacks.
Stored procedures offer more security as the application only has execution privileges against procs but not data...
January 20, 2007 at 12:25 am
My take inline below in BOLD:
This might be a dumb question.......
>>> we all learn on daily basis
I have a question regarding...
January 18, 2007 at 11:55 pm
The query should run fine even on a pc. 19GB is common these days.
just make sure the fields in where clause are covered by an index.
we have tables that cross...
January 1, 2007 at 1:26 am
I think Mohammed Uddin answer is the closest to your need, but,when a row is (physically deleted) it is gone , so it will not help unless you query data...
December 15, 2006 at 12:30 am
if you are using sql2005 then you can use DDL triggers.
if you are using sql2000 then when ever a table is created then
insert into a special table the...
December 10, 2006 at 3:54 am
I agree with Taj.
If you post some details of any performance problems you may be facing, then may be some of our gurus here offer help.
December 1, 2006 at 9:47 pm
visiting this site on regular basis is a great place for SQL tuning learning...
November 30, 2006 at 11:59 pm
That is a tough one
No hardware additions ! if you are hitting the ceiling with the current HW may be it is recommended...
October 16, 2006 at 1:43 pm
SQL2005 has great support for replication to/from Oracle.
It is simple and traight farward especially if data is flowing in one direction. We use it to support multiple servers and it...
October 11, 2006 at 12:03 pm
I agree with colin Leversuch-Roberts that Table Partitioning is great ,, BUT only if using SQL2005. So if you plan to move to...
August 31, 2006 at 6:40 am
Transactional replication may serve you better. Triggers are OK unless you have heavy update/insert load.
August 26, 2006 at 1:27 am
I'd say, if you had efficient enough hardware [fast CPUs, enough memory and efficient disk system,i.e. RAID 1+0 or similar] then i would keep all in one table.
You have to...
August 26, 2006 at 1:19 am
I would also
1 - Upgrade to Windows 2003 to benefit from its stability and efficient memory handling compared to W2K.
2 - Install more memory. RAM is cheap these days.
3 - If...
January 5, 2006 at 10:46 pm