Viewing 15 posts - 1,141 through 1,155 (of 3,061 total)
Jamesyoung79 (3/8/2011)
... I like the protection of the foreign keys, but then again its not likely my program will enter in a code that doesn't exist...
Never underestimate the capabilities of...
March 8, 2011 at 7:34 am
Jamesyoung79 (3/8/2011)
March 8, 2011 at 7:26 am
SQL ORACLE (3/7/2011)
Do you have ideas how to de-partition a table?
On the top of my head...
1- Get partitioned table down to just one partition by merging partitions
2- Once you have...
March 7, 2011 at 4:04 pm
vikingmanm (3/5/2011)
When trying to total a column of numbers, does the data type have to be numeric. Right now it is data type money because they...
March 7, 2011 at 2:59 pm
UMG Developer (3/7/2011)
March 7, 2011 at 2:53 pm
AndrewJacksonZA (3/4/2011)
How do you guys deal with optimising performance when "SELECT * FROM" is involved?
A "select *" is rarely a good idea but I understand you do not have access...
March 4, 2011 at 8:19 am
...also, you may want to somehow "hide" personal and confidential information you do not want to be available to testers and developers like SSN, CC#, salaries, phone numbers, addresses, etc.
Please...
March 1, 2011 at 2:16 pm
marklegosz (2/28/2011)
February 28, 2011 at 4:24 pm
Sridhar-137443 (2/28/2011)
we have a table named "Employees". It has fields company, empno, active and some additional fields like (lastname, firstname, middle name, address etc). I created an index on company,...
February 28, 2011 at 7:53 am
pietlinden (2/27/2011)
Where do I purchase this "Brain Assisted Pen"? Does it have to be assisted by my brain? (What good is that?!)
Go to office depot, office max or...
February 27, 2011 at 1:01 pm
GilaMonster (2/26/2011)
PaulB-TheOneAndOnly (2/26/2011)
if SS2K5 then take a look at "alter database for attach_rebuild_log"if SS2K then take a look at "dbcc rebuild_log"
attach_rebuild_log only works if the DB was cleanly shut down....
February 26, 2011 at 5:49 pm
if SS2K5 then take a look at "alter database for attach_rebuild_log"
if SS2K then take a look at "dbcc rebuild_log"
February 26, 2011 at 2:42 pm
SQL_Student (2/26/2011)
Any suggestions on a recommended open source software that is fast, simple, and thorough in helping me design a ERD for my database? Thank you
Brain Assisted Pen and Notepad...
February 26, 2011 at 2:28 pm
eseosaoregie (2/22/2011)
February 25, 2011 at 2:31 pm
I think you have to read again the specs... specially the part that clearly reads "You are to undertake this assignment individually, although you may discuss ideas with your fellow...
February 25, 2011 at 2:16 pm
Viewing 15 posts - 1,141 through 1,155 (of 3,061 total)