rf44 (7/11/2009)

---

Answering "never, ever use a cursor" or something equally smart.

The poster did not ask for a personal opinion about cursors (even if it's a wise one), he asked for...

If the projects are for yourself and friends, I'd go wih express. I'd even say express if it would be a desktop app you might consider selling commercially. ...

Okay, but I won't know until Monday evening. I should hopefully be spending the day out on the pitch officiating games at the PPI up at the USAFA.

First, if there were two differential backups taken after the last full backup you are restoring and you want the data as current as the second differential, you only need...

Staffed?? There really isn't a whole lot of staff on SSC. Most of us give of our time voluntarily as many of us have our own full time...

What to do you mean? Question is a bit vaque and I'm not sure what you are asking.

You can accomplish this by highlighting the views you want to script in the Object Explorer Details tab, then right clicking on one of the veiws and selecting the option...

What is error you are getting and from where are you attempting to make the DAC connect?

Once the trace is setup, all the startup stored procedure needs to do is start the trace. It shouldn't have to be setup every time the server is restarted....

I'll have to research...

Timothy Ford (7/10/2009)

---

I would have to agree with Lynn. I see no problems here. If you would feel better limiting the memory for SQL I would set the...

I guess I'm trying to figure out what the problem is, you have 32 GB of RAM and SQL Server is only using 10 GB. Does not equate to...

What else is running on the server? Is it dedicated to SQL Server?

zenrigar (7/10/2009)

---

Oh then that was the trick, thanks alot for the explanation :w00t:

i also checked the link of your post and it was helpful too, now im curious about...

I'd have to Google those. I haven't looked at them. They are supposed to be able to read the transaction log and help recover lost data or database...