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 !

- Do read http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

Make sure you understand it !

Then play around and test a bit !

Then make a "plan of attack" for production :w00t:

- don't use xp_cmdshell ! unless there is no way around.

- You could launch a sqlagent job to process a simple "move c:\x.txt to y:\"

- as already stated SSIS can...

- Please post version details (@@version)

- Did you apply cumulative hotfixes to your sp2 ?

- do you rebuild indexes on a regular basis ,

- did you add the deadlock traces...