Glad to hear it.

Use dynamic SQL. See:

sp_executesql and

Using sp_executesql

It is normally best to grant the SQL Server process the 'lock pages in memory' right, so SQL Server can use non-paged memory.

If this is Standard Edition, please read the...

Wayne,

Nice idea, but I have to say that is the least efficient in-line tally table I have ever seen!

Compare:

CREATE FUNCTION [dbo].[GetNumbers]

...

Confusing. As posted, the CREATE TABLE statement will not compile since column PKey, referenced in the PRIMARY KEY definition, does not exist. Errors like this cannot be caught...

There are a number of examples here:

http://www.regular-expressions.info/examples.html

http://regexlib.com/DisplayPatterns.aspx?cattabindex=2&categoryId=3

Not directly, you have to write some code 🙂

Lots of examples and performance comparisons here.

The best way is to avoid loading data in that format to begin with, of course....

Use CLR integration.

See this MSDN magazine article: http://msdn.microsoft.com/en-us/magazine/cc163473.aspx

That is not a table structure, it is just a bunch of text. If you...

Didn't realize anyone was still using VB for this, now that we have the choice to use C# 😛 😉 😀

Since this is SQL Server 2008 x64 Standard Edition, it seems you are suffering from paging of SQL Server memory.

See http://support.microsoft.com/kb/970070 for the fix that allows x64 Standard Edition to...

Just posting to confirm that

DBCC FREESYSTEMCACHE('TokenAndPermUserStore')

...works correctly in SQL Server 2008 Enterprise version 10.0.2757

adnan.fast (3/22/2010)

---

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog...

There is no direct way to do exactly what you want, since TRUNCATEONLY never shrinks the file below its creation size, as you said.

Your best choice depends on the data....

SwePeso (3/21/2010)

---

david.c.holley (3/19/2010)

---

Is there a way to do this AND allow Nulls? In other words, the when the WindowsUserId is provided, it must be unique, but it may not exist...