One ambiguity overhere:

- are you talking of white spaces in the column names ?

- are you talking of white spaces in the columns content ?

To alter the column names, you...

There is a reason for the dependency of sqlserver instances vs drives !

Why are you tempted to avoid this dependency ?

One of the most important advantages of filegroups comes from a DRP context.

Partial availability: (EntEdtn / DevEdtn)

The only thing of a db you need is the primary filegroup ...

If you created your new non-clustering index without specifying a filegroup, you should see a parallel execution for that query, because will actually put this index on a per content...

Your issue ( select max(the_clustered_pk_column) ) is the cause of your huge consumption.

It actually performs the full clustered index datapage level scan !!!!

This is an issue of SQLServer in the...

Lowell (6/3/2009)

---

ALZDBA the version you posted has all the CrLf stripped out, making it difficult to test,...

Attached you'll find a version I use for quick and dirty CPR-trace 😉

I didn't kill the sqlserver service !

I dropped the event service (sqlserver object).

DROP SERVICE S_Logon_Events_Service

There was a huge backlog because I defined to few quereaders.

I played a bit with SSB .... monitoring is the big issue.

I use SSB to track some sqlserver events. (logins, failed logins)

I must state that in a single case of...

- Why do you think you need the cross join ??

- What's the relationship of that x-joined table to the other tables ?

did you read these good blog posts ?

By Jimmy May:

http://blogs.msdn.com/jimmymay/archive/2009/03/01/disk-i-o-microsoft-sql-server-on-san-best-practices-from-sql-cat-s-mike-ruthruff-prem-mehra.aspx

http://blogs.msdn.com/jimmymay/archive/2009/03/15/case-study-classic-case-of-san-over-subscription.aspx

just make sure they don't encrypt everything.

That would be total overkill !!

Every column that gets encrypted will be converted (implicit) to varbinary(max) !!

These columns cannot be indexed,....

Also mention, you...

veritas_86 (5/26/2009)

---

so I am creating a database where I have a parent table with multiple columns that I would like to have reference a single column in a child table....

at MS

- the general page: http://www.microsoft.com/sqlserver/2008/en/us/default.aspx

- "Upgrading to SQL Server 2008" msdn.microsoft.com/en-us/library/bb677622.aspx

Helps you with preparing and planning your migration

- "Microsoft SQL Server...

actually, you don't need another sql instance.

You might as well just create a new userdb (tools) and export your data from master to your userdb.

After that, it may be best...