Hi Group, Please suggest how we can execute and get the result on TB size database, already facing issue with high utilization of resource. Thanks Harsh ...
Hello Friends, I need to know why we can not setup mirroring in SIMPLE recovery model. If you say logs get trucated in simple recovery model so Suppose...
6660
mohd rizwan
mo2riz
Dec 30, 2010 7:30 am
Hello Friends, I need to know why we can not setup mirroring in SIMPLE recovery model. If you say logs get trucated in simple recovery model so Suppose...
6661
mohd rizwan
mo2riz
Jan 3, 2011 2:56 pm
Hello Friends, I need to know why we can not setup mirroring in SIMPLE recovery model. If you say logs get trucated in simple recovery model so Suppose...
6662
VISHNAT
Jan 3, 2011 3:24 pm
Rizwan , I would think it would have to do with how the system is developed , besides a simple recovery model doesnt mean the log gets truncated it mean there...
6663
Neeraj Malik
nrajmalik@...
Jan 3, 2011 6:25 pm
Hi Rizwan, Yes, it uses LSN for successfully maintaining the synchronization between two servers and also in case of failover happens. For quick reference you...
6664
SARADADEVI
sv_39
Jan 4, 2011 12:41 pm
 Hi DBA-MSSQL Team,  Currently DEALER database is having performance issues for a specific query; details as follows:  Query: UPDATE trnRegistration...
6665
Vijay Mishra
mishravijay
Jan 4, 2011 1:00 pm
Instead of adding mins to ADateTime manipulate the value from get date() function. I am presuming table has index on adatetime col.. Sent from my iPad ... ...
6666
SARADADEVI
sv_39
Jan 5, 2011 2:09 pm
Hi, How to enable identity for a column to yes after data export from source table to destination table. Regards, Kishore [Non-text portions of...
6667
mohd rizwan
mo2riz
Jan 7, 2011 6:29 pm
Thank you very much Vishnat for you reply but I don't think it is true.........In simple recovery model also everything gets logged as per my knowledge......I...
6668
sunil john
suniljk7
Jan 26, 2011 3:04 pm
for index defragmentation u have to check the dmv.. sys.dm_index_physical_stats Best Regards Sunil John ________________________________ From: SARADADEVI...
6669
SARADADEVI
sv_39
Apr 16, 2011 7:17 pm
Hi Team, here are two table: LookUp and Users Lookup table has: From_ID, To_ID, and FName User Table has: ID, and FName Compisite key on From_ID,...
6670
raja zulfe
rajazulfe
May 25, 2011 11:07 pm
http://alexkingsbury.com/enterin.html [Non-text portions of this message have been removed]...
6671
raja zulfe
rajazulfe
May 27, 2011 12:34 am
http://carmenleilani.com/enterin.html [Non-text portions of this message have been removed]...
6672
Sandeep Chanda
sandeep_chanda
Jun 9, 2011 5:40 pm
Hi All, We are expanding the BI function, and looking for experts in SSAS, SSIS and SSRS skills. DBA knowledge is desirable. Please revert back if you know...
6673
Senthil Kumar T R
trsenthilkumar
Jun 21, 2011 11:11 am
Hello All, I have this situation: I have two databases say "db1" and "db2". I have a table "tbl1" in the database db1. I have a SP proc1 in databse db2...
6674
ramakrishna_e2
Jun 22, 2011 6:37 am
Hi Senthil, Only way you could find dependencies is using SYSCOMMENTS table & sp_depends stored Proc. Please find below article that will give you more info...
6675
W
wzkmafi
Jun 26, 2011 6:03 am
Is the join below the most efficient version of this code here...? SELECT USER_ID FROM USER WHERE USER_ID NOT IN (SELECT USER_ID FROM VACATION) SELECT USER_ID ...
6676
W
wzkmafi
Jun 26, 2011 4:31 pm
Is the join below the most efficient version of this code here...? SELECT USER_ID FROM USER WHERE USER_ID NOT IN (SELECT USER_ID FROM VACATION) SELECT USER_ID ...
6677
sunil john
suniljk7
Jun 27, 2011 7:51 am
Join is efficient way of coding, but below both queries will give diff output. Best Regards Sunil John ________________________________ From: W...
6678
ramakrishna_e2
Jun 27, 2011 9:56 am
In General. A subquery is equivalent to a joinThe reason being that the biggest problem with joins is ordering them correctly and making the best use of...
6679
W
wzkmafi
Jun 28, 2011 10:39 pm
Ok, Maybe i should have asked this this way :-) What would be the Most efficient code for this query? SELECT USER_ID FROM USER WHERE USER_ID NOT IN (SELECT...
6680
W
wzkmafi
Jun 28, 2011 11:38 pm
What would be the Most efficient code for this query? SELECT USER_ID FROM USER WHERE USER_ID NOT IN (SELECT USER_ID FROM VACATION)...
6681
Gigme Chittayath
gigmepc
Jun 29, 2011 2:17 am
Best method is using a left join. select a.user_id from user a left join vacation b on a.user_id=b.user_id where b.user_id is null ...
6682
ravindhar Bonagiri
bonagiri_ravi
Jul 24, 2011 3:58 pm
Hi Senthil, You can access the objects across the databases using Linked Server concept. Create linked server and use the syntax like select * from...
6683
SARADADEVI
sv_39
Aug 1, 2011 3:51 am
Requirement:-Do dev db refresh by using prod db backup. I don’t want to lose existing privileges in devdb. Environment :SQL2005. For that what need to be...
6684
mohd rizwan
mo2riz
Aug 4, 2011 5:57 am
Krishna,  You can follow below steps to achive this..  1)Script out all Users,Roles, Schemas & permission of DEV database and save it. 2)Take backup of...
6689
sunil john
suniljk7
Sep 13, 2011 6:59 am
using not exists is also a good method. Â Best Regards Sunil John ________________________________ From: Gigme Chittayath <gigmepc@...> To:...
6690
Senthil Kumar T R
trsenthilkumar
Sep 30, 2011 7:57 am
Hi All, Here is what we need: 1. All possible TimeZones with UTC offset 2. DST info (ie. when DST starts and ends for next 20 years and...
