Brandie Tarvin (2/3/2011)

---

Grant Fritchey (2/3/2011)

---

It's just silly to obscure the language so badly when you're talking tech. All our little abbreviations & code words make it hard enough to understand...

I have to say, it's entertaining as hell. You guys should keep poking him/her (most likely him). I'm so glad that's the exception, not the rule, for youngsters posting in...

I've only used the iPad. But the Toshiba that's due out in the spring looks fantastic. It's a Droid and I'd go...

A query similar to this will show what you need:

SELECT deqp.query_plan

FROM sys.dm_exec_requests AS der

CROSS APPLY sys.dm_exec_query_plan(der.plan_handle) AS deqp

CROSS APPLY sys.dm_exec_sql_text(der.sql_handle) AS dest

WHERE ...

In the WHERE clause, not sure what you...

Something like this:

BEGIN TRANSACTION MyTran1

EXEC dbo.MyProcA

BEGIN TRY

BEGIN TRANSACTION MyTran2

EXEC dbo.MyProcB

COMMIT TRANSACTION MyTran2

END TRY

BEGIN CATCH

ROLLBACK...

Yes, you can query the DMV, sys.dm_exec_query_plan. You just have to combine it with sys.dm_exec_requests to get the plan_handle while it's running.

Check the execution plans. See if they're different. Both tests are against the same server? If not, look for differences there. Look for blocking... Not being there, it's hard to...

If you can't shrink those files it's because SQL Server is retaining the transaction information. That usually means replication, log shipping, or mirroring is active. That's where I'd focus at...

Are you passing it the same parameters? Are the ANSI settings the same between the app and SSMS?

Try adding a file on a different drive to the database as a log file. That should give you enough space so that you can then truncate it.

Also, if the...

If you nest the transactions, start one that wraps both procedures and start a second that only wraps the second procedure, you can rollback the second transaction without rolling back...

Raghavender (2/2/2011)

---

Grant Fritchey (2/1/2011)

---

If I were running the interview I'd want to hear a lot more than just that you'd taken the tail backup. I'd want to know which backups...

Balaji M R (2/2/2011)

---

I want to Insert and update same DB table from multiple connections.

When i try to do this, i am getting following errors.

1. "Transaction (Process ID 66) was...

Nothing different than any other upgrade. Have good backups. Test on a non-production system first. Run your database through the upgrade advisor and do what it says if any issues...

GilaMonster (2/2/2011)

---

Backups? What are backups?

sourav_1002001 (2/2/2011)

---

Unfortunately i dont have...