Something that drives PLE is the need to bring data into memory when queries scan large tables.

If you have several tables that are larger than available memory and you run...

SQL Server Books online should be able to answer most of your questions.

Read-Only Filegroups and Compression

http://msdn.microsoft.com/en-us/library/ms190257(v=sql.100).aspx

Did you investigate to see if the queries are actually being blocked?

Inserts can still cause problems with read uncommitted isolation, so you would be better off staying away from it.

If...

Many types of blob data are already compressed, for example, a .PDF file. Other types of blob data are not compressed.

There is no tool that can compress data that...

At a certain point, you have to look at security vs. utility. The safest airplane is one that never leaves the ground, but it's not very useful.

There is no...

Your error sounds like an SSIS error, not a TSQL error.

This is a TSQL solution:

select

TrimmedString= right(DT,19),

[Date]= convert(datetime,right(DT,19))

from

( -- Test Data

select DT ='Mon Jan 4 15:50:49 2010'union all

select DT ='Tue...

Besides removing duplicate indexes, you should also look at removing unused indexes.

People often create indexes without knowing what the index will do for them, so they just use space, CPU,...

Is SQLIO failing on the step where if first creates the workfile, or on a later step?

As another type of workaround, you could let SQLIO create the workfile on a...

You can probably only get help if you show the SQLIO command being executed, and the contents of the param file.

Also, did you verify that the C drive has enough...

And since your running BCP from the CMDSHELL, remember that the c:\test.txt file will be on the server you are running it on, not on your PC.

You just have to give SQL Server enough memory to hold the entire database in memory, and it will take care of the rest.

Rob-350472 (1/30/2012)

---

What are the implications of setting "READ_COMMITTED_SNAPSHOT" to ON rather than OFF (the default)?

I seem to recall looking into this before (ages ago) because it sounded attractive but...

I worked at a company once where they did a survey of IT workers and end users to see how IT was doing. The senior IT management thought that...

I mostly agree with this, except that...

You need to see how the tempdb space is being used.

Run these queries to check the current usage.

print 'Check usage of tempdb'

select

[Version Store Pages Used] =

sum(version_store_reserved_page_count),

[Version Store Space MB] =...