Grant Fritchey (2/23/2009)

---

Yes. Everything I've read by Gaiman, and I started reading...

GilaMonster (2/23/2009)

---

mazzz (2/23/2009)

---

As far as I understand it from answers I got to a similar post I made myself the other day, you can't defragment unless you have a clustered...

anyone else a fan of Terry Pratchett and Neil Gaiman's joint effort, Good Omens?

Great for some light relief

Here's another post that might be of interest

http://www.sqlservercentral.com/Forums/Topic660743-361-1.aspx

http://www.sqlservercentral.com/Forums/Topic652865-146-1.aspx#bm653613

See thread above. you;d have to create a clustered index, then do the rebuild/reorganise, and then drop the clustered index

It might be worth considering adding a clustered index...

As far as I understand it from answers I got to a similar post I made myself the other day, you can't defragment unless you have a clustered index on...

How many times can The Thread post within itself before it hits recursion limit problems, is what I'd like to know.

Hi, the code below should give you some ideas at least:

declare @dint int set @dint = 2009044

declare @secs int set @secs = 55228

declare @datenotime datetime

declare @datewithtime datetime

declare @days int set...

Apologies for the delayed response, I've had a long weekend due to having amassed a day's worth of hours in-lieu 🙂

Rudy,

Thanks for the suggestion, but I'd really rather not change...

I got my last post completely wrong, but anyway - the below should give dd-mm-yyyy:

declare @d datetime set @d = '2008-09-15'

select @d

select convert(varchar(20), @D, 105)

you need to use a "style" in your CONVERT statement

From BOL:

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

and there's a table with all...

Thanks for your input Chris.

We were originally planning on setting up Sql Server configuration, rather than XML files (correct me if I'm wrong please, but as far as I can...

I have indeed, unfortunately there is not only not enough time to implement this(*), but also our test server is effectively our live server (I know, I know), so that...

Thanks Greg

I was afraid of that when I saw that column earlier.

there doesn't seem to be any way to query the MSDB-stored packages for any package level information at all,...

I wasn't disagreeing with you, I was curious 🙂