I am a long time database developer but not long using SQL Server. I
am now working with a performance tuning group. One of the people on
the group is instant upon not using a not equal (!=) in your where
clause. He indicates that this forces SQL Server to use a table scan
instead of indexes....
more >>
I have full backup of database at 13:00
and another full backup at 17:00.
I've made backup of transaction log at 17:05
When I try to restore database to state at
15:10 (point in time) , the dialogue in Enterprise Manager
says that only time after 17:05 is valid.
It seems to me that I'v...
more >>
hi
I have a very large database with several stored procedures. now, I
need to find a stored procedure that does some calculation if that
stored procedure has a string "MESSAGE"(just an example) in an IF
statement somewhere down the procedure.
currently i am opening every stored procedure,...
more >>