Creating a full-text catalog in SQL Server is easy, I used a tutorial on one of our favorite SQL Server blogs: http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/ I created 4 catalogs: Each catalog is assigned to a table and columns […]
I needed to pull out all rows where a user id was numeric, SQL Server (as of 2005) has a function IsNumeric: SELECT USERID,USERNAME FROM Users Where IsNumeric(UserID) = 1 ISNUMERIC returns 1 when the […]
I cannot tell you how annoying I find this error, and before you post a comment, I know it’s not the fault of SQL Server. I’ve asked it for something that is not logically solvable. […]
I know what your thinking. Why in the world would I want to manipulate the complex workings of MS SQL Server using the archaic command line? Before today I would have been thinking that right […]
Often you need to access data on a server that lives on a separate server. Fortunately SQL Server lets you create a Linked Server to join Server A to Server B. Once linked you can query against the […]