Look at the execution plans for contains (textField, '"Cat" or "Dog"') and textField like '%Cat%' or textField like '%Dog%'

One should contain an index seek and the latter an index scan....

Marshall, what's the size, free space and fragmentation levels on the D:\ drive?

DAB

Yes, it is better to grow in fixed increments rather than in percent. While this may be fine for a small db (think <10 GB), that is a 500 MB...

garethmann101 (11/18/2008)

---

I am trying to do a full text search on a text field. I have added the neccesary full text index on the field.

I am a little disapointed in...

This type of question is asked frequently and I always see similar responses. The problem is this solves a single instance. Therefore, the next time this occurs, the developer or...

You can use the MySQLDump utility with the compatilbility set to SQL Server. That will create a file with necessary DDL and insert statements that can be executed in SQL...

MySQL provides the MySQLDump command. It can be run from both Windows (assuming the MySQL client/engine is intalled on Windows) and in *nix OS's.

mysqldump --host={host name or IP} --user={user name}...

Declare @servername nvarchar(50)

Set @servername = 'somevalue'

SELECT * from OPENQUERY(@Servername,

...

My bad. I looked at that three times and did not see the INT. Never mind...

The problem is in the header ALTER PROCEDURE "dbo"."PROC_STUELI_NeuAendnr" (@id_stueli Int, @lastus int,@new_aendnr Int OUTPUT)

The @laststatus parameter does not have a data typpe...

DAB

I copied and pasted this into a deummy db and it all compiled fine. Are you using SQL 2005? I If not, you'll need to change varchar(max) to something like...

Dave, check out a cleaner, reusable version at http://www.sqlservercentral.com/Forums/Topic594387-145-1.aspx

DAB

This type of situation is encountered frequently (see Dave's post re: Converting Numeric to String http://www.sqlservercentral.com/Forums/Topic594180-8-1.aspx )

The approaches listed there and in the previous reply work, but for singular occurences...

miodrag.sabljic (10/29/2008)

---

When I do select statement over the table with a few columns and about 300000 rows of data, and statement like SELECT col_1 FROM T WHERE col_2= ...

Try using UPDATE ONE instead of AUTO_FIX