In this case it might be easier to ahve two tablix controls one fetching the job info and the other fetching the event info grouped by Job it.

If you want...

Any reason why u cant write asingle query to return the combined result set ?

GSquared (7/26/2012)

Computed column won't work for a value that's based on GetDate(). Value of the column would change...

Like mentioned above checkdb is a good thing to run ,infact its a good idea to run check db at least one 1 week.

any reason why you do not want...

u cud try a computed column with a function call also.

43gb for model db .... use the aler database statement instead of the ui

+1 backup restore , however have a look at the below link as well

http://www.sqldbops.com/2010/05/token-based-server-access-validation.html

I wud suggest adding a new column and moving the data in batches then. Once done u can simply rename the old column or drop it.

the table will be locked while the conversion occurs. How big the the table ?

declare @datetime datetime = '2011-7-13 2:39:39 PM'

if convert(varchar,@datetime,120) = convert(varchar, '2011-7-13 14:39:39', 120)

print 1

else print 2

declare @datetime2 datetime = '2011-7-13 14:39:39'

if @datetime2 = convert(varchar, '2011-7-13 14:39:39', 120)

print...

try the rownumber function with partition by

There is a CPU overhead with compression, since your inserting thousands of rows , make sure you take this into account. other than this there is nothin special needed to...

I guess the recommendation would depend on the RIAD configuration and what other operation you intend to perform on it. The primary reason i say this is becuase the more...

Look up the following topics in more details , PAE , 3 GB Switch and most important AWE in books online

The real question here is are you have of...

Great artcile on the real meaning on BCHR ...totally underestimated the role of read ahead optmization.

Well i guess in this case it wont matter coz the entire Db can be...