Viewing 15 posts - 241 through 255 (of 3,061 total)
Do not use export/import wizard, script your data load - first do your parent tables then your child tables as defined by Referential Integrity constraints.
An alternative would be to disable...
July 23, 2012 at 7:46 am
leesider (7/23/2012)
July 23, 2012 at 5:37 am
Not need to even worry about the total number of rows stored across all your tables, performance is a function of the tables included in a particular query, the quality...
July 22, 2012 at 4:49 pm
wanox (7/19/2012)
What can i use to track changes made st server level
Do you mean, 'server' as in the physical server? as in platform including O/S? as in platform including O/S...
July 22, 2012 at 4:37 pm
ali.mahmoud.habib (7/22/2012)
July 22, 2012 at 4:34 pm
Jeff Moden (7/21/2012)
PaulB-TheOneAndOnly (7/21/2012)
Welsh Corgi (7/21/2012)
July 22, 2012 at 7:47 am
Welsh Corgi (7/21/2012)
July 21, 2012 at 4:56 pm
Welsh Corgi (7/21/2012)
I totally agree and understand that you do not want to delete records but flag them as inactive.
In general the inactive flag is not enough because it doesn't...
July 21, 2012 at 3:29 pm
lokeshvij (7/20/2012)
July 21, 2012 at 2:46 pm
Build you own lab a.k.a. install SQL Server on your home computer then go to Books Online a.k.a. BOL (installed alongside SQL Server) and read the chapter about architecture.
After that,...
July 21, 2012 at 2:39 pm
krishnasoft43 (7/21/2012)
WHAT IS THE TCP/IP ADDRESS IN SQL SERVER 2008 AND HOW TO CHANGE THAT ONE.
hey hey... no need to be that loud! 😀
I assume you are asking for the...
July 21, 2012 at 2:36 pm
richykong (7/20/2012)
...I used the MERGE statement and DELETE statements to handle all my ETL...
I do agree on the MERGE statement but I do not on the use of DELETE -...
July 21, 2012 at 1:49 pm
Welsh Corgi (7/2/2012)
I'm creating Staging Tables in SQL Server and I was wondering what does a VARCHAR2(100 BYTE) or VARCHAR2(15 BYTE), etc translate to in SQL Server?
Ora11g allows to...
July 19, 2012 at 10:41 am
I'm sorry I'm not in agreement with the approach.
Provided each tenant actually owns its own data warehouse I wouldn't put all of them together in a single database - I...
July 19, 2012 at 10:32 am
GRUNNINGER (7/3/2012)
... we have multiple products from multiple suppliers (Many to Many relationship)...
Break the many-to-many relationship - add a bridge table.
July 16, 2012 at 6:06 am
Viewing 15 posts - 241 through 255 (of 3,061 total)