CELKO (3/19/2012)

---

Part of the University of Maryland and DoD research was the effect of formatting on maintaining code. Desktop programmers do not know or think about maintaining code but that...

Check this out: http://www.bimonkey.com/2010/05/an-sql-alternative-to-the-scd/

No, with AWE enabled...

CU is a "cumulative update." Cumulative means up to and including. Therefore, the answer to your question is "yes."

I think it comes down to more of what it is doing. When I ask the engine to generate a script for me, I don't "expect" any sort of...

Sorry... Can you run SELECT @@version and post the full version?

Also... Just curious. What version are you currently on?

er.sivaganesh (3/16/2012)

---

Thanks,

Jared

SQL Know-It-All for u job s for me and i inform u solved this problem by ...

It is possible, but not optimal in most cases. In...

My first concern is that you are talking about partitioning on ID, but I assume from your previous partition naming that it is actually partitioned on date. So which...

k, I'm going to try this one last time...

CREATE PROCEDURE [CategoryName]

@VALUES varchar(1000)

AS

SET @VALUES = REPLACE(RTRIM(LTRIM(@VALUES)), ' ', '%' );

SELECT c.CategoryName

, CategoryId

, SB.SubCategoryName

, SB.SubCategoryId

FROM tblAdCategory...

Lynn Pettis (3/15/2012)

---

SQLKnowItAll (3/15/2012)

---

Lowell (3/15/2012)

---

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us...

From MS http://support.microsoft.com/kb/314648

In comparing the numbers reported by SQL Profiler with those from STATISTICS IO, it is important to note that logical and physical IOs may be incurred doing work...

I am certainly not an expert in this, but the profiler specifically looks at "logical Disk Reads" whereas the statistics IO show"logical reads." I am guessing it has something...

Lowell (3/15/2012)

---

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread...