The cluster index will help you manage free space far batter than you can at present, and having a CI may also improve your performance.

There is no way an outsider...

There are a few SQL experts and some PSS engineers who suggest setting the pagefile to zero on a 64-bit box that has memory in double-digit GBs. The rationale...

Even if you uninstall CU6, you may not get rid of all traces of it. Many CUs update the system tables, and I doubt the uninstall will always be...

Not all database systems support the concept of a cluster index. Therefore if you have a 3-party app that was written to work on a number of database systems,...

In 64-bit Windows, SQL Server thinks the total amount of memory available is the total of the physical memory plus the size of the page file. Therefore if you...

There are many cheap NAS boxes available, but all that I have seen appear as a network drive to Windows. This means they are no use for testing clustering.

One...

Let's assume this becomes the standard way of living in 'developed' countries.

There is no way your life log could not be hacked, either by government or by criminals....

Hahahahaha I was laughing waiting to see Gail's reply!

You can get SQL Agent on SQL 2008 Express Edition to start. You need to set up account rights and enable the agent XPs.

But as soon as it...

We have had a number of questions which included a deliberate spelling error that had an answer xxx is wrong because it does not exist. As far as I...

Did you check the memory use when you are running backups and other batch processes? You need to set your max memory use to take these into account.

If you...

One of the fundamental design criteria behind the ODBC standard is the ability to run ad-hoc queries. In order to do this, the ODBC driver needs to access certain...

I have experienced similar problems when memory has been under perssure.

The OP said they have a 16GB box with 13GB allocated to SQL Server. This may be OK in...

I misunderstood what you wanted to do. I'll try to think of a way to hide the system tables.

When I run the script in Piotr Rodak's post at http://www.sqlservercentral.com/Forums/Topic541937-146-1.aspx it works for me. When 'testu' is not a member of [no_schema_view_role] it can see details of user...