Viewing 15 posts - 9,376 through 9,390 (of 14,953 total)
Tara (6/3/2009)
If i have a clustered index on a table withtout any PK, does it satisfy the purpose of PK.
Simply put, no. They're not the same thing.
Clustered indexes, even...
June 3, 2009 at 8:56 am
It might be possible if you use a CLR trigger and set up the right messaging services between the server and the client. You can also drive a screw...
June 3, 2009 at 8:54 am
Corrupt memory? Have you tried rebooting?
June 3, 2009 at 8:47 am
That's not something to handle with a trigger. It's something to handle in the front end application.
June 3, 2009 at 8:47 am
Blog and editorial make sense to me.
I haven't run into the "don't need a DBA" concept yet. The "can't afford one" idea, oh yeah, run into that all the...
June 3, 2009 at 8:46 am
The main management tool I use for that is Management Studio. You can download the Express version from MSDN for free. The full version is on the SQL...
June 3, 2009 at 8:13 am
Inserts on heaps can be faster. Not often, but they can be.
The only real advantage to heaps is that it can avoid "hot spots" on the drives, if you...
June 3, 2009 at 8:09 am
MTY (6/1/2009)
June 3, 2009 at 7:16 am
Adam:
I hate to sound so quantum (reference to today's cartoon from the front page), but I think the principle of publishing even when there are problems with it, is both...
June 3, 2009 at 6:51 am
Greg Edwards (6/2/2009)
Looks like he may have tested in Production :w00t:That is a large font........
Greg E
Steve:
You might want to put something in that thread about editing the font size....
June 2, 2009 at 2:41 pm
The concept is crap, but I'd rather see it published and debunked than left out there.
June 2, 2009 at 12:59 pm
ken.trock (6/2/2009)
I think companies keep salary info confidential in order to keep things looking professional. Employees who are comfortable with eachother are certainly free to talk amongst themselves.Ken
I've actually worked...
June 2, 2009 at 9:43 am
hshen (6/2/2009)
This structure is causing issues. We have several two column (ID and datetime) tables in the database. Join is used a lot.
The database is in production and...
June 2, 2009 at 9:35 am
I'm reminded of a list of the funniest complaints a travel agent got from his customers. One stuck in my memory as a true testament to ignorant arrogance. ...
June 2, 2009 at 9:32 am
Just to add in my half-cent worth, I've had mixed experiences with various parts of humanity, foreign and domestic, but it's mostly good. In my experience, most people are...
June 2, 2009 at 6:41 am
Viewing 15 posts - 9,376 through 9,390 (of 14,953 total)