Viewing 15 posts - 871 through 885 (of 2,462 total)
It means "number of compiles where the index was found missing" see here http://www.freepatentsonline.com/y2007/0130107.html
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 25, 2012 at 4:32 am
patelmohamad (10/17/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 25, 2012 at 4:15 am
kk.86manu (10/25/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 25, 2012 at 4:11 am
can you post the complete changed database mail SP call you are using.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 25, 2012 at 3:49 am
Al-Rahim (10/24/2012)
However, the ldf file remains much bigger than i should like
It wil grow as it is nature of LOG file. the operation will get performed more...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 25, 2012 at 3:44 am
jlefebvre-924740 (10/25/2012)
this SP timeout in my application but not in SSMS
because we set the "commandtimeout setting in application" which tends to do the time out of any SP when SP...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 25, 2012 at 3:29 am
another solution though they are not approprate , See the link http://www.mssqltips.com/sqlservertip/2711/different-ways-to-make-a-table-read-only-in-a-sql-server-database/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 25, 2012 at 3:27 am
yeshupandit_2002 (10/25/2012)
I havnt got your question fully but i assume that you want to find tables that "can have relation
base on the column name"
Like Parent table having USERID as...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 25, 2012 at 1:41 am
Balance (10/22/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2012 at 5:54 am
your requirement is basically De-normalization approach. First remove duplicate coluimn some time you need to merge the coluimn (concatenation of data like name = first name + last name )
for...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2012 at 5:50 am
also it might be because of short of resoures .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2012 at 5:44 am
try this
open the SQL job that runs the package, went to the job step that runs the package, went to Advanced and set "Retry attempts" to 4 ( could...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2012 at 5:43 am
raghuveer126 (10/22/2012)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2012 at 4:35 am
EamonSQL (10/19/2012)
Create a trigger that seeks out any child records and deletes them if found.Eamon:-)
i didnt see any comment from OP that he wants to delete data with every...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2012 at 4:31 am
SELECT DISTINCT o.name, o.type_desc FROM sys.sql_modules m JOIN sys.objects o ON m.object_id = o.object_id WHERE m.definition LIKE '%view_cu_Account_Bills_b%'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2012 at 4:25 am
Viewing 15 posts - 871 through 885 (of 2,462 total)