Converting Large Object Data Types
Eliminate pesky legacy TEXT, NTEXT and IMAGE data types with this handy script.
2013-05-14
4,725 reads
varchar(max)
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.
2009-07-29
10,368 reads
Super Sizing Columns in SQL Server
This article describes how to work with large objects in SQL Server using the MAX Specifier
2008-11-05
2,455 reads
RE: OS Restore vs SQL Restore - Which is better?
To properly backup the .mdf and .ldf files they must be in a detached state. This can be done by stopping all the services or detaching the database(s). If the database is not detached, then reattaching it will fail and the database will be in a suspect or worse state.So, yes you can backup the […]
2004-02-05
RE: ASP SQL Doent work
What is on the line where the error occurs? Can you post the connection string? (change teh server name, user, and pwd)
2004-01-30
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% […]
2003-06-30
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... […]
2003-06-23
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
2003-06-18
1 reads
RE: Data Analyst in PHX
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-06
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers