Viewing 15 posts - 1,711 through 1,725 (of 3,061 total)
mpradeesh (7/20/2010)
There is no primary/foreign key relationships and so no joins please.
:blink: What is this supposed to mean?
Are you trying to say that there is no way to know which...
July 20, 2010 at 9:57 am
mupparaju78 (7/20/2010)
wat is dirty data. how many ways is there if i want remove the dirty data in sql server 2005
Firstly... would you mind in defining "dirty data"?
Secondly... as a...
July 20, 2010 at 9:47 am
cmbrooks08 (7/19/2010)
July 19, 2010 at 6:37 pm
jolan.mahinay (7/19/2010)unpartitioned table contains about 600 000 rows and a query given to me to test it, its takes about 2 minutes and 50+ seconds, so i tried now the...
July 19, 2010 at 8:30 am
jolan.mahinay (7/19/2010)
sir mrdenny how many minutes did your query goes for a hundreds of millions records? what was your method or way to accomplish a good performance please help
One thing...
July 19, 2010 at 8:25 am
YSLGuru (7/7/2010)
Apparently this lets the developers avoid learning how to use SQL
Then people asks why we are flooded by poorly written code. Appalling
YSLGuru (7/7/2010)
July 19, 2010 at 6:39 am
ningaraju.n (7/19/2010)
I have a table with more than 30 million records .now i thought of partitioning the table on primary key please suggest me the approach.
I usually ask myself a...
July 19, 2010 at 6:20 am
In general I go for partitioning only for tables expected to hold in excess of 100M rows, partitions 100K rows in size really does not make a lot of sense.
For...
July 19, 2010 at 6:08 am
ara_tech2004 (7/18/2010)
July 18, 2010 at 5:37 pm
MrCapuchino (7/17/2010)
USid int IDENTITY (1,1)...
July 17, 2010 at 3:09 pm
Jeff Moden (7/16/2010)
July 17, 2010 at 2:45 pm
Not totally sure if I get your question but "Query Time Out" is a server level property. Select your target server, right click, Properties, Connections, check Query time-out property. 0=Unlimited
On...
July 17, 2010 at 1:59 pm
Sorry. I'm not familiar with PL/SQL Developer.
In general we do test/trace new queries in the way I suggested previously - all new queries, one by one, running in the host...
July 17, 2010 at 7:17 am
timcarper (7/16/2010)
July 16, 2010 at 2:51 pm
You gotta love Monty Python's "Ministry of Silly Walks" 😀
You certainly made my day mate. Cheers.
July 16, 2010 at 2:45 pm
Viewing 15 posts - 1,711 through 1,725 (of 3,061 total)