My boss just found something on the Max Chunk Size in TechNet.

Reading or writing in small chunks causes a less optimized round trip to the server because a full...

We need a better description (preferably very detailed) of...

sqlcool (12/7/2008)

---

A developer asked me to give him permission to create DB in our local development server. But our company policy is not give permission.

1) How to give users...

Well, the issue is mostly one of maintenance and how much work you're planning to put into it. The two most important questions I see are:

Do you really want your...

Awwww. :blush:

Thank you, Jeff.

The backup commands of T-SQL do not have a place for user name and password for the folder level. Only for the backup access.

Sorry, but you can't implement that kind...

Oksana,

I just realized no one told you what RBAR stands for. @=)

Jeff coined the phrase. It's an acronym for "Row by Agonizing Row". That's what cursors do. They process information...

Most of my training...

Oksana,

Most DBAs actually have a big hate for cursors. There are very few good things that come out of them because, for the most part, they eat up processing power,...

Here's an article that might help with the decision process:

http://www.sqlservercentral.com/articles/Career/61543/

And just an FYI, if anyone wants to reply to my post on the cursor issue, PM me and I'll start a new thread so we don't get completely off...

Jeff Moden (12/5/2008)

---

One situation was / is...

Yeah, Jeff'll never hire me. @=)

Actually, I must point out that I've run into one or two...

Opps! I didn't realize there was a page 2 to this thread until after I posted. My bad. :blush:

Sorry, Guys. Didn't mean to reply to replies that were already made.

The issue is that the SQL login is just that: a SQL (non-windows/non-network) login. Because SQL Logins aren't mapped to domain accounts, they aren't able to see network drives.

Change your...