If you need to test to see if the current user has access to a database, use HAS_DBACCESS.

Certainly would. Of course, you would need a second script to loop around all the...

:sick: XML string-splitting and a multi-statement user-defined table-valued function with a WHILE loop? :sick:

Ouch!

I'll say it again. XML is the...

Much more fun that way, yes!

I remember seeing this thread - I noticed that Lutz had answered...

You are welcome.

XML really is a very poor choice for splitting strings. It is hard to do worse.

See http://florianreischl.blogspot.com/2009/09/high-performance-string-split-functions.html for the results of some very extensive testing we did right here...

It depends, and it is not really something you have much control over anyway.

The following document discusses how to measure performance, and where to focus your improvement efforts.

Microsoft White Paper...

Books Online: ALTER INDEX (Transact-SQL)

Table locks are...

David Nash-367764 (3/17/2010)

---

What I meant to say when I said it's not a poorly performing query is that the sql generated is very efficient. The query itself still takes too...

But then the constraint will be marked as untrusted, and will not be considered by the optimizer.

The...

bobmclaren (3/16/2010)

---

I have been provided a server that is maxxed out at 6 disks. When deciding how to arrange the disks, which is the lesser of two evils?

A) Two...

As you may have guessed, that text is copied from Books Online (the SQL Server help system).

See http://msdn.microsoft.com/en-us/library/ms180797.aspx, and its references.

I still think your problems would diminish, if not disappear entirely, if you just use the correct data type.

Andrew Gothard-467944 (3/16/2010)

---

Well, you can ...

On rare occasions it may even be a good idea. However,...