I think my little article regarding sqlserver and SOx can help out.

I think you should use :

start /wait setup.exe /qB VS=PRESQL17 INSTANCENAME=PRESQL17 REMOVE=ALL ADMINPASSWORD=XXXXXXX GROUP="SQL" IP="XXXXXXXX

Be carefull with remove all !

If this is the only instance on the box, it's ok,...

Thank you for the feedback.

We still haven't found the cause of this incident.

We do have a number of servers with sql2000 on it, this is the only cluster that...

fjmorales (9/23/2008)

---

I used the query for a server on SQL Serv 2005 and until now its been greate but teh server that I whant to verify is in 2000.

Is it...

just a simple server level login trigger will also do the job for you.

(i.e. do users still log in)

- Out of the box (if you're on SQL2005 SP2)

- every login

-...

Attached you'll find what I tested as a result of your request 😉

My dev edtn is on SQL2005 SP2 + CU9 ( 9.00.3282 ) so its results may...

- Can you rebuild your indexes (clustered and non clustered) ?

- If this behavior is still the same afterward, you can force it to use the index, but then I...

- I would first make myself comfortable with SSMS.

- regarding databases:

- rebuild all indexes

- sp_updatestats

- dbcc update_usage (0) with count_rows

- switch...

Let's take some advantage of the new features of SQL2005 :w00t:

Post the Execution plan !

Run your query (include actual execution plan (ctrl+M)) in SSMS on both boxes and on the...

How about:

declare @AgentSession table (AgentID [integer],SessionStart [datetime],TalkTime [decimal],BreakTime [decimal])

set nocount on

Insert into @AgentSession values (1, '20080920 11:15:00', 2700, 900)

Insert into @AgentSession values (1, '20080920 12:15:00', 2700, 900)

Insert into...

Make sure you install the same edition and service pack (+ hotfix) than your original server !

- I would try to reinstall that instance (starting from rtm) trying to restore...

- You'd indeed be better off putting your test instance at another server (not on your production box)

- You may even consider installing a developer edition (not that $$)

- If...

- Is sales_id the first column of your index ?

- is the other column the first one of the index ?

- from your total column distribution, which percentage is of...

and it should !

Partitioning is an advanced topic.

It needs proper peparation and if performed untidily it will bite you in the back !

you can grant on schema basis.

Check bol !