i have a database with 400 stored porcedure , i need to optimise it , i found that tables are not having command index also.

like joins where ,group by ,...

i have seen DTA can take table as input, but somebody said only one statement can be put in side the workload tables' one row.

i need to anaylise all storeprocedures...

i need to know  how AI can do that bulk tasks which u mentioned.

i think he said it should increment to the size of the database. but still u can answer on my meterics like onece in day or twoice in a day...

• This reply was modified 1 year, 3 months ago by rajemessage 14195.
• This reply was modified 1 year, 3 months ago by rajemessage 14195.

artical does not say any thing about critaria , like the increment of datafile or log file should be once in a day or twoice in day?

like if i know...

• This reply was modified 1 year, 3 months ago by rajemessage 14195.

my second query is. the place i am looking is correct  place for (10 to 15 ms)  or it is telling diffrent  story?

• This reply was modified 1 year, 3 months ago by rajemessage 14195.

one more thing  my log file of database (this is not tempdb this is reular db) is increasing like this , should i increase then auto increment?

file is attached.

• This reply was modified 1 year, 3 months ago by rajemessage 14195.

second question is unanswered.

1. yes it is pk id pool, we pick up from this table and insert into our OLTP table's PK.

2) sequence i can not use , becasue the id is...

like inlinable scalar udfs requiremnts , is there any link which can tell me requiremnts of UDF like this one

do u want to say that we should not use begin end in inlined scalar functions?

do u want to say that we should not use begin end in inlined scalar functions?

• This reply was modified 1 year, 6 months ago by rajemessage 14195.

the case is one bat file runs at a time. kindly answer in this light.

regarding q1) are u saying sqlcmd when completes, it closes the connection or it keeps the...

this is how i am calling

xyz.bat this is called from microsoft sheduler. the contenct of .bat is followng.

sqlcmd -S abc -U rr -P xyz -Q "use db EXEC usppp @strSourcedb...

• This reply was modified 1 year, 10 months ago by rajemessage 14195.
• This reply was modified 1 year, 10 months ago by rajemessage 14195.
• This reply was modified 1 year, 10 months ago by rajemessage 14195.
• This reply was modified 1 year, 10 months ago by rajemessage 14195.
• This reply was modified 1 year, 10 months ago by rajemessage 14195.

With one exception, you can switch from one isolation level to another at any time during a transaction. The exception occurs when changing from any isolation level to SNAPSHOT isolation....

• This reply was modified 2 years, 4 months ago by rajemessage 14195.