DateAdd is a SQL Server function so that why your query doesn't like it. Try looking through the ref link for Date/Time functions for DB2.

Ref: http://www.ibm.com/developerworks/data/library/techarticle/0211yip/0211yip3.html

Thanks.

You tried to figure it out that counts worth alot :). Best way to learn, but sometimes it is easier to ask.

The "a" after the SQL statement are alising...

Memory issues can lead to high disk IO which can lead to lagged reads/writes. Depends on your database throughput :).

Thanks.

Yes Cluster Index leaf node has the data; another characterisc about cluster indexes is it physical sorts the data by the index key. So sometime people don't like creating...

Read http://www.sqlservercentral.com/Forums/Topic673040-65-1.aspx#bm673605 post by Gail she explains affects of (nolock) and how you can get duplicate records :).

Mohit.

Edit: SPELLING .... *dies*

2) Yes you can, but if you don't it can have affect on server. How much memory do you have in the server? Ideally Windows Servers should ave...

Ha Do'h those dam things always getting in the way :D. Thanks for letting us know :).

Mohit.

climbingbum (3/11/2009)

---

In case of a restore the answer I have been given is to perform a backup if the server is accessible. If the server is in a state that...

I think only moderators can delete; ask Steve to do it :D.

Please ref http://technet.microsoft.com/en-us/library/ms191140(SQL.90).aspx on how to use certificates with Mirroring...

Thanks.

Remote connection setting?

Server Properties

-> Connections

-> Allow remote connections ..

or

sp_configure 'remote access'

Thanks.

By default SQL server chew up to 1.7GB of ram from the physical memory. So even if your database is small; what it is doing is building up the...

To add to Matt, it will only show data that was at 1PM in your database. But any data that hasn't changed since 1PM and you doing analysis on...

Most people I know like BackupExec (Server Guys) because they don't like the idea of file backups going to disk then to tape. They rather have it go directly...

In SQL 2005 I recommend using SQL Server Profiler.

Create a new trace and select following event:

Errors and Warnings

-> Blocked Process Report

Make sure "Show All Columns" is selected.

This gives you very...