waleed_m_M (7/4/2009)

---

select * from (SELECT column_name,column_default

FROM INFORMATION_SCHEMA.COLUMNS

...

If you're seeing a max size for the log of 2 TB, that's the maximum possible size for a log file within SQL. So restricted to 2TB is the same...

That is going to update every single row in the sqldate_tbl table. Is that your intention?

The only reason that could be not updating any rows is if there are no...

RBarryYoung (7/3/2009)

---

I remember back in Q1 I had several weeks where I was really racking up the posts. But I eventually started to notice that it was having...

Looks fine.

I don't know why you're calling me 'master' though. Honestly, I'd prefer if you didn't use that, my name is at the bottom ad...

Don't worry. I've spelt Florian's name wrong in a published article and Grant's surname wrong in a post on the MVP newsgroups :blush:

You still need to do an update stats. Rebuilding the indexes will update stats on those indexes. It won't update column statistics that aren't associated with an index though. Like...

You laugh. I was speaking with someone recently and he said that he and his team do some SQL development, but nothing complex, no joins or anything.

I was hoping that Paul would comment on this, but he's on vacation for a month.

If the dropping of the stats doesn't work (and apparently it doesn't, seeing as you...

Just got some clarification on this.

SQL Enterprise can be installed on Vista. It is not, however, a supported configuration. This means that should you call customer support with a problem...

vitesh.bhana (7/3/2009)

---

The only thing I know about Independence Day is this huge alien ship hanging over the White House and blowing everything up 😀

If only they had added some sharks...

Correct

But , for instance i...

latingntlman (7/3/2009)

---

Thanks guys,

Bruce, your suggestions "convert(varchar" won't work because it's a text field, so the field needs to be parsed to remove the spaces and time after the date. Then...

This should give you the idea

DECLARE @DateInString varchar(20)

SET @DateInString = '7/2/2009 4:18:25 PM'

SELECT CAST(@DateInString AS DATETIME)

SELECT DATEADD(dd,datediff(dd,0,@DateInString),0)

As I said, if you check books online, you'll see that you can either update...