Recent installments of our SQL Server 2005 Express Edition series have been discussing its implementation of Full Text Indexing. This article focuses on the remaining two constructs, CONTAINS and CONTAINSTABLE.
2010-01-20
2,182 reads
Simple bugfixes of another script found on this site.- bug 1 - Puntuation (dot) in database names made the script fail.
2007-08-21 (first published: 2007-02-04)
323 reads
This script will quickly generate DML to search all the tables in the current database for a given string. It could be modified to execute the generated code if desired. If you are running this in a
2007-01-23 (first published: 2007-01-04)
2,933 reads
The below command will rebuild all indexes on a database.We need to run the below command in the context of each database that is of interest.
2007-02-21 (first published: 2006-10-23)
1,209 reads
the following scripts helps in finding top 5 missing indexes using the new feature of DMV available in SQl Server 2005
2007-07-19 (first published: 2006-10-23)
5,336 reads
Display Dates as rows between Specified Date Range.
2006-11-07 (first published: 2006-03-22)
547 reads
The one about usr and pwd was just "best practice" advice -> code clarity and readability. regards, chris.
2003-07-07
Only if the Sql logins already exist on BOTH servers with different SID's. If you bcp the info over (or any other method) that preserves the SID, then everything works, period. Andy
2002-04-17
Well there are lots of methods to deal with this, however to save you a lot of troubles you may want to setup an import table to do your scrubbing then move to the main table. But the basics of finding duplicate goes soemthing like this SELECT COLUMNS FROM tblX HAVING COUNT(DUPICATETOCHECKFOR) > 1 GROUP […]
2002-04-16
Not sure about this one, but there were lots of changed to OLAP in SQL 2000 and I suspect the DTS task changed. Not sure if you can automate a change here. Steve Jones steve@dkranch.net
2002-04-16
2 reads
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers