Not a surprise - check my previous post 🙂

Eugene Elutin (6/29/2010)

---

Stefan_G (6/29/2010)

---

Well, there are two possibilities:

1)...

Here is what happens when same query is executed twice.

First run has to do physical I/O to move datablocks from disk to buffer cache the logical I/O to serve the...

No. I mean skip the function - just a test - to see if...

Does performance improves if you hardcode what your are fnsplit() today?

it looks like developer renamed dbo.[batch] as dbo.[dbo.batch]

Larry Kruse (6/23/2010)Typically, one of the client's administrators logs into our website to send out an alert/broadcast. When the admin signs in, we present a list of all of...

Glad to help 😉

If you are confortable with current structure on Oracle side I would keep the same structure in SQL Server.

In the SQL Server world does not exist the "schema" concept but...

Ross McMicken (6/28/2010)

---

If the data is coming from a system that stores both the local currency and USD, which is most ERP and accounting systems in use these days, then...

Exactly. Volume is...

1- Check backup status/logs - ensure all databases are recoverable.

2- Check space at both database and disk levels - ensure system has enough space.

3- Check SQL Server logs - research...

Agreed but, look at the infrastructure MySpace had...

grahamc (6/28/2010)

---

and there in lies the problem... generally speaking, if you are very god on technical side, its because you have always pushed to learn/understand more, thrive under pressure, etc....

irmorteza2000 (6/27/2010)Suppose we have a website with 1,000 viewers each second. And we want to insert the viewer’s information(for example) to the SQL database. So we must insert 1,000 records...