drum and bass analysis..

setup a site analysing all the latest drum and bass tracks?

if you are on Windows 7, then right click on the file and choose

open with --> choose default program and select visual studio (BIDS)

threre is also...

Ninja's_RGR'us (6/29/2011)

---

... or upgrade sql express to sql express R2. Restore should work assuming the total datafile(s) size is under 10 GB (doesn't matter if the space is used...

how would that help?

its difficult to write you an expression without knowing the column details.

but in general it would be a derrived column called measure and then i would simply add either...

It is really a two step proces,

step one would be to create the objects in the new database. I would do this by scripting out each object...

did you read what i wrote about them being two different versions and that the script may or may not work depending on what features of enterprise you have...

well you could use SSMS to generate the T-SQL scripts from your enterprise server and run these against the express server, also in 2008 you get the option of scripting...

you can't sorry,

one option would be use ssis to copy the data across.

you could do this by first using a multi-cast to split and duplicate the rows, then use a derived column transformation to populate a 'measure' colum with the correct...

Sean Lange (6/28/2011)

---

That and the total lack of proof. The author just says do this instead of that because it is faster but presents no facts to back up the...

you really shouldn't be shrinking your database on a regular basis, this is bad advice from your vendor and may cause the perfromance issue.

also i would do the integrity check...

do you have a date dimension?

Thomas Abraham (6/28/2011)

---

I thought of that. But, the name will appeal only to a select group of individuals/companies, given it's obvious database connection. That's why...

Jayanth_Kurup (6/28/2011)

---

I found the below article on the usage of greater than vs greater than or equal to

http://www.lcard.ru/~nail/sybase/perf/18295.htm

The logic seems sound but i doubt if i will consider it...