Lynn is correct, use with Standby.

http://msdn.microsoft.com/en-us/library/ms188223.aspx

The default data path is stored in the registry. Here are some answers, but it's the one that reads the registry that you want

http://stackoverflow.com/questions/1883071/how-do-i-find-the-data-directory-for-a-sql-server-instance

You can't change the primary filegroup AFAIK. You can change the default filegroup. (http://msdn.microsoft.com/en-us/library/aa933074%28v=sql.80%29.aspx)

http://www.mssqltips.com/sqlservertip/2601/using-multiple-filegroups-for-a-database-and-changing-the-default-filegroup/

If you are trying to move to a new disk, detach the database, move the files, attach...

It very much depends on your business, but I can give you a few things I've seen people use.

1. AlwaysOn Availability Groups - Get some HA and offload reporting in...

It's not a simple thing to debug and trace down.

SQL Server can run fine under virtualization, but you have to understand that configuring xx resources for a VM doesn't mean...

Check this: http://msdn.microsoft.com/en-us/library/ms190673%28v=sql.105%29.aspx

I'd also make another backup of the source database, ASAP.

FunkyDexter (5/7/2013)

---

I think it's a "right tool for the right job" scenario. Most of the folks who object to putting data in the cloud are thinking about mission critical...

I'd try to copy this file and restore it on another system. I suspect your file might be corrupt.

The full backup isn't backing up the log, unless the index rebuild is running while the full backup is running. Then it will catch items changed during the data reading...

Some of this is on the list. I've bumped it up a bit.

BOL doc: http://msdn.microsoft.com/en-us/library/ms188365.aspx

Microsoft recommends using Sharepoint, and that seems to be what they expect: http://msdn.microsoft.com/en-us/library/ee637439.aspx

http://msdn.microsoft.com/en-us/library/hh231687.aspx

You can also just send the powerpivot files over as these are Excel files: http://msdn.microsoft.com/en-us/library/ff628113%28v=sql.100%29.aspx

Nice playlist. I've only seen 2 or 3 of those, so I'll have to watch the rest.

Is not > '' working?

CREATE TABLE MyTable

( current_point VARCHAR(20)

)

;

INSERT MyTable SELECT 'Test'

INSERT MyTable SELECT ''

INSERT mytable SELECT ' '

INSERT mytable SELECT NULL

GO

SELECT * FROM mytable

-- 4 rows

SELECT *...