You bet...

http://www.ibase.ru/devinfo/DBMSTrees/sqltrees.html

If memory serves, the code that creates the nested model has a minor error in it... it leaves...

berto (1/9/2008)

---

Don't you see guys that approach: I wait for problems and then apply a patch is very bad. On systems which have very strict SLAs 99,999 for example you...

Actually, I believe the whole "adjacency model" thingy...

Stewart Joslyn (1/9/2008)

---

Is the truncation in Query Analyser or your app? If the former, check the Query Analyser setting in Tools/Options/Results tab/Max characters per column.

If you are returning a...

GilaMonster (1/8/2008)

---

It's a .net object that acts as a link between the connection and a data set. The adaptor gets told what the select, update, insert and delete

statements for...

If memory serves correctly, I believe the numerics at the end of the temp table are just a timestamp datatype. Not sure why you would consider them to be...

I gave you the code example that demonstrates how to determine if it was correctly entered to the nearest tenth of an hour... heh... didn't intend to write your whole...

JohnG (1/8/2008)

---

Definately NOT true. Oracle stores two digits per byte (plus an overhead byte or two for sign, etc.) in a varying storage model. Equivalent to the new...

Then, I don't know...

sp_SpaceUsed may not tell the whole story unless you include a second parameter... see BOL for more info but here's the basic syntax...

Syntax

sp_spaceused [[@objname =] 'objname']

...

Well..... kinda... DBCC INDEXDEFRAG will report back once every 5 minutes with a % complete... so you could start a run and get the % complete... the math is pretty...

Heh... neither... use BULK INSERT from T-SQL 😉

Change it... it's worth it in terms of performance. 😉

Would you mind posting some data so we can help you accurately? Please see the following article for how to get really good answers quickly... seriously... read the article......

I know it's an older article, but I gotta say, nicely done, Kathi! Great examples for folks that don't know.