psangeetha (5/14/2009)

---

I've the same issue still going on.. At this stage, we just want to provide our clients with what they will need to do when the master key gets...

doug turner (5/14/2009)

---

I can see the mapped drive in Windows, but I'm not sure how to get SQL Server to see it. The link you sent is a big...

so .... after migration/implement of a new version of your dbs, things started going the wrong way.

Did you rebuild your databases indexes after the big maintenance ?

How are your current...

I thought he was beyond that point.

Off course that is the way to start any investigation !

HDMan,

Keep in mind your largest consumer may actually have a small avg...

and if you actually need speed....

- 64-bit

- CPU

- RAM

- SSD disk sistem (e.g. ramsan )

Start with asking a huge budget ( blanc cheque if you can :hehe: )

Check out topic "Readme_SlidingWindow" in BOL !

With partitioning, preparation is crucial !!

The one you already have is SQL Server Profiler ! ("C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE")

Start a trace and analyse it.

3th party tools:

- Quest software : Spotlight for SQL Server

- Idera :...

As Steve said : the password doen't need to be the same;

The backup password is used to encrypt the backup itself. Nothing else.

If your business applications connect providing all possible connection info (application name, workstation id,...) ....

those non-business application connections can easily be rejected using a login trigger and only allow...

What's your backup frequency ?

You may experience the result of IO shortage.....

If you have online index rebuilds, tempdb will be used !

This may cause read/write contention with tempdb file(s)...

In fact a snapshot db is created without any entries !

Data is only inserted if rows are modified in the originating database (or objects altered/dropped).

That's why a snapshot db only...

No.

A shapshot only preserves the state at the moment it has been taken !

So it only contains a single truth about a row at a certain point in time.

Keep in...

so that would be a rbar promotion ?

I know I'm way off, but in would a pivot help to determine the set ?

IF object_id('v_SSC_Assignment_InstructorCorse') IS NOT NULL

...

With a system as yours that is apparently vulnerable to fast degradation of statistics, and that doesn't perform well after the daily updatestats I would try to disable the daily...

just remove @ from your connectionstring and you should be ok

If sqlbrowser service is running, you don't need to supply the port number (,13...)

Then you can remove that...