Print a nvarchar variable

Introducing Boomerang - A Notification Framework

Boomerang is a notification framework for IT professionals providing service oriented infrastructure with a SQL based rapid development interface.

Trouble printing out long VARCHAR(MAX) strings?

Ever try to print out a long VARCHAR(MAX)/NVARCHAR(MAX) string, only to find that it's truncated at 8,000/4,000 characters? How do you get around this? New author Sam Bendayan shows us how.

LongPrint

Simple script overcomes the 8000 character limitation in the T-SQL print Command

VB APP vs Stored Procedure

I have been given the assignment of re-designing our billing process. I was hoping for some advice on the best solution. Currently a rather large StoredProcedure (>1K lines) runs each night from the SQL Agent. The SP takes nearly 2 hours to complete essentially it performs the following functions: 1.)Creates a temp table 2.)Creates a […]

RE: SQL Server on SAN

A SAN is a High Availability storage solution which links physical drives on a storage device to the local machine by either Direct attached HBAs (host bus adapters) or through a Fabric connection via a Fibre Channel switch to the SAN Storage device. You can store you database files on the san with either one […]

RE: Converting hex to int

Just for completeness, there is an undocumented extended stored procedure converting hex to int DECLARE @dec varbinary(10) DECLARE @result varchar(255) SET @dec = 813185089 EXEC master..xp_varbintohexstr @dec, @result OUT PRINT @result Cheers, Frank

RE: Best practice when to use an index

quote: David, quick question. When you select from this table are you joining to it or from it? When you join is it based on the identity column? If I am going to join then it will probably be on the identity column, which will be the primary key. I would say that in 80% […]

RE: eliminating duplicates from stored procedure joins

Tim, You can by doing the distinct in a sub query (as in my last post). However this relies on all the columns being duplicated, eg Case_no#,Last_name,First Name,Determination,Sender etc... 1,Bloggs,Fred,Child,Master etc... 1,Bloggs,Fred,Child,Master etc... however if only Case_no# is duplicated then this is harder as it depends on which record is required, eg Case_no#,Last_name,First Name,Determination,Sender etc... […]

RE: shrink logs

Hi, You can either do dbcc shrinkfile (dbid, n) --where dbid is the fileid in sysfiles and n is the target MB size Or backup log yourdbname with truncate_only Ritch Edited by - Ritch on 06/18/2003 03:09:00 AM Edited by - Ritch on 06/18/2003 03:30:42 AM