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.
2007-08-28
13,102 reads
SQL Server MVP has been working extensively with SQL Server 2005 and one of the less well known features: Service Broker. In this short article, we continue definitions of the terminology you'll need to know to work with this subsystem.
2007-04-18
4,210 reads
SQL Server MVP has been working extensively with SQL Server 2005 and one of the less well known features: Service Broker. In this short article, we get an introduction to some of the terminology you'll need to know to work with this subsystem.
2007-04-17
5,435 reads
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
6,055 reads
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
646 reads
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
561 reads
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 […]
2002-11-13
3,915 reads
The procedure copies one stored procedure from one database to another one
2002-11-12
757 reads
This script will list the spaceused by all tables in a database. You can order the output by changing one of the parameters.It also provides totals
2002-10-27
708 reads
The script allows you to prepare an xml document as you would use the sp_xml_preparedocument but by specifying a SQL statement. i.esp_xml_preparedocumentfromcolumn @iDoc OUTPUT, 'SELECT TOP 1 documentColumn From myTable'
2002-10-12
601 reads
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Comments posted to this topic are about the item The Hidden Security Risks of...
Comments posted to this topic are about the item The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers