Hi,

you should set up a performance monitoring.

You can start, checking the Buffer Cache Hit Ratio over time.

With the following statement you can get the current performance counter value of the...

Hi,

will the stored procedure accessed by a application and what do you want to do with this login?

Hi,

if I understand you right, you want to run your xml generating application on another copy of the live database. So I can actually exclude mirroring because you can't read...

Perhaps some changes to sql server are made?

Look at the instance reports -> server dashboard and then non-default configurations.

Execute following statements to get details of the memory usage:

-- Buffer cache...

Have you already verified the restore paths of each file whose are listed on the options view of the management studio restore dialog? Perhaps there is a fault. Or try...

I meant to kill the corresponding task of the AD Helper service. Or is there no corresponding spid.

Furthermore you can try to track the activity of the service through processmonitor...

Hi,

what shows the task manager. How much memory is free of the physical memory? Because the sql server would only take physical memory and not page file memory.

Is the server...

Hi,

if you want to create an indexed view you must create the view with the option SCHEMABINDING which ensure that the underlying table schema will not change.

CREATE VIEW v_MyViewName

WITH SCHEMABINDING

AS

<YOUR...

Hi,

can you kill the corresponding windows session?

Greets

Patrick Fiedler

Ok,

if you want to be sure that there is a dollar amount in it you should exclude rows without dollar amount with the following:

[MESSAGE] NOT LIKE '%[%!"§&/()=?\@{[]}+*#_;a-jln-z]%' AND

( ...

Hi dant,

There is no performance...

Hi,

with which account the sql server service is running? Has this user permissions to read "F:"? Try to open a cmd as the account user with

runas /noprofile /user:DOMAIN\USERNAME cmd

type...

Hi,

what version of sql server you have? And are the live tables connected to each other via foreign keys?

If you want to merge all tables I would suggest to write...

GrassHopper (4/11/2011)

---

Flat Dollars:

[MESSAGE] LIKE '%[0-9],[0-9][0-9][0-9]%'

OR [MESSAGE] LIKE '%[0-9][0-9][0-9][0-9].[0-9][0-9]%'

OR [MESSAGE] LIKE '%$[0-9][0-9][0-9][0-9]%'

OR [MESSAGE]...

Hi,

it depends on the table definition especially the index definition of the table(s). So please post the table definition with the index information. If you have a clustered index set...