Viewing 15 posts - 8,071 through 8,085 (of 9,253 total)
Grant Fritchey (4/19/2010)
For anything beyond the simplest mom&pop sized database, it's recommendations are so...
April 19, 2010 at 8:54 am
You only need to licence the physical CPU sockets or in the case of a VM the virtual CPU's.
If you license the VM host machine at SQL Server Enterprise edition...
April 19, 2010 at 1:00 am
i could be wrong but i believe that should be COPY_ONLY, this stops the backup interferring with the usual backup regime currently in force on the source server
April 18, 2010 at 3:19 am
Jeffrey Williams-493691 (4/17/2010)
April 17, 2010 at 5:15 pm
Jeff Moden (4/17/2010)
T-SQL or a "C#/Java programmer with some SQL" when I conduct an interview for a DBA or SQL Developer.
ahh that old chestnut. Procedural vs set based 😀
April 17, 2010 at 5:10 pm
Hi
i'm assuming you want to transfer your Access database to a SQL Server database. If so, try the "Upsizing Wizard" in MS Access 2003
April 17, 2010 at 3:48 pm
firstly using the SA account to provision access to a sql server database is a really bad idea.
If you restore a database to a different server without exporting the server...
April 17, 2010 at 2:46 pm
Steve has the correct solution here!
April 17, 2010 at 2:22 pm
Jeff Moden (4/17/2010)
Man, I was going to jump on this at the first post. Good thing I'm trying to read the whole thread before responding. Good catch, Perry.
ha...
April 17, 2010 at 2:10 pm
Jeffrey Williams-493691 (4/17/2010)
April 17, 2010 at 2:05 pm
ananda.murugesan
but all existing users appered in new sql 2008 db.
these are the database users, they require linking to a server level login to allow server\database access
ananda.murugesan (4/16/2010)
April 17, 2010 at 3:59 am
i host my own its a lot easier. Most ISPs charge to host SQL server databases. Its almost definitely the fact the database connection is not correct.
you may want to...
April 17, 2010 at 3:50 am
chanti2985 (4/12/2010)
backup and restore is always best approach.
that's jumping in both feet first 😉
all this is dependant on the network performance and server performance. Remember with backup\restore you have to...
April 17, 2010 at 3:35 am
also make sure the workload you pass in is a comprehensive representation of the normal database activity and not just a 2 minute profile session!
you also have the ability to...
April 17, 2010 at 3:12 am
when referring to key constraints
Primary key does not allow NULLs
Unique key allows a single NULL value
so the 2 are different in that respect
April 17, 2010 at 2:55 am
Viewing 15 posts - 8,071 through 8,085 (of 9,253 total)