sandy-833685 (9/27/2010)

---

Hi i am having table with column name time data type as datetime

And when i try to execute the select statement with convert like

select * from tablename

where convert(varchar(10),time,103)<'06/06/2010'

as i...

I'm glad it has been solved using the page method.

I've been confronted a couple of times with this issue and I've been able to filter the troublesome rows using this...

it's a petty for us all, but "disable trigger" is not a ddl statement !

So you cannot capture it with a ddl trigger.

We have the same issue as you have,...

Grant Fritchey (9/27/2010)

---

I just got bad news. I've seen the schedule for the PASS Summit. I'll be speaking to an empty room because I'm presenting the same time as Jeff....

Don't drop your clustering index !!

(because it actually contains the data pages, so a drop will cause all your data to be moved to a heap and all non-clustering...

And it even works! :w00t:

James Tech (9/26/2010)

---

ALZDBA (9/26/2010)

---

the cross join is one thing

the function on the datetime column is another one. This causes no datetime index to be used !!

This conversion is also member...

the cross join is one thing

the function on the datetime column is another one. This causes no datetime index to be used !!

This conversion is also member of the group...

Also check your cluster log !!

It may also help with the facts analysis.

A long startup time for your sqlinstance may be cause by an excessive amount of virtual log files...

The index will have to be dropped and recreated because of the change of datatype.

Rule number 1: tell the system what you know.

So don't use a (var)char datatype if you...

There may be a difference between microsoft week and iso week !

try this:

declare @dates table ( dt datetime not null )

Declare @startdate datetime

set @startdate = '2010-01-01'

insert into @dates

...

george sibbald (9/24/2010)

---

Johan, you are right, as the app is designed to be used globally and is therefore attempting to store the date without including time zone offsets it should...

indeed, every object needs its own drop statement.

In SSMS however, you can select all these tables in the detail pane of the tables section and delete them all in a...

Oh, indeed quick copy / paste, you know ... forgot to translate the comments, but you got it anyway 😎

Off course, IMHO, it is better to avoid this kind...

Keep in mind these "switch" weekends are determined on a country bases.

As in many cases in Europe, every country can do it differently 😉

These are the dates I found in...