Simon Sabin


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.

You rated this post out of 5. Change rating

2006-10-04

5,985 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 […]

You rated this post out of 5. Change rating

2002-11-14

591 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('' […]

You rated this post out of 5. Change rating

2002-11-14

514 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)

You rated this post out of 5. Change rating

2002-11-13

3,528 reads

Blogs

Announcements from the Microsoft Fabric Community Conference

By

(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...

The Basics of TRY CATCH Blocks–#SQLNewBlogger

By

I was working with a customer and discussing how to do error handling. This...

Working with ALS – Insights from the Ability Summit

By

The 14th annual Ability Summit is a global event that I attended a few...

Read the latest Blogs

Forums

Basic SQL Query question

By jjevans

Hello, I was given this SQL question and was hoping someone could please help...

Different logical drives in 2024?

By kevin.j.sexton

In recent days past, there was a Performance gain by placing data files, log...

Using data returned from sql

By kelly.fergus@gmail.com

Ok, I've come up with another problem in my project. I am happily pulling...

Visit the forum

Question of the Day

Backing up the Resource Database

How does the Resource database in SQL Server 2022 get backed up?

See possible answers