Thanks for answering the questions. Given that this only affects yourself, other users are okay and there is no issue when you use SSMS within a RDP session on...

Yes null columns take up space, you can potentially however reduce this overhead using sparse columns:

https://msdn.microsoft.com/en-us/library/cc280604.aspx

jwanutt (7/7/2015)

---

I am trying to connect to an sql server instance that is on a desktop machine running windows 7 Pro form a laptop running windows 7 Pro using ssms...

Thanks for the clarification.

To try and narrow down the problem can you answer these questions:

1. Can you remote desktop onto the server that hosts the SQL server instance that you...

Michelle-138172 (7/6/2015)

---

We are in the process of moving existing clustered SQL server databases to AWS. There is one major database that has intensive reads and writes transactions. I'm wondering what...

By this statement do you mean you are running 13 SQL server instances on your own PC? "There are total 13 SQL Servers in my work station."

If so what...

I agree with what your saying IF the OP was using a regular shared folder, but the question they have posted is using a UNC path to a folder that...

Yes it should, although not exactly the same situation we had our publisher running SP3 for a few days while our subscribers ran SP2 as we could not upgrade...

Have a read of this, no point in me regurgitating it. Usually its down to memory pressure or IO:

http://www.mssqltips.com/sqlservertip/2827/troubleshooting-sql-server-resourcesemaphore-waittype-memory-issues/

SQL Surfer '66 (7/2/2015)

---

Which account is running the job? SQL Server Agent account? If it's a domain account you need to assign permissions on the path/share/directory to that account.

If SQL...

I wouldn't say its a fad, but its definitely still in the infancy period. We currently use DynamoDB in Amazon Web Services and MongoDB in on site solutions,...

Sam77 (6/30/2015)

---

I am trying to delete sql backup files under UNC path from one server to another server. I am getting an error message - An object at the specified...

The transaction may not originate in tempdb though. You will need to repeat this in your user databases also.

In transactional replication I don't believe they are, however if someone can prove me wrong that's fine.

For statement delivery the only article options are INSERT \ DELETE and UPDATE. ...

Can you run DBCC OPENTRAN? Does it report any open transactions?