I know it's not what you're going to want to hear, but every environment, every workload is different. I'm afraid you're going to need to make the change (preferably...

OK, so HAVING isn't going to work. But never mind. What you're looking for is something like this:

BETWEEN...

Changing the fill factor in the way you suggest is likely to have a positive effect on write performance (because there will be fewer page splits) but a negative effect...

The parentheses still don't match.

TRUNCATE isn't an aggregate function in T-SQL, as far as I know. What does it do in MySQL? If you could supply some table...

I don't think that will even parse, since (a) you've used HAVING instead of WHERE and (b) your parentheses don't match. Also, why do you declare @trig and not...

OK, you seem to have changed your collation, so here's what to do in general:

(1) Go on to Wikipedia and search for "code page xxxx" where xxxx is the three...

You haven't shown what the data in your table looks like, but I think I can picture it.

It looks as if you have three options:

(1) Pivot in Excel then load...

If removing the space before the Z doesn't do it, please post table DDL in the form of CREATE TABLE statements, sample data in the form of INSERT statements, and...

If you want to fragment your indexes, you'll need to make lots of modifications - inserts, updates and deletes. Try to choose operations that change data in index key...

If you've got an environment variable package configuration, I think you need to restart SQL Server after you add or change it.

John

This indeed returns 0:

SELECT CAST('' AS int)

It's just the way it works. I suppose when the DBMS or the standards were being written, somebody decided that '' would convert...

Neil

Yes, you can add those components. Start by running setup.exe and click on Installation, then New SQL Server stand-alone installation or add features to an existing installation.

John

I think this is because you're putting a space before your "Z". And the outer REPLACE doesn't do anything - it just replaces a space with a space.

John

That'll be because "A" comes after "-" in SQL_Latin1_General_Cp1251_CS_AS and all the other collations you've tried. Here's a few options I can think of:

(1) Find a collation that has...

Yes, it's useful for querying any information stored as a bitmask, such as affinity masks or the freq_interval column in...