Viewing 15 posts - 46,501 through 46,515 (of 59,062 total)
Oh yeah... almost forgot... the method I described that uses multiple tables, a constraint, and a view to make a "partitioned" view, is being deprecated. If you have no...
December 17, 2008 at 8:20 pm
As already stated, this is a very bad idea because of several reasons and I might be missing a couple...
1. First of all, by definition, a "column" in a...
December 17, 2008 at 8:13 pm
As Seth's good question implies, the idea of reusing numbers or recovering missing numbers in an IDENTITY sequence is something you should consider not worrying about at all. Contiguous...
December 17, 2008 at 7:36 pm
michael vessey (12/17/2008)
I use a function to turn comma separated lists in varchars into tables (don't ask - i know it breaks 1st nornal form - it's something i inherited)
Nicely...
December 17, 2008 at 7:20 pm
We assign all such ownership as "dbo"... prevents such hassles in the future.
December 17, 2008 at 4:45 pm
SSIS, CmdShell/BCP, OPENROWSET, or Text based linked servers... each of which are in Books Online.
December 17, 2008 at 4:43 pm
You could also make a view from the two tables without much, if any, impact on performance because it'll just be doing the same joins that you're already frequently doing...
December 17, 2008 at 4:41 pm
SELECT * FROM #MARKTABLE
WHERE MARK NOT LIKE '%[^0-9.]%'
December 17, 2008 at 4:38 pm
DOS batch job with a VB Script to popup an input window. Either that, or a "control" table that will remember the last run date.
December 17, 2008 at 4:32 pm
bnordberg (12/17/2008)
Thanks Chris!that appears functional. Now to tune and see how it works with a few hundred million rows!
Why on Earth do you need to create what is essentially a...
December 17, 2008 at 4:30 pm
Chad Crawford (12/17/2008)
December 17, 2008 at 4:08 pm
Dejanette,
It would be a huge help to us if you'd post the actual data you're trying to sort in a readily consumable format along with a table creation statement. ...
December 17, 2008 at 3:38 pm
I've gotta agree with the others... if you want to split out dates and times, particularly formatted dates and times, AND you think you shouldn't follow best practices by doing...
December 17, 2008 at 3:35 pm
dphillips (12/17/2008)
Jeff Moden (12/12/2008)
December 17, 2008 at 2:44 pm
gcopeland (12/17/2008)
December 17, 2008 at 2:29 pm
Viewing 15 posts - 46,501 through 46,515 (of 59,062 total)