Viewing 15 posts - 481 through 495 (of 851 total)
[font="Verdana"]I suspect the answer is: "because".
I do know they've got some improved syntax for doing multiple row inserts in SQL Server 2008, so there the "issue" goes away.
I also know...
March 10, 2009 at 5:24 pm
[font="Verdana"]No need to use cursors for batches: top works nicely.
I would think that moving to partitioning would be the best approach. It would increase performance accessing your data, and...
March 10, 2009 at 4:46 pm
[font="Verdana"]You could possibly make this work, even with updates or inserts to both tables, by using an instead of view. I haven't tried this myself though.
As an alternative, have...
March 10, 2009 at 4:33 pm
Lynn Pettis (3/10/2009)
Effort worth expending not.
[font="Verdana"]Forth like honk if.[/font]
March 10, 2009 at 4:15 pm
[font="Verdana"]Backups? Virus scan? Database Maintenance?[/font]
March 10, 2009 at 4:13 pm
[font="Verdana"]Lucky! I dream of having a table structure like that![/font]
March 9, 2009 at 8:03 pm
[font="Verdana"]Good disclaimer. Good quote of the day too!
"I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I...
March 9, 2009 at 6:25 pm
[font="Verdana"]You might end up with something resembling this:
if object_id('dbo.MyProcedure') is not null
drop procedure dbo.MyProcedure;
--
-- MyProcedure: show how to use multiple parameters
--
create procedure MyProcedure(
...
March 9, 2009 at 5:26 pm
[font="Verdana"]Can you give us some idea of what you're actually trying to accomplish?[/font]
March 9, 2009 at 4:30 pm
[font="Verdana"]Not having a copy of Access could rule out using it, I agree. What do you have a copy of? I mean, there's no point recommending C# or...
March 9, 2009 at 3:33 pm
[font="Verdana"]Why not use Access as a front end? If it works, don't fix it...
One thought: your data already has constraints applied to it by the application (City of Heroes...
March 9, 2009 at 3:13 pm
[font="Verdana"]When you use an expression in the form x AND y, SQL Server can "lazy evaluate" by saying "if the first part is false, I don't need to even look...
March 9, 2009 at 3:09 pm
[font="Verdana"]One issue I can see: not all months have the same number of days (31st of February, anyone?). Why not encode the first and last day with the month...
March 9, 2009 at 3:01 pm
Bob Hovious (3/8/2009)
You don't like "Bohemian Rhapsody", Bruce?
[font="Verdana"]Just slogged my way through five pages of this thread... in contrast, Bohemian Rhapsody is relatively sane.[/font]
March 8, 2009 at 4:05 pm
[font="Verdana"]blink :crazy:[/font]
March 8, 2009 at 2:52 pm
Viewing 15 posts - 481 through 495 (of 851 total)