Viewing 15 posts - 4,951 through 4,965 (of 6,216 total)
Hey Robert,
Good to see another article from you! Thanks for submitting. As far as dynamic sql, I've never worried about the performance (solve the problem, then seek performance if its...
February 11, 2002 at 5:43 am
I disagree a little about the automation vs the human - just because I can do something manually doesn't mean I should! DTS is a great example of wrapping a...
February 11, 2002 at 5:37 am
Simon,
Even if you could stream the data directly to a file not sure you'd want to - strive to make your triggers as quick and as light as possible. You...
February 11, 2002 at 5:33 am
No, just whatever is compatible with your server.
Andy
February 11, 2002 at 4:34 am
I agree that MS doesn't do a very good job documenting the page size. While it's interesting to poke around the internals, would be a lot easier if they either...
February 10, 2002 at 5:55 pm
Not sure its a total waste of time. Every bit you can do to obfuscate is probably going to help if its that critical. Or you think it is! If...
February 9, 2002 at 2:22 pm
I've tried Visio a few times, have not tried Erwin. EM is slightly frustrating as far as the diagramming at times - would be nice to have a diagram that...
February 8, 2002 at 6:16 pm
One thing I always add as a habit is "set nocount on" as the first executable line in the trigger. I'd also suggest a naming convention just to make your...
February 8, 2002 at 6:12 pm
"Point you in the right direction we will." Bravo! Best posting I've read today!
Definitely use ON for your joins rather than the where - everyone else who reads your work...
February 8, 2002 at 6:06 pm
If its a development box the drive system may not be great. Take a look with perfmon to see what disk and cpu usage look like - if both are...
February 8, 2002 at 6:03 pm
Interesting. My solution is always to add memory! The less you hit the disk for anything the better. Other than the cpu queue, are you noticing any problems, performance issues,...
February 8, 2002 at 6:00 pm
I think the problem is with the datatype= part. Normally this is just the one word data type descripion (char, varchar, etc). For some reason DMO does not give you...
February 8, 2002 at 5:47 pm
Flatfiles! Holy database Batman!
Im not a big fan of flat files. I'd rather use a recordset or XML - each gives me powerful tools to work with the data easily...
February 8, 2002 at 5:04 pm
Steve, you sure about the licensing?
Andy
February 8, 2002 at 10:55 am
Viewing 15 posts - 4,951 through 4,965 (of 6,216 total)