Can you check in table if ld.Description has some values other than NULL? Query looks fine otherwise.

Failed Backups for me too.

Yes. It's because of unrealistic project plan and communication gap between development team and business end users 🙁

1. Wargames

2. Hackers

3. The Matrix

#2. working in SQL Server PSS and seeing the issues come in and solving them

I love to get most out of what we have, try all available resources to overcome...

I think he wants to just go for truncate table :-P. hence no other option

🙂

Were you able to create poll as per your expectations?

Partitioning is required to optimize the performance of SQL Server database. If database contains very large tables, you may benefit from partitioning those tables onto separate filegroups. This technology, introduced...

Data Modeling, A Beginner's Guide By Andy Oppel

This book teaches you techniques for gathering business requirements and using them to produce conceptual, logical, and physical database designs.

SQL Server 2008 R2 has additional option to Generate script with data. Helps a lot in cases 🙂

http://www.w3schools.com/sql/ is a good site to start with.

You may use dynamic SQL statements. something like,

--@schema is parameter

Declare @val1 nvarchar(500)

SET @val1 ='Select * from ' + @schema+'.'+'TableName'

execute(@val1)

Try DBCC command to shrink database files.

Refer: http://technet.microsoft.com/en-us/library/ms190488.aspx

Which authentication are you using? If you have logged in using SA, ensure SA has full permissions on the folder.

Are you running the query from a saved file? I mean the query is saved in an .sql file? Check if the file has Read-only attributes.