Database Index Checker
Often we send a database to a client and then later on find out that a key got dropped or an index removed along the way… Well, now we can easily test this! Open up […]
Category: Database
Database technologies and vendors.
Generate Sequential Data Padded With 0
We frequently have to generate location or item codes for clients. This is typically a sequential number that has multiple levels in the code. For example, there are 4 carousels; each carousel has either 23 […]
Windows 8 User Account Types and SQL Server
My computer is not part of a domain., but rather a member of a workgroup. You can still use Windows Authentication for things like file sharing and accessing Microsoft SQL Server instances. All you have […]
Query by example: the charlist wild card.
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 % […]
Cleanse the Database!
You would clean up the physical files…. Many of the same problems exist in the database. Incorrect information, incomplete information, missing required information, not enough metadata to classify, corrupt data, out of date information, incomplete […]
How to find rows where a column contains a number
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 […]
…it is not contained in either an aggregate function or the GROUP BY clause
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. […]
Export to Excel from SQL Server
I often find myself needing to take data from a SQL query and give it to another person. SQL Server Management Studio (SSMS) does have the ability to right click in the results grid and […]
SQLCMD: MS SQL Server’s Command Line Interface
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 […]
SQL Server Linked Server
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 […]