david.sims (7/23/2008)

---

I have never written a stored procedure before and need someone to tell me that I am not doing something completely wrong before I blow up our database. We...

The backup files can have any name or extension you want. Using .bck will work fine and you won't have any issues with it.

Lookup aggregate functions in BOL.

Note: if you are not running Enterprise Edition, locking pages in memory will not have any effect. The Standard Edition cannot lock pages in memory.

Matt (7/23/2008)

---

Michael Earl (7/23/2008)

---

It will depend on some of the deatils of the requirements.

It has been my experience that complete real-time is often not really what is needed (or even...

Tom Hamilton (7/23/2008)

---

I need to retrieve either a specific value or all records, depending if there is a match on the (integer) @parameter.

Overview:

Select Action from...

Milu (7/23/2008)

---

Hi All,

I have a table which has only one column "id" (int)and its become a default valued column, means it automatically insert "0" if value not inserted into it.

when...

Let's walk through each one of your concerns:

jobs, alerts, operators, linked servers, saved ssis (dts) packages, users, re-set up SQL Server Mail on the new server

Jobs - stored in MSDB...

It will delete all backup files that meet the requirements in the subfolders. So, if you have it setup to delete .bak files older than 1 day - that...

Verify the version on your client system. I am betting that your client software has not been upgraded to the correct version.

Both your server and the client need to...

jason.stephens (7/23/2008)

---

GSquared (7/23/2008)

---

My usual practice is to break up maintenance plans a bit. I'll rebuild some indexes one night, other indexes the next night, etc., and schedule that to...

It is not just 'dirty reads' that you need to worry about when using NOLOCK. There is also the issue of duplicate data being returned.

A good example is when...

Verify the version of the client on that laptop and compare to the version on the other clients.

Now that the new server is up and running, all you should have to do is:

1) Shut down the current production application

a) You...

You can also use COALESCE and NULLIF:

SELECT COALESCE(NULLIF(column, ''), 0) FROM table;

This...