PGarberick (8/16/2012)

---

I don't know quite what the cross-out stuff was about but it did give me an idea as to what happened. Next time I will be more specific...

Lynn Pettis (8/16/2012)

---

Because Isabelle can't commit the...

How does he "see" 12 rows? SELECT TOP 12? SELECT *?...

Oh...

EDITED

Second question... What does Isabelle see when she runs a commit? :w00t:

Also, the question is incomplete. Like asking how many car lengths are between me and that tree over...

It is quite a nice product, huh?

Jeff Moden (8/15/2012)

---

SQLKnowItAll (8/15/2012)

---

Jeff Moden (8/15/2012)

---

SQLKnowItAll (8/15/2012)

---

Jeff Moden (8/14/2012)

---

SQLKnowItAll (8/14/2012)

---

The actual execution plans are exactly the same for each and IO is the same. Interestingly enough... Every time I...

Jeff Moden (8/15/2012)

---

SQLKnowItAll (8/15/2012)

---

Jeff Moden (8/14/2012)

---

SQLKnowItAll (8/14/2012)

---

The actual execution plans are exactly the same for each and IO is the same. Interestingly enough... Every time I run this, the...

And this?

SELECT DISTINCT so.name

FROM sys.objects SO (NOLOCK)

INNER JOIN sys.sql_modules SC (NOLOCK) on SO.object_Id = SC.object_id

AND SO.Type = 'V'--P for stored procs

AND SC.definition LIKE '%textSearch%'

ORDER BY SO.Name

What about this? I think without schema_binding on the view, you have to search the view definition...

USE databaseName

GO

SELECT Distinct SO.Name

FROM sys.sysobjects SO (NOLOCK)

INNER JOIN sys.syscomments SC (NOLOCK) on SO.Id...

Lowell (8/15/2012)

---

there sure is:

this example will give you all columns that have a certain name;

if you want to specifically limit it to a specific table also, simply uncomment out the...

I use this, but syscomments is not the best place anymore. I'm sure someone will respond with the new dmv for this.

SELECT *

FROM sys.objects SO (NOLOCK)

INNER JOIN syscomments SC...

If you want the objects without data, use the right-click -> Generate Scripts option on the database.

Luis Cazares (8/15/2012)

---

Jared,

The order should be determined by UnitsInStock for each CategoryID, unless there is a zero for any value in UnitsInStock for that particular CategoryID, the order should...