Viewing 15 posts - 1,126 through 1,140 (of 2,462 total)
it might be because of schema/definition discrepancy.i ran you script on my system it doesn't show any issue/error related to sql 2008
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 30, 2010 at 2:10 am
Did you that exe restart it again ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2010 at 6:20 am
this link can help you to apply any sql script on multiple DBs one time
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2010 at 6:13 am
Bill "Bojangles" Robinson (12/17/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 20, 2010 at 6:09 am
duplicate post reply here http://www.sqlservercentral.com/Forums/Topic1036335-391-1.aspx?Update=1
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 16, 2010 at 11:20 pm
gupta.sreekanth (12/16/2010)
can any one tell how to transfer data from a table in one database to another table in another database.....if any one knows....please write sample query for...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 16, 2010 at 11:19 pm
removed
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 16, 2010 at 11:16 pm
Are you observing any memory pressure ?
because Clearing the plan cache causes a recompilation of all subsequent execution plans and can cause a sudden, temporary decrease in query performance.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 14, 2010 at 10:42 pm
Thanks i got the point
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 14, 2010 at 9:26 pm
Don't trust DBAs trust "F5"
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 14, 2010 at 12:33 am
dilipd006 (12/13/2010)
thanks for the reply..the connection string is same
It means that application is able to connect with sql server but it throws error inside it so i think debugging application...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 14, 2010 at 12:18 am
On safer side i would say create some relevant indexes otherwise you can De-normalize some tables and then put some indexes.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 14, 2010 at 12:11 am
instead you should keep '1900-01-01' for '000000'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 14, 2010 at 12:07 am
though your requirement is not so clear but still i tried
declare @t table (
item_id int,
dates datetime,
qty int ,
Amount int ,
Status char(1)
)
insert into @t (item_id,dates,qty,Amount,Status)
select 1, '10/10/2010', 10, 250,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 13, 2010 at 11:56 pm
wannalearn (12/13/2010)
Thank you. I was trying to delete parent first. It works now.
May be syntactically it works but from business perspective child table should contains any records associated or...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
December 13, 2010 at 11:41 pm
Viewing 15 posts - 1,126 through 1,140 (of 2,462 total)