why you have

where Contains(Name, '"Jo*"')

shouldn't it be

where Contains(Name, 'Jo')

peter 67432 (2/9/2016)

---

Igor Micev (2/9/2016)

---

1) Check that the service "SQL Full-text Filter Deamon Launcher (SQL20XX)" is running. If not it must be running in order to use catalogues.

2)

Run this...

Indianrock (2/9/2016)

---

At this point I think Igor and Sergiy are tired and quoting me sometimes when they think they're quoting eachother. 🙂

RedGate's smart rename function came up with this...

1) Check that the service "SQL Full-text Filter Deamon Launcher (SQL20XX)" is running. If not it must be running in order to use catalogues.

2)

Run this to see if you...

Did you get the following error message for the second query

Msg 7601, Level 16, State 2, Line 5

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'schema.table'...

gbritton1 (2/9/2016)

---

FWIW:

DECLARE @i VARBINARY = 0x0005432345544

select LEFT(@i, 3), LEFT(CONVERT(VARCHAR(64),@i),3), LEFT(CONVERT(VARCHAR(64),@i,1),3), LEFT(CONVERT(VARCHAR(64),@i,2),3)

produced:

(No column name) (No column name) (No column name) (No column name)

...

Sergiy (2/8/2016)

---

Igor Micev (2/5/2016)

---

This is not a good thinking. What if you have many schema bound objects with that table?

The advise from ScottPletcher is just fine. Changing from smallint to...

Batch is old 4+ years. Nobody have responded. I came to the same problem, not enough clear to me.

Sergiy (2/3/2016)

---

I don't think you can change a data type on a column.

It may look like changing a data type from you visual tool (SSMS, I guess), but what is...

It can be. You should investigate. This post of Paul will help you - http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

Tha CASE is actually IF structure. It's up to you what is more easy for you to use.

It's by default set to OFF.

Must be ON when is usually used for assemblies in SQL Server (.dlls). Of course it's has other security aspects, but I suggest to check...

Use the following query to get the information:

select db_name() [database_name],fg.name [FG_name], sf.name [logical_name],sf.[filename] [physical_name]

,convert(decimal(18,2),round(fileproperty(sf.name,'SpaceUsed')/128.000,2)) [space_used_MB]

,convert(decimal(18,2),round((sf.size-fileproperty(sf.name,'SpaceUsed'))/128.000,2)) [free_space_MB]

from sys.sysfiles sf

left join sys.filegroups fg on sf.groupid = fg.data_space_id

Yes, space releases.

Hugo Kornelis (1/28/2016)

---

Good! Now test it with a much larger and more varied selection of...

http://db-engines.com/en/ranking