Felix De Herrera (9/10/2008)

---

Good points guys. Primary Keys IMO should always be non-nullable. This is an absolute must. FK's, eh... not so much depending upon the usage...

If the data is needed for DRI - you can't leave it up to the front-end to make those calls, nor can you enforce that from your front-end alone (as...

I wouldn't know about characterizing it as "normal practice", but I certainly do use it.

I use that setup for things that are required from an end-user, but are needed from...

Gary Johnson (9/9/2008)

---

SELECT INTO will often times be significantly faster. BUT it locks up the sysobjects table while it runs. So, if you have any other SPs or scripts(that need...

Then use the starting point Chris gave you with the Tally, and use that as a "base table", excluding the first and last "new rows" based on the initial rowID....

Sure - here's a good article on it:

http://www.sqlservercentral.com/articles/TSQL/62867/%5B/url%5D

Interestingly enough, most of the "non-enforceable" non-compete agreements are too vague and essentially lock someone out of doing work in their primary area of expertise. That's the main reason...

Have you looked at the reports included in SP2 of SQL Server 2005? There are a series of reports having to do with table size, which should give you...

Reverse would give the correct results assuming the patterns are close enough. Tally table is another option.

I'd probably go with a CLR function though (would likely be...

create table #matt( id int identity(1,1) primary key,note varchar(30))

insert into #Matt(note)

select 'a101' union all

select 'a101' union all

select 'a101' union all

select 'a1,01,' union all

select 'a101' union all

select 'a1,01,'

go

SELECT note,

...

Chris Morris (9/8/2008)

---

Does it work? What's it supposed to do? It doesn't return results where ',[0-9][0-9],' is in the rightmost part of the column...

SELECT note,

PATINDEX('%,[0-9][0-9],',note) AS A,

PATINDEX('%[0-9][0-9]',note) AS...

It sounds like you have a working solution, but if you want to pursue tracking down the scenarios it doesn't work in, let me know what an example might be....

All right... Sorry it took a little while - but here goes...

On 2 million rows, the running totals version returns the sequences as I understand them... in 35.3 seconds. ...

bcronce (9/4/2008)

---

It is my understanding that nolock only helps when you have a write lock on a row/table. C# has something simular for accessing objects in a multithreaded environment. You...

Messy, yes. Impossible no. With a temp...