Thanks a lot rabbit. I figured out that the query has many AND conditions , not contains conditions even if they are not necessary in that criteria....so got rid of them. Now my query just takes few seconds for the execution.
Thanks once again.
nav mac
Last Activity: Feb 16 '12, 11:17 PM
Joined: Dec 8 '11
Location:
-
creating an insert update trigger in sql
Hello all,
I have a select query which uses many lower() functions and due to which the performance and the execution speed of the query is real bad so I want to add an
additional column to hold a lowercase version. Say,my column name is "colname". The new column "lower_colname" . I should Set
up an insert-update trigger that sets lower_colname = lower(colname).
Then set up the index against "lower_coln ame"... -
Automating Sql(2008R2) backup/Restoration process
Hello All,
I have 6 db's to be backed up and restored every week and i want to automate them,can anyone help me out how do I acheive this? Please guys I have deadline tomorrow. -
Thank you NeoPa,but in my case I can't trunacte via log file as its replicated.hmmm .Leave a comment:
-
Sql Transaction log for database is full
Hello all,
when I attempt to run a process against the database, I received transaction log for database is full error(sql 2008 r2),we know its because this database has replication subscriptions with two other systems(DB size-5 Gig with an unbelievable 145 Gig Transaction Log) but not sure how to fix this. We can't even run dbcc shrink as db has replication. There's not enough space on the drives to back it up too, thought durintg... -
Thank You so much. That really helped.Leave a comment:
-
How to send tables as XML files?
Hello,
how can i send db tables as an xml format to my customer.
In ssms there is an icon as 'Results to file' & when i right click on this i checked(checkbo x) on XML Editor but my o/p window is empty. how can i acheive this ? can anyone please help me out in this regards.
thanks,
nav -
Hello,
how can i send db tables as an xml format to my customer.
In ssms there is an icon as 'Results to file' & when i right click on this i checked(checkbo x) on XML Editor but my o/p window is empty. how can i acheive this ? can anyone please help me out in this regards.
thanks,
navLeave a comment:
-
Okay thank you rabbit...I understand now. you have been so much helpful...thnx a tonLeave a comment:
-
Oh okay so I cannot import sum of the columns as is to the database tables. I understand now. Thank you soooooooooooooo o much for your help. I have one more question rabbit, I can sum the columns of a table thru a query and add that sum column in the table right. Please correct me if iam wrong.
Once again thank you so much.....Leave a comment:
-
Thank You so much for your reply rabbit,apprecia ted.
I have imported the data from excel to sql table but there are some excel files in which column M is the sum of columns H,I,J,K,L . So if I want the same functionality to be imported to sql how can i acheive it. I need Grand Total column at the end and a total row at the end of the rows how can i do this??????????? ????? please help me out , iam really new to this and iam so much...Leave a comment:
-
Sql database
I have columns H,I,J,K,L,M in excel and a column M is the sum of (H,I,J,K,L)in excel but if I want to import the excel data to SQL how can I acheive this functionality.
Also for each of the columns H through M ,I need the total at the end.
eg: H I J K L M
t1 t2 t3 t4 t5 (t1+t2+t3+t4+t5 )
tt1 tt2 tt3 tt4 tt5 (tt1+tt2+tt3+tt 4+tt5)
............... ............... ............... .....
No activity results to display
Leave a comment: