Viewing 15 posts - 34,621 through 34,635 (of 39,726 total)
I agree with lots of what Andy wrote, but I'll chime in as well.
SQLInjection will become one of our biggest worries going forward. With so many bugs and patches coming...
August 20, 2004 at 4:24 pm
Thanks for the link catch. It's fixed.
August 20, 2004 at 9:05 am
You can use either with the IIS server connecting to the SQL Server. Not sure about the actual end user, but I suppose if they connect to IIS using Windows...
August 19, 2004 at 8:18 am
do you mean dbcc indexdefrag? Access can grab a large number of locks and I suspect, block the index defrag from running. DBCC inputbuffer returns the last sql batch (or...
August 19, 2004 at 8:09 am
I always use aliases. You learn the pretty quick and as long as you are consistent, it's easy for your team to read. If the Products table is always...
August 17, 2004 at 3:07 pm
Finally one question that people like ![]()
August 17, 2004 at 3:06 pm
Haven't run through it all, but I wouldn't depend on the dbid. I'd use the names you want to exclude. I might also insert the results into some log...
August 17, 2004 at 3:04 pm
I'm always wary or writing directly to tape. It seems a much less stable mechanism for restores. I personally haven't used this product, but I have used Backup Exec and...
August 17, 2004 at 3:02 pm
Not really. Very minor memory usage, if they aren't queried, then no data cache will be eaten up. I wouldn't worry about them.
August 17, 2004 at 2:58 pm
This shows fragmentation, which can slow access to the table, but it doesn't appear to be too fragmented. It is, however, a large table, so most likely indexing better can...
August 17, 2004 at 2:48 pm
I'm not the replication expert, but I had a similar situation years ago in v6.5. I used a trigger to move the inserts and updates to a separate table. Then...
August 17, 2004 at 10:54 am
You might be able to, but it would be ugly and might cause performance issues. I'd create a couple views to filter things out.
like create view myfirst as select *...
August 17, 2004 at 10:52 am
Search in syscomments. A simple query
select * from syscomments where text like '%mystring%'
will get it for you. Surfinity also makes a great search engine for searching, but I'm not sure...
August 17, 2004 at 10:40 am
August 17, 2004 at 10:33 am
Viewing 15 posts - 34,621 through 34,635 (of 39,726 total)