Hi Satya, Many execution plan also gives a wrong result. This shows that the index will be used but this doesn't use the index in the real time...
Sir, Do you mean that If I have trailing spaces in the data then I should remove this? As in the next version of SQL Server 'Ashish', 'Ashish '...
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...
THis is not because of ANSI_PADDING OFF. I did a small experiment as follows: 1) I created one table Foreign_Status having a column...
How to do that? Ashish Johri
1. Table sales is an empty table and has 100 crore records. Index on column sales_id is made before insertion of records. 2. Same table same no of...
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...
Correct this is the windows authentication mode only. How to change the same to SQL accounts mode once this is installed. Ashish Johri
SourceDBError: Login failed for user ‘dba#%92. The user is not associated with a trusted SQL Server connection. I have given all the privileges...
Sorry I am late to respond your mail. Actually I was trying to copy data from DB to xl sheet. Whenever any column in the table is 'text', I get the...
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...
Sorry Adriaan for sending a late reply. Thanks Adriaan for sending many options to solve the problem. This means my query to find trailing spaces...
But Adriaan when we run this query as below: select len(fund_status_cd),len(rtrim(fund_status_cd)) from fund_status Then because there are some...
Thanks tz71 and Adriaan. Adriaan, Your responses are always 100% accurate. Ashish Johri
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
I was looking for the answer from Adriaan. Thanks thomas for fruitful knowledge. Just to add one more. When we truncate then space is freed while in...
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...
Separate names with a comma.
