select name

from sys.views

where object_ID in (

...

Lynn Pettis (11/6/2008)

---

In the senerio you have created, it may not be possible. It might, however, if the mdf file became corrupt during normal processing to perform a tail...

It may be that your indexes are so small, the rebuild process doesn't do anything to help with fragmentation. Below a certain point, fragmentation is essentially disregarded because the...

Got it - they somehow changed how they display it online @ MS (You used to be able to purchase it directly from them, but no more).

The link...

Agreed!!!!!!!!!!

hehe.....but what happens when you make it less balanced....

SET STATISTICS TIME ON

SELECT RowNum,SomeInt,SomeLetters2,SomeCSV,SomeMoney,SomeDate,SomeHex12

FROM dbo.JBMTest

WHERE SomeInt IN (2,4,6,8,10)

SELECT RowNum,SomeInt,SomeLetters2,SomeCSV,SomeMoney,SomeDate,SomeHex12

FROM dbo.JBMTest

WHERE...

Jeff Moden (11/5/2008)

---

Do your tests all come back with the same rowcounts? Remember... it's random data and SomeInt has different counts for different values.

And, no... I didn't get any...

I think the crux of the issue is the comment (from BOL in the remarks section on ROUND).

ROUND

Returns a numeric expression, rounded to the specified length or precision.

Syntax

ROUND ( numeric_expression...

Actually Jeff - I do think there's something more afoot. I think you've managed to get it to use seeks because the IN's and the NOT IN's are all...

Then I would say - you have me at a loss. What you're requesting (meaning the output) IS a pivot operation, but your manager doesn't want a pivot, so...

I feel compelled to add a warning to this. I sometimes just focus on the question at hand, not necessarily stepping back to mention the dangers involved.

Because this is...

It's all in a single ALTER DATABASE statement. Look at this one (since you'd be changing the growth settings for each of the files involved)

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

It depends on what the reports are for. NOLOCK will pull inconsistent data (a.k.a. "dirty" data), so your results might not be 100% accurate or current (since it will...

Actually, before you even tackle either option, you have the slightly smaller challenge of assigning which value within a quote gets to be qt1 vs qt2 vs qt3 vs qt4....

First - a little clarification: none of the items you mentioned are "PK Generation system" for several reasons. First - they don't GENERATE squat: they report on IDENTITY values...