Use the LOGINPROPERTY method to find all the infos you need (http://msdn.microsoft.com/en-us/library/ms345412.aspx).

The replicate command truncate to 8000 characters if you are not using varchar(max) or nvarchar(max).

If you use varchar(max) it works fine though:

select len(replicate(convert(varchar(max),1),8005))

Output: 8005

You need an Enterprise Edition (or Developper), partitioning and data compression are not available in Standard.

Paul White NZ (10/4/2010)

---

Oliiii (10/4/2010)[hrIt looks like it knows that even though the record is held by an exclusive lock, it hasn't been modified yet so is not yet dirty...

Doing a REBUILD (or recreate) of a clustered index always uses up a lot of space.

One way around this is to REORGANIZE it instead, this does not increase the data...

If all you need are enough data to know how/if you need to virtualize it, you can setup a perfmon trace and either save it to a file and then...

I've read a bit more about it on BOL and here is what it says :

READ COMMITTED is the default isolation level for SQL Server. It prevents dirty reads by...

vinothr 33504 (10/3/2010)

---

Hi all

I am having a table with columns say A to F. A being the primary key, B unique key. I am creating clustered index on...

Try with exclusive lock (xlock) as an updlock can still be selected (but not updated).

If you want your log to shrink after the backup you can add a step to shrink it, but if it's going to grow again during the day you'll just...

Try this on each dbs:USE [Datasae1]

GO

EXEC sp_addrolemember N'db_ddladmin', N'testuser'

EXEC sp_droprolemember N'db_owner', N'testuser'

GRANT EXECUTE TO testuser

You have to do it on each DB since you handle the DB security at the...

It doesn't change the schema to dbo, it changes the owner of the schema to dbo, you'll still have both your schemas and your user will be free to be...

Add step to the backup job to compress the backup and a step to the restore job to decompress it.

Log backup are very easy to compress so you'll make everyone...

It looks like a good sata drive, good stable overall performance.

But you have to compare it with other drive to have some kind of baseline.

No need to run so many...

I'm definately not an expert on reading stack dump, but it looks like your server ran out of memory.

Not enough memory can keep the server from accepting new connections of...