Simon Sabin


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,080 reads

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,953 reads

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

583 reads

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

510 reads

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,844 reads

Blogs

2020 Advent of Code–Day 1

By

This series looks at the Advent of Code challenges. I started the Advent of...

Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)

By

Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...

One Chart at A Time Video Series

By

Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...

Read the latest Blogs

Forums

How to find index usage by stored procedure?

By SQL Guy 1

Hi all, We have 2 DMV's: sys.dm_db_index_usage_stats sys.dm_exec_procedure_stats And they don't look they can...

Odd things with Report Builder (also tried VS 2019)

By kevlray

This is kinda hard to explain, maybe I can make sense of it. So...

PBM policy to check empty passwords

By Lou

Dear friends, Please, could you give me some ideas, how to implement SELECT count(*)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers