golden-1131024 (10/8/2009)

---

Hi all,

Just to consult some questions from you all,

I did a side by side upgrade with a newly created named instance in SQL Server 2005.

I attach the current SQL...

ItalianOlgi (10/8/2009)

---

Small company with no full-time DBA currently. Interview by VP of IT and one lady from India who knows SQL Server but only asked general questions like "have you...

Unless I am mistaken the MBSA tool (microsft baseline security analyser) will check for blank passwords as part of its checks.

spam again perhaps if not let us know

lol, weel that certanity fixed the issue, wonder if that would work for anyone else who has oracle problems :Whistling:

Totally depends on how complex your apps and databases are, for example a sql install can be done in less than 20 minutes and most organisations allocate up to 1/2...

roflmao, So i take it you already know that option, the only other option I can think...

we use sql 2008 here and we have vmware esx, but not production and not sql 2008. I do know that it is supported. but I am not an advocate...

jflzc (10/7/2009)

---

Hi,

I have a SQL Server 2005 database, the index usage statics report shows the following:

Table ...

either approach will work. I will see if i can dig up some articles if i have time

suhas.wadadekar (10/7/2009)

---

Hi,

Does anyone know how to determine the estimated time for completion of a query run.

I have manually run a stored procedure and expect it to take a long time.

However,...

I would take a stab in the dark and say change the -g startup switch to 384, i.e -g384

i think that in sql 2008 it is defaulted to 256MB, this...

Ian Scarlett (10/7/2009)

---

Didn't thrill me either... I stood...

aaa-322853 (10/7/2009)

---

Where do you guys suggest is the best location to live in the UK if you want a plentiful supply of SQL Server data warehouse/BI contracts over the next...

If you can post the execution plan for the query from both servers, that should highlight any differences.

Bear in mind that virtual machines will run slower than a physical box...