Viewing 15 posts - 91 through 105 (of 2,462 total)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 24, 2013 at 2:31 am
cavaliersa (10/23/2013)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2013 at 8:25 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2013 at 8:24 am
vahid.arr (10/23/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2013 at 8:21 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2013 at 8:17 am
Do have RAID setup ? if nto then think about that too .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2013 at 7:28 am
mandavli (10/23/2013)
How do you create these triggers? and add alert to that trigger?
See http://technet.microsoft.com/en-us/library/ms186406(v=sql.105).aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2013 at 7:16 am
shashi_1409 (10/21/2013)
Bhuvnesh, It has inserts and update statements in it.Thanks
Shashi
so my guess is .. there might be some uni code sitting (international languages..)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 22, 2013 at 3:27 am
oops... i havent found any diference except alias used in first query ? :w00t: , did i overlook something ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 21, 2013 at 7:52 am
do that files contain INSERT statements ? with N' characters
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 21, 2013 at 6:18 am
tricky for im-patient like me but easy for patient people. 😀
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 21, 2013 at 5:07 am
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 19, 2013 at 4:04 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 19, 2013 at 3:53 am
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 18, 2013 at 8:08 am
Any specific reason to point your app to mirrored DB ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 17, 2013 at 8:56 am
Viewing 15 posts - 91 through 105 (of 2,462 total)