There are a lot things it could be. Parameter sniffing, stale statistics, blocking, poor indexing...

Take a look at this article about how to post performance issues.

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D

I am by no means well versed in Oracle but my goggle-fu isn't too bad. I used the default constraint of SYSTIMESTAMP on the table and found the Oracle info...

gmamata7 (7/2/2012)

---

Thanks Sean,

I understand how to create alias but got confused where to configure i.e on sql server or on client computer:

from the link http://msdn.microsoft.com/en-us/library/ms190445(v=sql.105).aspx

It says, we need to set...

I think you will far better luck with a flash forum for issues with flash. I suspect that those forums will have the same general complaints about your post unless...

Not sure really what you are asking but I found this article which explains how to setup an alias.

http://www.mssqltips.com/sqlservertip/1620/how-to-setup-and-use-a-sql-server-alias/%5B/url%5D

It doesn't really make sense to have the alias be on the...

I believe you want to use the datetimeoffset datatype.

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

I think your default constraint would just be getdate().

You can use SQL search, the free tool from redgate. It should search just about anything you listed although I am not sure it will find t-sql in a job.

Here is an interesting list, many I have never heard of before.

http://en.wikipedia.org/wiki/List_of_dates_predicted_for_apocalyptic_events

Bill Talada (7/2/2012)

---

@ Lynn Pettis

I don't remember you posting code for your 8k splitter. We all knew there was a general splitter function being used. It doesn't matter...

ChrisM@Work (7/2/2012)

---

Sean Lange (7/2/2012)

---

You will find far better performance and code maintenance by creating a sproc for each of your different select statements. The code dwain posted is indeed quite...

You will find far better performance and code maintenance by creating a sproc for each of your different select statements. The code dwain posted is indeed quite a clever way...

milzs (7/2/2012)

---

Thanks... I'll check out your link. BTW, this is a super-simplified example of my real problem which is for a system on a classified network. That's why...

milzs (7/2/2012)

---

Thanks... I'll check out your link. BTW, this is a super-simplified example of my real problem which is for a system on a classified network. That's why...

With almost 3,000 points it is hard to believe you didn't post any consumable ddl and sample data.

Take a look at the link in my signature about splitting strings. It...

eagb (6/28/2012)

---

I've been given an old script, and need to create it into a stored procedure. The script uses a cursor to delete from a table which has a trigger...