Tony Rogerson's ramblings on SQL Server - All Comments

Interesting Finds: March 14, 2010

Jason Haley — Sun, 14 Mar 2010 13:43:54 GMT

Interesting Finds: March 14, 2010

A Day in the Life of a SharePoint DBA

Code Capers — Fri, 26 Feb 2010 04:29:36 GMT

A Day in the Life of a SharePoint DBA

Application Performance: Open Session In View Design Pattern | Cirrus ABS

Application Performance: Open Session In View Design Pattern | Cirrus ABS — Mon, 22 Feb 2010 21:40:12 GMT

Pingback from Application Performance: Open Session In View Design Pattern | Cirrus ABS

re: Format query output into an HTML table - the easy way

redbeard — Mon, 08 Feb 2010 12:58:45 GMT

sorry my last comment was in wrong place

re: Format query output into an HTML table - the easy way

redbeard — Mon, 08 Feb 2010 12:47:24 GMT

hi i have one table with 7 fields two of the fields have a username and a text hyperlink value i am attempting to output to either html or php and the user name become an hyperlink the links are required for gaming gangs to enable them to attach each other... is this possible?

redbeard

Count number of words in a string

Madhivanan's TSQL Blog — Thu, 28 Jan 2010 14:30:17 GMT

Tony Rogerson in his weblog posted about Counting the number of words in a string Here are two more methods

Microsoft – Follow best practices – Part 2

SQL and the like — Mon, 25 Jan 2010 09:03:16 GMT

In addition to my previous post , another best practice is to not use NOLOCK and READ UNCOMMITTED transaction

Handy SQL Server knowledge nuggets « C# Hacker – The Rambling Coder

Handy SQL Server knowledge nuggets « C# Hacker – The Rambling Coder — Mon, 25 Jan 2010 04:40:54 GMT

Pingback from Handy SQL Server knowledge nuggets « C# Hacker – The Rambling Coder

Fillfactor & Indice su Identity

Francesco Quaratino — Sat, 23 Jan 2010 17:39:03 GMT

E' risaputo che per la manutenzione degli indici di database di grandi dimensioni è opportuno lasciare

How to create a One to One relationship in SQL Server using DRI, Triggers and Views

Tony Rogerson's ramblings on SQL Server — Sat, 23 Jan 2010 10:51:30 GMT

It's beyond me to create a one to one relationship in SQL Server if you are inserting directly into

Twitter Trackbacks for Dundee SQL User Group Meeting this Wed (20 Jan 10) - Tony Rogerson and Allan Mitchell - Tony Rogerson's [sqlblogcasts.com] on Topsy.com

Mon, 18 Jan 2010 14:07:25 GMT

Pingback from Twitter Trackbacks for Dundee SQL User Group Meeting this Wed (20 Jan 10) - Tony Rogerson and Allan Mitchell - Tony Rogerson's [sqlblogcasts.com] on Topsy.com

re: Padding a string with leading zeros

ValentinoVranken — Mon, 11 Jan 2010 11:32:56 GMT

Hi Tony,

Instead of using a string truncation function to get to the expected length, why not make it the expected size straightaway? It's one function call less and works just fine.

Here's what I mean:

declare @number int = 42;

declare @character char(1) = '0';

declare @expectedLength int = 8;

select REPLICATE(@character, @expectedLength - LEN(@number)) + CAST(@number as varchar(8)) as Result;

Regards,

Valentino.

SQL Server Event Notifiations - porady praktyczne

dev2dev — Sun, 20 Dec 2009 14:36:46 GMT

SQL Server Event Notifications (EN) to właściwość wprowadzona już w wersji 2005 ale niedoceniona przeze

Getting a proper Count for a month - Microsoft SQL Server answers

Getting a proper Count for a month - Microsoft SQL Server answers — Fri, 11 Dec 2009 09:32:29 GMT

Pingback from Getting a proper Count for a month - Microsoft SQL Server answers

re: Taking advantage of Table Variables NOT being transactional - application logging files within a transaction and keeping what's happened

danh — Fri, 27 Nov 2009 11:25:26 GMT

Nice nugget, hadn't thought of using them for this.