Hi

The total space of

CREATE INDEX IX_1

ON 123 (A)

INCLUDE (B,C,D)

and

CREATE INDEX IX_2

ON 123 (A)

INCLUDE (E,F,G,H)

will take more space than

CREATE INDEX IX_1

ON 123 (A)

INCLUDE (B,C,D,E,F,G,H)

The selectivity of each index is same. You...

Seems the err msg is simple.

Conversion failed because the data value overflowed the specified type

Is the source column the same type as the destination column?

The change of a unique to non-unique index means changing the business logic, so make a double check if you're going with this.

The active directory group(s) to which a sql server login belongs to in the OS, is maybe (obviously from your query) not added in sql server, so how could you...

What if the login belongs to multiple windows groups?

I think this is yours sys-admin question.

Regards,

Igor

What about if you can put a subset-rows from PART_LIST into a temp table and make a LEFT OUTER JOIN with it. You can put a necessary index on the...

Search for "could not load file or assembly microsoft sqlserver sqm version" and you'll find some useful links like this one hopefully:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/71e480ca-827c-4c44-898d-f9e5de1725e1/struggling-to-get-ssms-running?forum=sqltools

george sibbald (2/23/2014)

---

TomThomson (2/21/2014)

---

The read_only property of the model database has no effect on newly created databases, however created. Whatever the model value is, the value for database created...

Didn't know that, :^)

Thanks, interesting question anyway.

Hm, interesting.

Did you fulfill the full-text index?

The columns should have the same "Language for Word Breaker".

Hi,

Try this

select t1.Transport,t2.[Order],t2.Size,t1.Service,

(select tx.Weight from Table1 tx where tx.type = 'Car') as Car,

(select tx.Weight from Table1 tx where tx.type = 'Bus') as Bus,

(select tx.Weight from Table1 tx where tx.type =...

Hi,

This is one simple solution (didn't count on the performance):

create table CustInfo

(UniqId int identity(1,1),

UniqClient int,

PhoneNumber varchar(20),

EmailWeb varchar(50)

)

insert into CustInfo (UniqClient,PhoneNumber,EmailWeb)

values(66,'4164445555',''),(66,'','fstest1@test.com')

select top(1) t.UniqClient,

(select...

The question is trivial.

To ensure myself, I read this reference http://technet.microsoft.com/en-us/library/ms186388.aspx and I didn't see any correlation of the model's read_only property to the same for the restoring database. I...

Interesting question!

Only the SQL Server reserved keywords cannot be used directly as a database name, anything else can - http://technet.microsoft.com/en-us/library/ms189822.aspx

You can use [] :-), anyway.

Thanks

What about trying by using a ";" as the statement terminator?