Viewing 15 posts - 241 through 255 (of 2,462 total)
Google https://www.google.co.in/?gws_rd=cr&ei=1C48UtDrAs7KrAfnyoDwAQ#q=database+migration+in+Sql+server
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2013 at 5:18 am
Sqlsavy (9/19/2013)
Drop and re-create clustered index takes 5 minutes in total. So my procedure is completing in just 10 minutes
Have you tried to do the INSERT with Clustered...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2013 at 5:14 am
Preethi S Raj (9/20/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2013 at 4:32 am
see this http://sqldbpool.com/2011/09/28/useful-queries-while-troubleshooting-database-mirroring/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2013 at 4:19 am
markoz.job (9/20/2013)
use masteralter database [xxx] set offline
Is it necessary to make it offline can we make it single user and then then do the rest of steps...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2013 at 4:16 am
chandan_jha18 (9/20/2013)
If somebody has worked in such an environment before, please give your suggestions and inputs on how to take this further.
YOu need to go with batch approach where...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2013 at 4:06 am
SrcName (9/20/2013)
Because truncate has not where clause and you need some data, then you can save them in another temp table, truncate base table...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 20, 2013 at 4:02 am
dougjjj (8/20/2013)
I managed to track down the issue
How did your figure it out ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 19, 2013 at 5:25 am
can you post complete Error with error state ?
See below
ERROR STATE ERROR DESCRIPTION
------------------------------------------------------------------------------
2 and 5 ...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 19, 2013 at 5:18 am
WolfgangE (9/3/2013)
I thought about making the PK on the identity column, clustered, and add an additional unique nonclustered index on the rest of the columns.
In this case There is...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 19, 2013 at 2:48 am
anoop.mig29 (9/19/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 19, 2013 at 2:15 am
NO both are different .
Rollback then raise error, then error will not raise but vice versa will raise the rerror.
see
begin try
begin tran
select 1/0 as result
commit
end...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 18, 2013 at 8:01 am
51 views ( last including mine) but NO response and the reason is :
No sample data
NO business rule or logic
NO table definition on this post.
Include them and...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 18, 2013 at 7:37 am
Create Maintenance Plan >> Maintenance Cleanup Task >> Delete specfic file >> Delete Older file older tha 1 month
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 18, 2013 at 5:15 am
Also place table definition plus some sample data.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
September 16, 2013 at 6:55 am
Viewing 15 posts - 241 through 255 (of 2,462 total)