Simon Sabin


SQLServerCentral Article

Enums in SQL Server

SQL Server MVP Simon Sabin brings us a very interesting article on a possibilltyfor using enumerated values instead of integer or other coded foreign keys. It is an interesting idea that could go a long way towards making code easier to read.

3.5 (4)

2007-08-28

10,863 reads

SQLServerCentral Article

Large Object Data

Dealing with text, image, and other large object data types can be confusing for many people, in all aspects of working with them. However one place that is important is performance. SQL Server MVP Simon Sabin brings us a few thoughts on improving performance with these columns and the Text in Row setting.

2006-10-04

5,959 reads

Technical Article

sp_ServerStatus

Have you ever wanted to check that a server exists before using it. Here is a solution that use SQLDMO from within TSQL to get the status of a SQL Server service. It also works for 2000 instances. I have named it sp_ServerStatus for it to be based in master.This returns the status integer and […]

2002-11-14

585 reads

Technical Article

sp_xml_PrepareDocumentFromColumn

Do you want to use OPENXML with an xml document in a table, this procdure will do it for you.Pass in the SQL that will return the column of data, it will return the document handle which can then be used with OPENXML.ExampleDROP TABLE TabCREATE TABLE Tab (doc ntext)INSERT INTO Tab VALUES ('' + REPLICATE('' […]

2002-11-14

513 reads

Technical Article

Function and SP to find if file/directory exists

This function and stored procedure can be used to easily identify if a file, directory or parent directory exist. It wraps the functionality of xp_fileExist but gives easy access to the directory and parent directory exist values.To use it the function pass in the file or path and either 'IsFile', 'IsDir' or 'HasParentDir' it will […]

1.33 (3)

2002-11-13

2,915 reads

Blogs

STRING_SPLIT Basics–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

By

As we all know there is already a lot of information available about SQL...

Read the latest Blogs

Forums

Migrate the SSIS Catalog in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate the SSIS Catalog in...

SQL Server Kerberos authentication from a Linux clients

By Louis Lam-391748

Hi All, I have a need to establish a SQL Server Kerberos authentication from...

Housekeeping of SQL Azure DB's

By NicHopper

Hi all, I have a question for you, as some move into the cloud...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers