Hi Chris, > I would normally produce a dynamic where clause something like this:- > select title from videos where title like '%Frank Spencer%' and title like > '%BBC%' and title not like '%BBC%' > but I believe that would be open to a sql attack and I should be using parameters. In your c...more >>

Thanks for adding that info. "Erland Sommarskog" <esquel@sommarskog.se> wrote in message news:Xns99D2F206743A5Yazorman@127.0.0.1... > Greg D. Moore (Strider) (mooregr_deleteth1s@greenms.com) writes: >> No, and there never has been. That's a misunderstanding of the old >> query governer bu...more >>

Thanks for the info. That's good to know. "Greg D. Moore (Strider)" <mooregr_deleteth1s@greenms.com> wrote in message news:13hrn2sbia0lt74@corp.supernews.com... > "Neil" <nospam@nospam.net> wrote in message > news:G0hTi.54$nN3.12@newssvr17.news.prodigy.net... >>>>> (BTW, you may want to loo...more >>

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message news:Xns99D2F206743A5Yazorman@127.0.0.1... > Greg D. Moore (Strider) (mooregr_deleteth1s@greenms.com) writes: >> No, and there never has been. That's a misunderstanding of the old >> query governer built into MSDE (whcih permitted...more >>

Greg D. Moore (Strider) (mooregr_deleteth1s@greenms.com) writes: > No, and there never has been. That's a misunderstanding of the old > query governer built into MSDE (whcih permitted only 5 or 6 (I've seen > both numbers)) of queries to run at the same time before things were > slowed down on ...more >>

>>> (BTW, you may want to look into upgrading the DB to use something like >>> SQL Express edition. More modern, better supported and may be a bit >>> faster, especially on a Windows 2003 box.) >> >> SQL Express? I thought SQL Express was the new version of SQL >> Desktop/MSDE. Maybe I'm wr...more >>

"Neil" <nospam@nospam.net> wrote in message news:G0hTi.54$nN3.12@newssvr17.news.prodigy.net... >>>> (BTW, you may want to look into upgrading the DB to use something like >>>> SQL Express edition. More modern, better supported and may be a bit >>>> faster, especially on a Windows 2003 box.) ...more >>

"Neil" <nospam@nospam.net> wrote in message news:bTXSi.7102$Pv2.3736@newssvr23.news.prodigy.net... > >>> Since there's a big jump in the size, I was wondering if there's >>> anything >>> I need to do maintenance-wise to help the database use the new data. >> >> That's still very small as fa...more >>

>> Since there's a big jump in the size, I was wondering if there's anything >> I need to do maintenance-wise to help the database use the new data. > > That's still very small as far as SQL databases go. Right. I just meant that it was almost double the original size. Wasn't sure if there...more >>

I just made a major addition to the data in our database (SQL 7 with an Access 2000 front end). The users had been working with a set of 66,000 Word documents, having to open each to view when needed. I converted these docs to RTF format, and brought the RTF codes into the database itself. Eac...more >>

"Neil" <nospam@nospam.net> wrote in message news:z_SSi.59295$Um6.46164@newssvr12.news.prodigy.net... >I just made a major addition to the data in our database (SQL 7 with an >Access 2000 front end). The users had been working with a set of 66,000 >Word documents, having to open each to view w...more >>

I have been using this computer program for a couple weeks now and i am very pleased with the results so far. its a software fatloss program, if your looking for a diet/weightloss plan i reccomend you check this place out first: http://fatloss9.50webs.com ...more >>

Hi, I have an unused HP Pavilion with the fallowing specs: # Processor: AMD Athlon 64 X2 4000+ (2.1GHz, 2000MT/s System Bus) # Memory: 2048MB PC2-5300 DDR2 SDRAM memory (2x1GB) (expandable to 8 GB (4 x 2 GB) (64-bit OS)/ 4 GB (4 x 1 GB) (32-bit OS)) # Hard Drive:320GB 7200RPM SATA 3G (3.0 Gb/s...more >>

