Viewing 15 posts - 1 through 15 (of 15 total)
Rereading your first post actually made me realise you are doing it just fine with modulo, it's just with some tables you don't have an integer column to use.
In that...
June 29, 2017 at 10:56 am
Just to be pedantic, though, this may not give the type of sample desired - it will return in an efficient-first order which may or may not be represantive of the full contents...
June 29, 2017 at 8:14 am
June 29, 2017 at 7:37 am
The issue with that is it'll result in a ful index or heap scan if there is nothing supprting it.
How about tablesample? This should only tocuh pages required...
June 29, 2017 at 7:26 am
We experienced the exact same issue generated by both the reference of temp tables and a statement that includes OPTION(RECOMPILE) for any statement executed after the point in time the...
March 6, 2015 at 11:18 am
absolutely, the issue wasnt so much how to do it, but how to automat it for 1000 + columns. Not something anyone wants to do one by one.
In the...
June 29, 2010 at 7:07 am
OK, so I started writing a query to construct the select statement. Now the editor window for a sql command on oledb source truncates the query!
Ill have to use...
March 1, 2010 at 3:49 am
scrap that idea... it tries to set char fields to bigint where it shouldnt.
I might use a data generation plan to max out the data types in the staging table...
February 18, 2010 at 3:05 am
Hmm I certainly see what you are getting at. The only problem with this is every columns length is different so It wont be so much a search and...
February 18, 2010 at 2:29 am
Hi
I have the exact same problem, however my source file has 1200 columns which is being split into 2 tables so it is not feasable to go through every source...
February 17, 2010 at 8:58 am
I find it quite funny how so few people have got this question correct - out of nearly 1000 you would expect a strong majority of correct answers. It...
January 21, 2010 at 1:30 pm
This would select (or delete) everything that is duplicated. The requirement was to delete only the first occurrence of a duplicate, or the only occurrence of any unique rows.
The...
November 2, 2009 at 3:08 am
It says no additional identity column so that doesn't outrule the hidden one that already exists... As for adding a guid it depends on how strictly you say what is...
October 31, 2009 at 5:19 am
Excellent link - that will come in very handy.
And makes my solution to the article much simpler, no need to add a fake ID or any preparation just one simple...
October 30, 2009 at 3:56 pm
I haven't read through all 12 pages of post admittedly but don't think this has been suggested...
The rules said no new columns but didn't say anything about altering existing columns,...
October 30, 2009 at 4:27 am
Viewing 15 posts - 1 through 15 (of 15 total)