sqlfriends (6/9/2011)

---

I'm trying to figure out some license issues.

I know if only client tool like sql management studio is installed, it will not require license.

how can I know if it...

Chances are the constraint was created as a named-default in Tab1 and an unnamed-default in Tab2. It may have gone something like this:

CREATE TABLE dbo.Tab1

(

[ToDate] [datetime] NOT NULL

...

In general it's not about always using a CTE over CURSOR...the main point to take away is...

Jim Murphy (6/9/2011)

---

GilaMonster (6/9/2011)

---

SQLRNNR (6/9/2011)

---

Steve Jones - SSC Editor (6/9/2011)

---

Just an FYI, those of you that posted in the "real world financial problem", I whacked the thread. No replies or...

Tangent to the OP but since you asked: ALTER TABLE...REBUILD or you can add a CI and then immediately...

Since it is a heap, and you were deleting from it every 5 minutes (and I assume something else was inserting into it just as often) it could have been...

James A. Lawrence (6/9/2011)

---

Thanks to all for your input on this!

I actually was able to find yet one more way to get this to work!

select distinct

t1.A_PREFIX,...

hxkresl (6/9/2011)

---

Yes, I see how that would work. I am sticking with my cursor based script because it is strictly an administrative task, but I appreciate knowing about this...

@Offices.nodes('/Offices/OfficeID', '/Offices/OfficeID/PracticeID')

If these files are sent for a business purpose it would be best to ask the source for...

That will still require another access to the base table. There is a way to do it without touching the table again, and we know the query he shared is...

BOL says you can partition a heap...not that anyone would, would they? Uggh.

Profiler will generate a lot more data than you need. You could load your trace files into a table as needed and delete what you do not need however that's...

I am confident the original query could be fixed but here is the cte with the query you just provided. The downside is that it only handles default constraints. It...

Oh, it's a command line tool 😀

It's a good one to keep in your toolkit for troubleshooting these kinds of issues. Sometimes the network folks unintentionally get involved and break...