I would allocate a chunk of space based on projections for the next couple of years. This way the db would not auto grow.

You can setup alerts to email you when your...

Look in msdb database

You can use the generate sql script wizard from SQL 2k.

Alternately, you can delete all the dummy data and backup and restore the database. You will need to resync...

We are being recommended to use DB Connect to connect to the mainframe. Is this the same as ODBC?

What about the query execution plan??? Does this create only one plan or more than one (based on the number of ;numbers within the procedure)

In our application we use AFTER triggers to maintain an audit trail. We need to maintain a history of changes to the data. We know that this causes a huge...

I thought so myself. What I got though is one BBF file which i didnt think would be good for my purposes.

I think this is definitely a backup or a...

I tried that but it didnt work for me.

The data in the Select statement would pull in the order specified but would not update in the order required.

I am trying to replace a fast_forward cursor. When we migrate clients we have to update abt 20k+ transactions and it took abt 35 minutes for abt 10k transactions. The...

That worked.

Thank you.

The LookUp table essentially has the same records on both servers the Data table has 50 fewer records on the test server. Another thing that caught my eye is that...

I changed the indexes on the table and this is new reading for the execution plan.

Table 'tblLookUp'. Scan count 289, logical reads 294, physical reads 0, read-ahead reads 0.

Table 'tblData'....

Closely looking at the execution plan

The Clustered Index Scan for a Look Up table is costing 0% on the test server while the same table is taking 4% on the...

The execution plan is the same for both the servers.

Would physical disk fragmentation be responsible for this?

Thanks

Thank-you. I have registered with Prometric but i guess i can change to VUE with this code.