do the logins have public permissions to all the databases? we always leave the public default and add the extra r/w permissions as needed

you can try views

we have a dev who wrote something similar except he loved using views and rarely used temp tables. write a view for every temp table insert. you...

is there a permanent roadmap for itanium or is intel selling it due to contractual requirements with HP?

how many people use Itanium? 5?

it was a plan to compete with SPARC and UNIX which have been 64 bit for years before x64 came out. the 64bit windows that...

it's not the best test, but anandtech runs some generic database tests with intel and amd cpu's. a lot of times AMD beats Intel on the db tests but will...

check out Visual Studio 2005 for databases or one of the open source code version control apps like CVS. but i think they only work if you use them all...

Gift Peddie (3/5/2009)

---

I would alway buy Intel for software development because there is always a generic Intel developed driver for all hardware in you box, AMD does not write driver...

ab5sr (3/6/2009)

---

Interesting point. I agree that SQL Server 2005 Std. had a ton of features that used to be in Enterprise, but i'm not sure that they shifted this back...

where i work our VP doesn't trust AMD due to their financial problems

I would buy a Proliant DL380 G5 dual quad core xeon and 32GB of RAM. if you use...

if we need table data we just restore to a different server with another db name and copy the data over

if you need to do this on a constant basis...

i have huge tempdb files and have never noticed any startup overhead. i usually create a tempdb file that is the entire size of the HD which is around 136GB...

teh middle one is nice,...

we run HP servers and install all the client HP software as part of the install. they have a utility called process monitor where you add the exe files, restart...

i've done this and it depends on the server

for one machine i just restored the db's, copied the jobs over and recreated logins manually. then when it was done i...

we had something similar during testing

devs had queries that said

select column1, column1, column3 from sometable order by column1

worked in 80 but not in 90