At times we copy a SQL Server database from one database name to another for testing or development. One thing that doesn’t change is the logical name: Using the following SQL script the logical name […]
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 found an example that used syntax where I could find the average based on a group count. In this case, the group by is the folder’s tracking id (ParentTracking_ID) assigned to the document. SELECT […]
When using query by example there are the known wildcard characters “*” or “%” and “?” or “_”; but, recently I stumbled upon a new wildcard known as the charlist. Wildcard Description * or % […]
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 […]