carlos.tapadinhas (10/21/2008)

---

...but i created the sp because i need to use temporary tables, and in functions is impossible, so my option was create the sp and then trying to insert...

Heh, OK, say that ten times, fast. :laugh:

NULL does not work the way that you are thinking.

Try this command:

SELECT CASE When NULL=1 Then 'one' When Not NULL=1 Then 'Not' Else 'Else' End

, CASE When NULL Like '%X%'...

Heh. I used to ask this one in my interview questions:

Declare @str varchar(4000)

Set @str = 'lklkjdflskjflskdjflskdj''1234''s98dfuw8efawufw8uf8'

Declare @Q char(1)

Set @Q = ''''--Apostrophe, or single-quote

Select Substring(@str

, CharIndex(@Q, @str)+1

, CharIndex(@Q, Substring(@str, CharIndex(@Q,...

No Primary Key or Clustered Index? (just checking, to be sure)

Glad we could help. If you can, let us know how it works out.

No, I have yet to try that.

Moving to Raid 1+0 is definitely recommended (Raid 5 is not good for SQL Server files).

Splitting out the .mdf to alternate data files can help, if done correctly, but only...

Sherif: Nice sProc! You should contribute this to the SQLServerCentral.com Scripts.

It works for me. I was doing a Performance Analysis delivery just two weeks ago and I added this event and was surprised to see it in the display...

Thanks for the assist Greg. I don't usually have a SQL 2000 server available to test on. 🙂

Will Summers (10/23/2008)

---

Nonsense. I have a degree in Theoretical Mathematics, Logic and...

Glad it worked out.

dastagirid (10/23/2008)

---

I attached one file.on that file one table is there .That table have 100000 records.

When i used profiler and found duration time when execute that query.It takes 1584...

Like this:

drop table #t_log

drop table #t_periods

CREATE TABLE #t_log(

sactioncode varchar(10),

tscreated ...