Viewing 15 posts - 721 through 735 (of 851 total)
[font="Verdana"]Have you tried getting your application to generate two files (one for parent table, one for child table), and then using bulk insert to load the files?[/font]
February 10, 2009 at 12:29 pm
[font="Verdana"]I do this sort of thing with left outer joins. I believe SQL Server is pretty much smart enough to generate a nearly identical query plan for the two...
February 10, 2009 at 12:23 pm
[font="Verdana"]Sigh. There's always a critic. 😛
Quite right, of course. A calculated column with getdate() in it will not persistable.[/font]
February 10, 2009 at 12:19 pm
PaulB (2/10/2009)
Bruce W Cassidy (2/9/2009)Try creating an index on a bit field in SQL Server 2005. Yes, it works.
Unfortunatelly that's not the concept of an Oracle bitmap index ...
February 10, 2009 at 12:16 pm
[font="Verdana"]I'd still want to do that through declaritive security. But... give it a go! Let us know the results. :D[/font]
February 9, 2009 at 6:51 pm
[font="Verdana"]True.
Perhaps a better approach would be a join to a Calendar table, where MonthNumber = 1? But if you don't have a Calendar table, your second form is correct.
[/font]
February 9, 2009 at 5:42 pm
[font="Verdana"]
You could try using something like the following:
select *,
case
when...
February 9, 2009 at 5:34 pm
[font="Verdana"]Have a look at the query plan. I'd expect it to use the index though.
Also, try and get in the habit of writing your dates as 'YYYYMMDD', because just...
February 9, 2009 at 5:28 pm
[font="Verdana"]It's usually not too hard to do a code search within the database and applications to find whether a column is referenced.
I agree that the use of an instead of...
February 9, 2009 at 4:49 pm
Perry Whittle (2/9/2009)
In Oracle RAC the distributed cache memory is shared between the cluster nodes and this offers...
February 9, 2009 at 4:02 pm
[font="Verdana"]Check out the merge statement in SQL Server 2008.[/font]
February 9, 2009 at 3:06 pm
PaulB (2/9/2009)
[...]and stuff that does not exist in the SQL Server world like bitmap indexes, star-transformation, materialized views, etc. - just to mention a few of them 😉
[font="Verdana"]Reverse-key indexes and...
February 9, 2009 at 2:58 pm
[font="Verdana"]You will often see that "numbers" table referred to as a "tally" table here as well. Yeah, I need more practice around thinking about set-based results in that fashion.[/font]
February 9, 2009 at 2:26 pm
[font="Verdana"]I think you want an operator.
Dial tone...
Me: Operator? I want to compare two strings please.
Operator: =!=<>
Wow, operators these days are so rude!
[/font]
February 9, 2009 at 2:24 pm
[font="Verdana"]SQL Profiler will capture exactly what is going on, and you can limit it down to just capturing what is happening with that table. It does take a little...
February 9, 2009 at 2:20 pm
Viewing 15 posts - 721 through 735 (of 851 total)