Temp tables are created in tempdb just like you create any other table in your user database. Only difference is it will be destroyed when u disconnect (Prefixed with #)...

Do you mean to say you do not understand deadlocks or do you mean...

protection from what? unauthorized access? you can use the password clause of the backup command.

You should take tape backups or copy backups to remote location so that your backup copy...

difficult to guess i think. You need to monitor bytes recieved/sec, bytes sent/sec from the counter SQL Server: Database Mirroring.

You can also monitor transaction delay.

mangoale (11/17/2010)

---

Thanx ,

we are running crm which is slow to open and navigate to other tabs.

crm application us nsitting on another server and the server is doing fine.

sql server is...

jeelanik (11/17/2010)

---

Hello,

I need to insert millions of rows from one production database to another database on the same production server. I wanted to accomplish this in the most efficient...

SQL Server will grab the amount of memory it requires but wont release it to OS unless OS asks for it. It will keep the memory with itself even when...

ekknaveen (11/17/2010)

---

Hi,

In my application the below procedure is called which will update the next integer value in the table that is passed to it. The table contins only 3 records....

Duration is the total time spent by that SP/Query. Its measured in milliseconds.

Does your SP accepts parameters? If yes, pls modify the parameters to different sets of values and observe the time taken by it. is it same?

Profiler does nothing but...

Did you run the SP or did you run the T-SQL code which is part of SP?

If it is latter, I'll agree with Lowell's second point. It's highly likely due...

Users will not be impacted on principal server while setting up mirroring.

Creating an extra log file will be good if you suspect log might get full. However, it will depend on the table size/number of rows in it.

If you have a...

Thanks Wayne. It's advisable not to use profiler or client side trace on a loaded production box.

If you are modifying char(10) to char(64) then each row will expand by 54 characters. It depends on the number of rows your table is currently holding. does the 32...