I dont think you will get much help here unless you provide defintion of view along with index/table defintion.

please post them.

and by the way how did you find the...

cavaliersa (10/23/2013)

---

I realise this thread is old but it is still worth answering.

The below query will give you the space of offline databases.

SELECT

DB_NAME(db.database_id) as [DB Name],

CONVERT(DECIMAL(6,3),SUM((CONVERT(DECIMAL(20,5),mf.size)*8)/1048576)) as [DB Size in...

Definitely you wil get help here some stuf is still missing , you havent mentieond that on what basis you will do the update .

and how would you select that...

vahid.arr (10/23/2013)

---

i have a table Line and this two table(Ramp and PreRamp) have relationship(one to many) to line table(there is no relation ship between ramp and PreRamp. how can i...

i also started at accidentally Sql development.

In my first company when i was on .Net developement side.

but how i started that is funny. there was one of my friend...

Do have RAID setup ? if nto then think about that too .

See http://technet.microsoft.com/en-us/library/ms186406(v=sql.105).aspx

so my guess is .. there might be some uni code sitting (international languages..)

oops... i havent found any diference except alias used in first query ? :w00t: , did i overlook something ?

do that files contain INSERT statements ? with N' characters

tricky for im-patient like me but easy for patient people. 😀

Just an addition to joeroshan suggestion , ALTER DATABASE ... MODIFY FILE will be required before sql restart.

see http://technet.microsoft.com/en-us/magazine/gg452698.aspx

In back 2011, in my last company when we upgraded the sql 2005 sp3 (cu4) to sql 2008 r2 , we found one issue like pivoting of query was not...

First see the error log if some is there like error mentioend in link i pasted above

another run this too

select physical_memory_in_use_kb/(1024) as sql_physmem_inuse_mb,locked_page_allocations_kb/(1024) as awe_memory_mb,total_virtual_address_space_kb/(1024) as...

Any specific reason to point your app to mirrored DB ?