same here...:-)

Oleg Netchaev (3/16/2010)

---

sjimmo (3/16/2010)

---

Hugo, after getting the questin wrong;-) and re-reading a few times in disbelief I found on <http://msdn.microsoft.com/en-us/library/ms175477.aspx&gt; - Each data backup includes part of the...

probably some kind of rollback should have been in place.. 🙂

sorry for sounding stupid, but has anybody implemented sparse in his/her code ?

what was the reasoning behind.. is it really worth ?

thanks..:-)

if the query contains a top 3

SELECT top 3 c.*, Users.* FROM reptec_changedim c, Users

then this will return 3 records...

i fail to understand what is the learning in this question. anybody plz. suggest...

thanks for the question.... was really not aware of datalength function..

thanks for the question :). learned something new today

UTC is the best option, we have people accessing our application from all time-zones. all updates are done in utc format.

the only thing people in different time zones need to...

apologies... i should have included table structure and some sample data...

declare @wareshousetable table

(

col1 [varchar](64) NULL,

datesection [char](16) NULL,

totalvalue [numeric](10, 0) NULL,

usedvalue [numeric](10, 0) NULL,

smalldatesection char(7) NULL

)

insert into @wareshousetable (col1,datesection,totalvalue,usedvalue)

select 'server1','220003722000',100,25...

conversion to...

thanks...

i just checked it out.. without indexes, update query takes 30 sec.

with the indexes in places, it takes 2 min !

RBarryYoung (2/17/2010)

---

I think that it depends on a number of...

thanks for the question.. good one! 🙂

thanks, a very good question ! got to learn something new today.:-)