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 would suggest trace your SQL server for some time and find out longest running queries or stored procedure and try to work on those...
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
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...
Thanks for prompt reply, you mean for below query i have to create new index on field location?
select * from table where Location='xyz'...
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...
Create this stored procedure(Author Andrew) and run it regulary as and when you want to shrink log file
Below is my table structure
My Query is Select * from MyTable where
Separate names with a comma.