Hi Eirc Try below mention query to get no. of records from any table, select rows from sysindexes where id=object_id('TableName') and indid<2 I am...
Hi Kaushik I would suggest trace your SQL server for some time and find out longest running queries or stored procedure and try to work on those...
Hi Vikas If i am not wrong SQL identifies index on first fields name, and rest it will ignore. make it more clear i am gving you this example Select...
Hi Fauzan I guess what satya is saying is r8 you have to understand what is log file and how to shrink it properly, Best way to take full backup, SQL...
Hi Vikas Thanks for prompt reply, you mean for below query i have to create new index on field location? select * from table where Location='xyz'...
Hi Satya You are right, this is classroom question, i am new to SQL server and just clearing some doubt. I have 4 more queries which depends on...
Dear Fauzan Create this stored procedure(Author Andrew) and run it regulary as and when you want to shrink log file CREATE proc...
Hi Below is my table structure Emp_ID country Location Department Designation ReportingTo My Query is Select * from MyTable where Country='India' and...
Separate names with a comma.