Watch NFL Games Online! For every one who wants to watch the games online because they dont live in the teams town or are at work i found a site that has basically every game covered. Its perfect if you have afford a monthly $70 direct tv nfl access subscription. they got a bunch of channels The s...more >>

Any good recommendations out there for books dealing with database design? We use MS SQL Server, but a generic db book will work as well. I'm mainly looking to leverage SQL for some internal reporting capabilites for another product, so I'm looking for some pointers on how to construct databa...more >>

Does SQL 2005 Serivice Patch 2 include Report Services Service Patch 2 or do I need to install them separately? I have both the database engine and report services running in a 2- node clustered environment. Thanks. ...more >>

Hi, I am trying to create a database procedure that will produce a list of results based on a Google like search. e.g. "Frank Spencer" -car +BBC I would normally produce a dynamic where clause something like this:- select title from videos where title like '%Frank Spencer%' and title lik...more >>

Hugo Kornelis (hugo@perFact.REMOVETHIS.info.INVALID) writes: > For SELECT *, the first step in parsing is to find out which columns are > in the table. That requires a read on the syscolumns system table in SQL > Server 2000, or it's undocumented equivalent in SQL Server 2005. That in > itself m...more >>

On Mon, 17 Sep 2007 21:25:30 +0100, Danny Burton wrote: >When returning all columns from a table is there any performance gain (or >any other reason) for using SELECT col1, col2 etc... instead of just SELECT >* ? Hi Clive, I have to contradict Erland here - there will be a small perform...more >>

> I know that in order to reduce network traffic you should always select only > the columns you require but I have a stored procedure which must **always** > return all columns from a specific table. Reducing traffic really isn't the main reason. > When returning all columns from a table ...more >>

"Danny Burton" <no@email> wrote in message news:Uv-dnaiBfeHjf3PbRVnyugA@giganews.com... >I know that in order to reduce network traffic you should always select >only the columns you require but I have a stored procedure which must >**always** return all columns from a specific table. > > W...more >>

I know that in order to reduce network traffic you should always select only the columns you require but I have a stored procedure which must **always** return all columns from a specific table. When returning all columns from a table is there any performance gain (or any other reason) for ...more >>

Danny Burton (no@email) writes: > I know that in order to reduce network traffic you should always select > only the columns you require but I have a stored procedure which must > **always** return all columns from a specific table. Unless this is a temp table created within the procedure, I ...more >>

In article <Uv-dnaiBfeHjf3PbRVnyugA@giganews.com>, no@email says... > I know that in order to reduce network traffic you should always select only > the columns you require but I have a stored procedure which must **always** > return all columns from a specific table. > > When returning all ...more >>

On Sep 4, 10:50 pm, "Andi" <NOmgem35S...@dslDOT.pipex.net> wrote: > Hi, > > Wondering if anyone can help. We have a knowledge base system which uses an > MSSQL server to store information. The tool is web-based, and we have need > to run reports on the information in the database, such as num...more >>

Thank you! Walter "Ed Murphy" <emurphy42@socal.rr.com> wrote in message news:46daf1aa$0$6385$4c368faf@roadrunner.com... > Walter Cohen wrote: > >> I have rows in a database that are grouped by a key value. They all have >> the same key value but some other columns on each row are not val...more >>

Hi, Wondering if anyone can help. We have a knowledge base system which uses an MSSQL server to store information. The tool is web-based, and we have need to run reports on the information in the database, such as number and age of articles, for example. As the tool is used quite heavi...more >>

Walter Cohen wrote: > I have rows in a database that are grouped by a key value. They all > have the same key value but some other columns on each row are not > valued the same. How can I construct a query that will just return one > row of the set with the highest value for one of the co...more >>

Hello. I have rows in a database that are grouped by a key value. They all have the same key value but some other columns on each row are not valued the same. How can I construct a query that will just return one row of the set with the highest value for one of the columns? Here are some...more >>

Milagro wrote: > Thanks, that worked very well. Now I see another issue. One of my text > fields has data in it that must have a character(s) that is the same as > the record separator character (LF/CR ??). This is data users entered in > on the web so they could have put anything in here (...more >>