Good question. Is this related to the behaviour of datetimes versus datetime2s with the british language setting?

SET LANGUAGE BRITISH

GO

DECLARE @datevar datetime2 = '2008-12-13'; -- no error, ymd format

SELECT @datevar;

GO

DECLARE @datevar...

Good question - made me think for a bit (I never use SELECT * in views, of course 😉 )

Duncan Pryde (6/28/2012)

---

I got led astray by the error message. Since it said there was no current database backup, I thought that meant you couldn't do a differential backup at...

I got led astray by the error message. Since it said there was no current database backup, I thought that meant you couldn't do a differential backup at all (since...

codebyo (6/27/2012)

---

Duncan Pryde (6/27/2012)

---

You can't define indexes explicitly (i.e. by CREATE INDEX) in a CREATE TABLE statement. As far as I know the only way to create indexes in CREATE...

Mike Hays (6/27/2012)

---

Hey Hugo, would you explain to me why "None, unless the rest of the statement specifies one" is wrong? Are you saying that the statement can not...

vk-kirov (6/26/2012)

---

I can create an index by means of a unique constraint:

CREATE TABLE dbo.QotD

(KeyColumn int NOT NULL PRIMARY KEY,

RefColumn int NOT NULL,

-- ...

ALZDBA (6/26/2012)

---

why isn't there just a simple index on both date columns in the order you need them ?

create index X_yourtable_dates on yourschema.yourtable (date1, date2);

might be another solution to...

I must confess I hadn't had a chance yet! Thanks for the feedback: the difference is, as you say,...

Thanks both. I didn't think there would be any way to improve it much with an index alone, but it's good to get confirmation I'm not missing anything obvious. I...

I got it wrong as well, because I suppose I was thinking about "defining" in terms of a separate single statement (e.g. CREATE INDEX) giving something an actual name. However,...

Sean Lange (6/20/2012)

---

ananda.murugesan (6/20/2012)

---

as of now all the database sql 2008 collation is SQL_Latin1_General_CP1_CI_AS but still database user password working as case senstive only.. how to reslove user password case...

ananda.murugesan (6/20/2012)

---

I have done side by side migration activity not in same server, By using restored all existing database from SQL 2000 to SQL 2008 new setup. In this case...

Collation can also be set at the column level, if that's any help.

However, I'm slightly confused as to how the collation of an existing column could have changed during migration....

Taking a risk for a big payoff is one thing, but many people (without any other kind of safety net - e.g. a wealthy family) will not want to experience...