I have a scenario as follows: <br /><br />I have SP2(Stored Proc 2) to execute followed by SP1. I want to use one Non-Clustered index and drop the...
Is performance monitor same as tuning advisor? I ran tuning adviser and it ran for some time when I got the below message as an error: Error...
DBCC SHOW_STATISTICS(Table.Index_Name) gives statistics. This is very different in these two cases as below. If the index is made and then the...
SourceDBError: Login failed for user ‘dba#%92. The user is not associated with a trusted SQL Server connection. I have given all the privileges...
Hi Y'day I was inserting some in rows in table_A then I found that Identity_Insert for Table_B was on so I have to Put Off the Identity_Insert of...
Hi, PF queries below: 1) select *, sales_status_cd from fund_status where fund_status_cd = 'c/d ' 2) select *, sales_status_cd from...
I want to see trailing space for some records in the table. Table name is fund_status. Q1) select...
Data for text type columns is not transferred when I do the data transfer from DB to another. Do we have any fix for this? Ashish Johri
What is the difference between Q1) and Q2) as follows? DELETE FROM TABLE1 TRUNCATE TABLE TABLE1 I have observed that in some cases first query...
I am getting the error as below while parsing a huge query having 1500000 rows: “Exception of type ‘System.outOfMemory.Exception was thrownâ€...
Deleting Duplicate Records: NameName_ID Ashish1 Ashish1 Raj2 Mansi3 Mansi3 I just want to delete update records in the table. Can I have any query...
I have seen that the below query (Q1) is more efficient than that of normal update query (Q2). But logically ‘WHILE OPERATION’ should...
Hi, Below query deals with 2 tables Cash_Receipt and Tbl_Tln_Location. UPDATECash_Receipt SETLocation_Cd= Tln.Target FROMCash_Receipt...
Hi,<br /><br />There is one very interesting thing I have observed. Eventhough I have not used this table (Hold_Withdrawal_Item_Fund) and related...
Hi, I have killed that one SP today morning. The status is still ‘KILLED/ROLLBACK#%92. How can I get rid of this. When I use kill command like...
Hi I need to optimize the query below: As the select condition is same in all the cases, I want to use ‘CASE#%92 to perform the operation...
Hello sir, I have defined Purchase_Owner_Id_Unq as an index with index_description as “nonclustered, unique located on PRIMARY†and index_keys...
While doing DTS..I got this problem as below. "Information 0x4004800c: Data Flow Task: The buffer manager detected that the system was low on...
Hi, When I query for the some tables like below: SELECT COUNT(1) FROM Table-8 This gives result 1 But when I do like this SELECT * FROM Table-8...
Hi, While Data Transfer from one DB to another I am getting following error: AllowNullChange not specified but required for column pair 72(source...
Separate names with a comma.
