Free Training

Technical Article

RE: re-index

  • Reply

Andy, According to the article at http://www.sql-server-performance.com/statistics.asp : "If the number of rows in a table are greater than 6, but less than or equal to 500, then statistics are automatically updated when there have been 500 modifications made. If the number of rows in the table are greater than 500, then updates are automatically […]

2003-07-28

1 reads

Technical Article

RE: Identity Function Problem

  • Reply

Testing in SQL2000, it does not even allow a variable when used with the IDENTITY function. You could do something like this, however. exec ('select field1, IDENTITY(int,' + @val1 + ',1) AS [ID] into #temp_list from table2 select * from #temp_list order by [ID]')

2003-07-23

Technical Article

RE: Recursive instead-of-delete triggers

  • Reply

The example can trace 'American family back to the Revolutionary War'. Quote from the article. Done the lineage stuff in 6.5 but the lineage storage (varchar(255)) was a problem because of the key sizes used for the parent/children relationship. With SQL 2000, 8000 characters one should be fairly safe. Lastly, I am a big fan […]

2003-07-21

1 reads

Blogs

Speaking at SQLSaturday MN 2022

By

Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Goal Progress for Nov 2022

By

I set goals at the beginning of the year, and I’m tracking my progress...

PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?

By

Very excited to take part in my third #PGSQLPhriday blogging event, even more so...

Read the latest Blogs

Forums

Windows login Token-based server access validation failed with an infrastructure

By Raja mssql

Hi All, One of our windows login is not working which is been configured...

Subtract calculated columns

By pedroccamara

Hello all I am sorry to bother but I really can't find the solution...

Help Parsing String

By Tav29

I can do the Last Name, First Name; my problem is Middle Initial. I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers