Hi David,

how do you mean the server doesn't know how much memory it is using?

If you are using AWE in SQL Server, then Windows Task Manager doesn't see how much...

Hi Chris,

Could it be that your select will only return one line due to the where clauses and join structure?

The best thing to do would be to post the T-SQL...

Hi David,

an instant helper here would be to limit the amount off memory the server is allowed to use.

Connect to the Server and show the Server properties and under "Memory"...

Hi Gail,

I get what you mean. But then again, where does it stop? At some point the person responsible has to have some knowledge of the system he/she...

Database X has not been backed up in 167 days.

Database Y is in full recovery model but has no log backups. Log drive will fill up in approximately 24.2 minutes...

Hi Michal,

the problem is you are "only" starting a job that starts the snapshot creation. This is why the second and third step start too quickly.

When you create transactional...

Hi,

You are wanting to change the PK on the table that is being replicated? AFAIK you will have to remove replication on this table entirely, because the PK is...

Gilles,

you won't break anything doing it that way. SSMS will issue a corresponding dbcc command to shrink the logfile to the size you enter. If the logfile can't...

Hi,

If the batch processing is within SQL Server it could be an idea to check if you are limiting the CPUs that your SQL Server is using. Either the...

Hi Jonathan,

I am by no means a profesional c# programmer. I hacked together a very quick and ugly tool to export the files into the filesystem. I would...

Hi Paul,

I do work with multi-terabyte systems. That was not mentioned in the original post, so I started with the basic possibilities. I would imagine that the methods would...

Hi there,

It seems that the RDL file can sometimes get a little confused with Parameters. The best way to fix this is to remove all parameters and save the...

Hi,

there are so many ways to do this. You could use SSIS, DTS, bcp, c#,VB .... the list goes on.

You need to specify how big the operation is. ...

I would understand a covering query to be the ideal type of query that not all developers use.

It would only returns the columns that are required, instead of

select *...

Hi,

this topic came up a while back. Please check this to see if it helps at all: http://www.sqlservercentral.com/Forums/Topic487837-19-1.aspx

regards

GermanDBA