adam | Shared With: Everyone - Nov 28 2006 | sql server, database, microsoft, oracle
Quoted: Microsoft Corp may be taking the most heat among software vendors for security problems, but it's not always the one with the worst record.
- adam | Shared With: Everyone - Nov 19 2006 | IT, sql server, database
Quoted: Some nifty SQL statements I made last week: Firstly, listing all databases on a server. -- Get Databases SELECT name FROM master.dbo.sysdatabases ORDER BY name Secondly, a way to get all the user-created stored procedures from a database. -- Get Stored
- adam | Shared With: Everyone - Nov 13 2006 | database, trailers, movies
I started watching this... but wasn't able to finish it. It is an extremly interesting movie, but there some extremely sexually disturbing portions in it.
Quoted: Mysterious Skin on IMDb: Movies, TV, Celebs, and more...
- adam | Shared With: Everyone - Oct 05 2006 | sql server, database, microsoft, @@identity, programming
good explanation of @@IDENTITY vs SCOPE_IDENTITY()... I never knew the difference. Also, there are 9 other things you should watch out for. (lots of common sense)
Quoted: Both @@IDENTITY and SCOPE_IDENTITY() return the last identity value (primary key) that was entered by your active session, but in different scenarios they can each ...
- adam | Shared With: Everyone - Oct 02 2006 | sql server, database, microsoft, programming
Looks nice for Data Dictionary searches...
Quoted: The following lengthy SQL script will create a system function in SQL Server that returns a data dictionary for any database on the server
adam | Shared With: Everyone - Sep 26 2006 | sql, blogs, sql server, database, microsoft, not jesus![John Papa [MVP C#] : Find a Column, Find a Table in SQL Server](http://i.faves.com/01/49/e968/43ca5d21/e5725e827a92ab559c_5.jpg)
nice little stored procedure to find columns by name in a schema.
Quoted: Here is a short stored procedure that you can use to find: * a table by its full name * a table by partial name ...
- adam | Shared With: Everyone - Sep 26 2006 | news, taxes, database, budget, not jesus
This supposedly will cover $1 trillion in gov't spending... but what is the total US Annual budget?
Quoted: President Bush said Tuesday that Americans will now be able to "Google their tax dollars," as he signed a law to create an online database ...
- adam | Shared With: Everyone - Aug 09 2006 | database, work, oracle, 9i, dbms_job, not jesus
Good syntax page for Oracle Jobs.
- adam | Shared With: Everyone - Jun 26 2006 | sql server, dba, database, report, not jesus
looks useful for a DBA
Quoted: Use this SQL Server SP to generate a report of all SQL Server jobs.
adam | Shared With: Everyone - Apr 24 2006 | Database, microsoft, howto, cluster, not jesus
overview of how to set up a clustered SQL Server setup on a single box (using MS Virtual Server)
Related Content from Around Faves
database
-
Those plucky penguins--already passé. Whales and polar bears--just fads. But dinosaurs have kept their scaly grip our imaginations. The new DinoBase from the University of Bristol in the U.K. offers plenty of information for everyone from dino dabblers to devotees who want to check whether there's such an animal as "Elvisaurus." (There isn't.) A database holds vital statistics--such as length, weight, and time span--for several hundred dinosaur species, including Stygimoloch spinifer (above), a 3-meter-long herbivore from what is now Montana. Its elaborate headgear might have served as a weapon or as a lure for mates. Visitors can tour a gallery of dino art or dig into the site's forum for announcements of fresh finds and the latest on current debates, such as whether commercial fossil hunters hurt or help paleontology.
Volume 316, Number 5828, Issue of 25 May 2007
1 FaverViewed: 9 Times - mohit - Jul 22 20081 FaverViewed: 2 Times
- garraxxi - Aug 04 20071 FaverViewed: 18 Times
