Nicholas has stated it as I would. You want to concentrate on the logical reads, since lowering those lowers work. You can't control the physical reads, unless you can load...

The copy piece isn't a part of anything native in SQL Server. Some third party utilities, like SQL Backup Pro from Red Gate, will do this, but you have to...

Slightly jealous of Ray. He lives close enough to Yankee Stadium to get to a game for the day, and he meets Mr. October. I still remember the 3 HRs...

Visible proof

SSPI is a security/kerberos error. Search for it and you should find a few things to check. Often it's something to do with the service account and creating an SPN...

SQLPhil (7/2/2012)

---

Sometimes in order to achieve the big-bucks salaries you have to make sacrifices along the way. I know a couple of people who wanted to break in to...

If you mean can you build a Windows/SQL cluster in a VM, yes. That's what is running the SQLServerCentral servers.

We have two virtual machines running Windows 2008 and SQL Server...

You can add another file, which will help spread the load, but you will continue to add some data to all files.

You can grow the size of the files manually,...

There is no function to do this, but you can write one using the PATINDEX/CHARINDEX functions and SUBSTRING.

The two links posted above work. There are also versions in some mobile stores. I have a port for iOS and for OSX as well.

GSquared (6/28/2012)

---

So long as you can access Dropbox (or...

GA Programmer (6/28/2012)

---

Having a unique password and/or login to every site is one of those eggheaded ideas that sounds great on paper but has no real practical application in...

paul.knibbs (6/28/2012)

---

The one problem with using KeePass is that it's fine if you're only ever using these passwords from the machine where your password database is stored. Becomes more of...

Glad you liked it, but I can't take credit for discovering this. Mr Randal, of SQL Skills, taught me this. Now I really want to get to one of his...

In the URL you posted (http://msdn.microsoft.com/en-us/library/ms151763.aspx). A few paras down there is:

"For information about how to configure the components that are required for Web synchronization, see Configure Web Synchronization, Configure...