MarkusB (11/27/2008)

---

No, in your case if you want to restore everything until the last tlog backup (#28) you should start with the last full backup #25 and then add the...

GilaMonster (11/27/2008)

---

HanShi (11/27/2008)

---

When it is ON a lot of locking will occur and the performance falls down. We added a scheduled job to change the setting to ON just...

Recreating the clustered index will not move the actual table. It will only move the location of the clustered index. To move the table to a new location you have...

There was initially a 'bug' in SQL 2005 where the default of PAGE_LOCK was OFF. With SP2 this setting was corrected and set to default ON. So be sure that...

Did you refresh the list of jobs in SSMS? Try if restarting SSMS will solve the issue.

Are you enable to view the properties through a Remote Desktop (or physically) on...

In the WHERE clause of your query you define AND operator. That will show results of it matches results from all three views. If you need the result of every...

Maybe you can find something on http://www.microsoft.com/technet/scriptcenter/default.mspx

SQL: http://www.microsoft.com/technet/scriptcenter/scripts/sql/default.mspx?mfr=true

Cluster: http://www.microsoft.com/technet/scriptcenter/scripts/ccs/default.mspx?mfr=true

Else I suggest you ask this on a developers forum.

There is no such way to determine last access to a database. You can set up a profiler trace that logs all connections to a database. When nothing is logged...

You can just start of the installation. It will first execute a check about the current configuration and display any errors and warnings found.

Looks like you refer to a download of March 2007. In that case download the most recent file from Microsoft site and apply this to your server and workstations.

Most people...

It doesn't matter when you downloaded the SP2. The file is still the same.

Remember to apply SP2 on the server as well on each workstation you have SQL (client) installed.

What...

I have the same IMPROVEMENT of performance from the same query running on SQL-2000 (25 minutes) and SQL-2005 (45 seconds). The query includes a DISTINCT and an ORDER BY. My...

a simple google search for --sql server performance monitor counters-- will give you a lot of hits.

for instance:

http://www.sqlservercentral.com/articles/Administering/performancemonitoringbasiccounters/1348/

http://www.windowsitlibrary.com/Content/77/15/1.html

Are you sure the changes are committed?

We had a similar problem and found the application had some issues with opening/creating different connections (SPID's). After some time the 'old' connection timed...

can you be more clear? I don't understand what you want.

If you need to change an update/insert statement you can use an INSTEAD OF trigger (see BOL for explanation).