Viewing 15 posts - 376 through 390 (of 851 total)
Ross McMicken (3/30/2009)
March 31, 2009 at 4:45 pm
RBarryYoung (3/29/2009)
March 31, 2009 at 4:42 pm
[font="Verdana"]Flo raises some very good points.
If your list of shapes is finite and known in advance, then model them individually. You will get better performance, and it's easier to...
March 29, 2009 at 3:31 pm
[font="Verdana"]Should I be worried that apparently SQL needs a brush, and the web site can't find it? :blink:
Nice to know I'm not the only person who finds Joe Celko...
March 29, 2009 at 1:54 pm
[font="Verdana"]So long as you are happy writing the SQL, then joining the additional tables should be fine.
You can create views that already have the joins done to simplify things if...
March 26, 2009 at 1:07 pm
Bob Hovious (3/25/2009)
Hey Grant, I've been meaning to ask this for a month.What exactly *is* that you are using for an avatar/icon?
[font="Verdana"]I've always assumed it's one of...
March 25, 2009 at 5:08 pm
Florian Reischl (3/25/2009)
Why the dynamic SQL? I'm still working with some SQL Server 2000. With ROWCOUNT you can do the same.
[font="Verdana"]Yes, but the performance is far worse than using TOP....
March 25, 2009 at 3:09 pm
[font="Verdana"]Another idea...
Part of the SQLCMD is the ability to create variables for the environment (rather than T-SQL variables.) You could use this to build a command line script that...
March 25, 2009 at 2:37 pm
[font="Verdana"]Flo, I've actually dynamically built stored procedures and then executed them in the past for this kind of thing. So you'd end up with code that did the following:
1....
March 25, 2009 at 2:26 pm
[font="Verdana"]I concur with Flo: this has been my approach to batched updates (or inserts, or deletes) in the past.
It was a bit harder in SQL Server 2000: you had to...
March 25, 2009 at 2:24 pm
Michael Valentine Jones (3/24/2009)
I am reposting various methods for start of time periods that I originally posted on the links below.
[font="Verdana"]Thanks so much, Michael. Very fortuitous timing. I...
March 24, 2009 at 4:50 pm
Lynn Pettis (3/24/2009)
SQL Server 2005 hasn't been out for ten years, how can you have ten years experience with it?
[font="Verdana"]I think someone forgets to tell the HR people compiling the...
March 24, 2009 at 3:41 pm
Lynn Pettis (3/24/2009)
Okay, now I am beginning to feel like a counselor. is that also part of being a saint?
[font="Verdana"]Absolutely. Some excellent halo polishing going on there. ...
March 24, 2009 at 3:21 pm
Bob Hovious (3/24/2009)
I console myself about aging by reminding myself that I'm only 34 in hex.
[font="Verdana"]There are 10 kinds of people in the world: those who understand binary, and those...
March 24, 2009 at 2:27 pm
Larry Kruse (3/24/2009)
1. Using stored procedures is much more secure as it prevents any possibility of injection attacks.
[font="Verdana"]Not entirely true, sad to say. Certainly it makes it harder,...
March 24, 2009 at 2:13 pm
Viewing 15 posts - 376 through 390 (of 851 total)