IWETHEY v. 0.3.0 | TODO
1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / SQL/Server rant for the day
Post #131,262
by broomberg
12/17/03 4:52:44 PM
Reply
New SQL/Server rant for the day
SQL/Server has 1 tmp database/tablespace shared by all users.
You cannot specify a different database for a given user.

Same concept as Oracle temp area, but far more used.

The SQL/Server version of "create table as select" is "select into".

When you use "select into" it locks the catalog of the database that the table is being created, which then keeps all other users from creating any tables in that particular database.

If you create your own tmp table via the "select into" syntax (very common), it prohibits all users from creating tmp tables until done, which can be a VERY LONG time.

Since joins, group bys, order bys, etc all can create tmp tables, the entire SQL/Server system grinds to a halt.

AAARRRRRGGGGGGG!!!!!!!
Post #131,264
by ChrisR
12/17/03 4:55:36 PM
Reply
New Moral of the story is...
...don't use SELECT INTO in SQLServer. You listed a couple of the reasons, but there are some others as well. Just do a CREATE TABLE #temp and then insert the recordset into the temp tables. Better yet, use a TABLE VARIABLE and avoid the transactions overhead.
Post #131,344
by mmoffitt
12/18/03 9:49:39 AM
Reply
New What he said.
bcnu,
Mikem

Java, Junk. Both start with a "J", both have four letters. Coincidence? I think not.
Post #131,271
by FuManChu
Picture of FuManChu
12/17/03 5:25:05 PM
Reply
New Won't it be interesting when...
SQL Server *is* the filesystem?

On a network file/print server?

I don't know whether to >:) or <:(
I was one of the original authors of VB, and *I* wouldn't use VB for a text
processing program. :-)
Michael Geary, on comp.lang.python
Post #131,468
by static
Picture of static
12/19/03 5:00:05 AM
Reply
New Yet again MS show a single-user mentality.
And put it in a supposedly multi-user product.

I really don't think they'll ever learn.

Wade.

Is it enough to love
Is it enough to breathe
Somebody rip my heart out
And leave me here to bleed
 
Is it enough to die
Somebody save my life
I'd rather be Anything but Ordinary
Please

-- "Anything but Ordinary" by Avril Lavigne.
Post #131,471
by deSitter
Picture of deSitter
12/19/03 6:19:01 AM
Reply
New No choice
That's Just How It Is with Windows OS/2.3.11NT9582000MEXProHome.

Windows is single user, and his name is Bob.
-drl
     SQL/Server rant for the day - (broomberg) - (5) - Dec. 17, 2003, 04:52:44 PM EST
         Moral of the story is... - (ChrisR) - (1) - Dec. 17, 2003, 04:55:36 PM EST
             What he said. -NT - (mmoffitt) - Dec. 18, 2003, 09:49:39 AM EST
         Won't it be interesting when... - (FuManChu) - Dec. 17, 2003, 05:25:05 PM EST
         Yet again MS show a single-user mentality. - (static) - (1) - Dec. 19, 2003, 05:00:05 AM EST
             No choice - (deSitter) - Dec. 19, 2003, 06:19:01 AM EST

That's the kind of thing I enjoyed watching for hours on acid.
43 ms