Viewing 15 posts - 406 through 420 (of 465 total)
Lynn Pettis (7/19/2012)
You could also use dynamic sql to build the query that needs to be executed based on the parameters passed to the stored procedure.
Yes, I've done that in...
July 19, 2012 at 9:52 am
jane.alford (7/16/2012)
What do you see when you print sSQL right after this statement?
sSQL = "SELECT * FROM parameters WHERE printer_type & " & pType & " = " & pType...
July 18, 2012 at 6:01 am
No arguments from me on this one. I remember in one of my first programming courses, assembly language on a Univac 9300, one of the things the prof stressed was...
July 15, 2012 at 6:28 am
djackson 22568 (6/28/2012)
June 28, 2012 at 9:40 am
I use a system of passwords, generated according to a fixed set of rules, that are easy to remember but impossible to guess. It's easy enough to think up such...
June 28, 2012 at 9:28 am
I'm NOT relying on RAID to replace backups. I do backup regularly, just manually and not every day - sometimes days go by with no new data. I'd like to...
June 26, 2012 at 3:48 pm
I did lose a disk about two months ago, in the RAID 5 set. The server wouldn't let me connect remotely, but otherwise kept running. I and several others from...
June 25, 2012 at 5:09 pm
TheSQLGuru (6/25/2012)
With a 100MB database and a few users - who cares?
Well, I do, and such a low workload also makes it a good time to experiment, and learn how...
June 25, 2012 at 10:24 am
TheSQLGuru (6/25/2012)
Personally with that config I would go with 2-disk RAID1 for C drive and 4-disk RAID10 for D drive. You will need to use the C drive for...
June 25, 2012 at 8:31 am
GilaMonster (6/8/2012)
I'm not irked.
Oh, good - sometimes it's hard to tell via only text.
Play around with that setup (as simple as possible) and see if you can get your head...
June 10, 2012 at 10:32 am
GilaMonster (6/8/2012)
Sorry, but what did you want me to say? That one is faster than the other? That one is better than the other?
No apologies necessary. As I wrote, I...
June 8, 2012 at 5:25 am
GilaMonster (6/8/2012)
June 8, 2012 at 4:49 am
GilaMonster (6/5/2012)
Hi Gail, sorry for the delay in responding, I had some fires to put out, and I wanted think about what I needed, and construct an example to help...
June 8, 2012 at 3:23 am
GilaMonster (6/5/2012)
It has nothing whatsoever to do with performance. The meaning of the two queries is different. That's why you're getting different execution plans.
But Gail, they both produce EXACTLY the...
June 5, 2012 at 4:53 am
pdanes (6/4/2012)
June 5, 2012 at 3:41 am
Viewing 15 posts - 406 through 420 (of 465 total)