< Shrug > Out of my area of expertise. Absolutely no idea.

Anything interesting...

kathyoshea (1/6/2009)

---

Create a new multi-statement table-valued function.

Select the data and use the order by in the loading of the table that is returned.

This works in all the testing I've done....

IO sub-system glitch? It's pretty much the only thing that comes to mind.

I assume there's all sorts of errors in the error log about 'cannot open file', etc.

Got a...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic630817-266-1.aspx

tfifield (1/6/2009)

---

Gail,

Wow! I never thought about the parallel problem. It gets uglier all the time. I'd have to tweak MAXDOP in order to guarantee that it was...

The source for an insert can be either VALUES or SELECT, not a combination.

Try this:

INSERT INTO tblProject...

In 2005/2008, the inserted and deleted tables are materialised from the row version store that's...

In that...

Marios Philippopoulos (1/6/2009)

---

DECLARE @ActionType char(1)

SELECT @ActionType = CASE

...

SELECT OBJECTPROPERTY(Object_ID('TableName'),'TableHasPrimaryKey')

Or, if you want to check all the tables.

SELECT name, OBJECTPROPERTY(Object_ID,'TableHasPrimaryKey') FROM sys.tables

It's hard to recommend a script to auto-generate primary keys, because the question is, what does the...

Grant Fritchey (1/6/2009)

---

I used to have a 100-sided die. Great novelty, but the stupid thing would roll across the street before it stopped and it was hard to tell which...

Greg Edwards (1/6/2009)

---

At some point, I have to ask the dumb question to Gail :w00t: - the more sides, the more precise the answer? or the more likely to...

Which edition was that? I know...

Please post table definitions and sample data. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

mark (1/6/2009)

---

Or do something sane and calculate the maximum amount of wait time your users are willing to tolerate, determine the amount of space Sql Server can initialize in that...