I agree... 2 million isn't alot of data, and don't think you need to create "history" tables that are separate from the regular tables... if you implement effective indexes, and...

This is by far...

Brent Ozar has a great webinar about this on his blog - http://www.brentozar.com/sql-server-training-videos/perfmon-and-profiler-for-sql-server/

If you have to ask that the answer is no...

No it does not need to be part of the primary key. In fact most partitions are not on the primary key but on some date field. Which is what...

Also, dont know if this will even apply to your use case without knowing more, but you might benefit by familiarizing yourself with the MERGE syntax; great for upsert logic.

GilaMonster (10/1/2010)

---

getoffmyfoot (10/1/2010)

---

What I am seeing though is alot of sub-selects in where clauses of sub-selects in where clauses of sub-selects in where clauses in....

Yes I'd like to see some...

leodec (10/2/2010)

---

hi

thanks for reply data is some how like this

col1 col2 col3

ab bc null

null A1 ...

ulteriorm (10/1/2010)

---

I was reading an interesting article related to the JOIN vs IN vs EXISTS since i had a simlar issue at our place

and hence i came up withe...

payal.beri (10/1/2010)

---

Hi guys

i need little help in below mentioned sql.... need to find out any of col1,col2,col3 is null and in last if col3 is null then in that case...

Ha, yea you did the same thing I did and ran that through some formatting. My eyes are finally uncrossed.

This segment of sql concerns me -

where ...

There really isn't enough information to do anything with here - what method are you using to load the data? SSIS? DTS Package? 3rd party tool?

getoffmyfoot (10/1/2010)

---

Robert Frasca (10/1/2010)

---

getoffmyfoot (10/1/2010)

---

I've been dying to try this myself... something to keep in mind though, analyze the io stats of your db files first (see sys.dm_io_virtual_file_stats) http://msdn.microsoft.com/en-us/library/ms190326.aspx .

It...

Robert Frasca (10/1/2010)

---

getoffmyfoot (10/1/2010)

---

I've been dying to try this myself... something to keep in mind though, analyze the io stats of your db files first (see sys.dm_io_virtual_file_stats) http://msdn.microsoft.com/en-us/library/ms190326.aspx .

It could...

Ow... my eyes...

What I am seeing though is alot of sub-selects in where clauses of sub-selects in where clauses of sub-selects in where clauses in....

Yes I'd like to see...