cengland0 (7/27/2011)

---

There's a difference between a hard question and a tricky one that is attempting to have as many people...

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2

I just use the basic cpu, reads, writes, duration columns.

Those events are nice to use in their own rights :

Performance:Showplan XML Statistics Profile

SP:StmtCompleted

SQL:StmtCompleted

From : http://msdn.microsoft.com/en-us/library/ms162802.aspx

bcp AdventureWorks2008R2.Sales.Currency out Currency.dat -T -c

BCP in is pretty much just as easy.

BCP OUT!

Or do select into [2nd db].dbo.tablename

Backup that db, have them do the reverse. I still think BCP is the faster and simpler way...

There are plenty of rumors / wrong thing being thoughts, this is one of them.

It's minimally log, but it's...

BCP out.

My apologies if I don't like super easy question ;-).

jason.stephens (7/27/2011)

---

People of all skill levels visit this site. So, an easy question for one person might not be for some others. That one was easy for me but what...

STATISTICS IO is never but once you get to a 30 steps procs it becomes pretty hard to work with.

I like to use profiler and display all statements (and the...

Koen Verbeeck (7/27/2011)

---

Kiara (7/27/2011)

---

Ah, but you are leaving out the unknown...

The ridiculously exotic version.

SELECT REPLACE(PARSENAME(REPLACE(REPLACE('justin@email.com', '.', '%'), '@', '.'), 2), '%', '.')

SELECT REPLACE(PARSENAME(REPLACE(REPLACE('justin@email.com', '.', '%'), '@', '.'), 1), '%', '.')

The "real" version is to use substring + charindex

Why the heck was that column put in another table than the users table??

Sounds like the real solution unless you can give me a solid business case for the data...

Let's take this from the top. Please post the actual execution plan. Table(s) DDL including indexes and keys.

If you don't mind, I preffer aiming at sub-second times. ...

I manage it the same way as my other dbs. I presize it for 1-3 years ahead of time based on backup file size growth and projected size in...

Something else to ponder.

I have a rather low traffic system. Meaning it takes almost 1 month of transactions to get the tlog to grow as big as 1 full...