Viewing 15 posts - 5,761 through 5,775 (of 6,034 total)
When performing emergency or long running maintenance operations on a database, one method to kick out all active user sessions (and insure they stay out until the database is ready...
January 14, 2011 at 3:09 pm
A decade ago, the first large SQL Server project that I had ownership of was 300 GB with SQL Server 7.0 running on a 2 CPU server with 4 GB...
January 14, 2011 at 1:39 pm
PaulB-TheOneAndOnly (1/13/2011)
...
Do not missunderstand me, I use some GUI tools like DBArtisan - which comes handy to have SQL Server, Sybase and Oracle on a fairly standard similar format -...
January 13, 2011 at 4:17 pm
GSquared (1/13/2011)
Or, more likely, it's just a legend (as originally indicated), and has a similar facility to Aesop's Fables for illustrating a point about planning for the unplannable.
If it's a...
January 13, 2011 at 9:54 am
GSquared (1/13/2011)
...
Legend has it (might be true) that there was a guy who, in the 1930s in the US, became certain that war was going to break out and that...
January 13, 2011 at 9:42 am
I have a Hotmail account, but I also have a hosted MS Exchange account for professional purposes. The problem with Hotmail, GMail, and other similar services is that it's dominated...
January 12, 2011 at 9:50 am
I think that the new database cloud services are useful in that they provide standardized and lower costs platforms for those corporations whose operations or business model already leverage it....
January 12, 2011 at 9:31 am
In case of a database breach, I'd say that the Default Trace would be my first place to look. It would be a goldmine of information, assuming the DBA left...
January 11, 2011 at 8:51 am
Lynn Pettis (1/8/2011)
The last 5 months have been an interesting journey. I am enjoying the opportunity to learn Oracle, but the more I work with it the more I'd...
January 8, 2011 at 8:05 pm
If the application developers want the data pivoted in some funky way, then grant them select permission on the tables, and tell them to create the SQL dynamically. There is...
January 7, 2011 at 3:32 pm
What's called a database in Oracle is an instance in SQL Server.
What's called a schema in Oracle is a database in SQL Server, and SQL Server may contain multiple databases.
SQL...
January 7, 2011 at 3:14 pm
jkelly (1/5/2011)
January 7, 2011 at 2:14 pm
sqldba_icon (1/7/2011)
Thanks. If i give only exec permissions on the procedures,lets say i am deploying 80 procs( which we do) then i will need to individually grant exec perm to...
January 7, 2011 at 1:37 pm
Brandon Carl Goodman (1/6/2011)
You are recommending against the use of all 12 columns as a primary key? Just want to make sure that I understood your reply.
Technically speaking, you...
January 7, 2011 at 12:42 pm
sqldba_icon (1/6/2011)
January 7, 2011 at 12:16 pm
Viewing 15 posts - 5,761 through 5,775 (of 6,034 total)