In SQL Server 2005 by default users of a database that are only in the public role cannot see the definitions of an object while using sp_help, sp_helptext or the object_definition function.
2018-08-22
3,287 reads
2013-11-11
1,824 reads
This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.
2011-10-25
6,614 reads
Setting up multi-node clustered SQL instances from scratch is common practice for companies that want to implement high availability, but adding a new node to an existing clustered SQL instance that has been running for a while may have a few sticking points, especially for a SQL 2005 instance.
2011-10-12
2,577 reads
To merge data in SQL 2005 from various table, we do not have a MERGE function as in SQL 2008. The following script gives an alternative approach of implementing in SQL 2005
2011-06-15 (first published: 2011-06-03)
1,464 reads
2011-03-01 (first published: 2011-02-18)
4,045 reads
Microsoft completed SQL Server 2005 Service Pack 4 recently and made it available at the end of last week.
2010-12-20
4,684 reads
2010-11-03
2,943 reads
2010-10-04 (first published: 2010-09-29)
2,938 reads
2010-09-22
3,331 reads
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
Comments posted to this topic are about the item RegEx Functions III
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Comments posted to this topic are about the item Finely Tuned Models
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers