Porter James

A Tale of Partition Schemes and Disappearing Dragons

A tale in which is detailed how I used SWITCH PARTITION to efficiently load my data and save myself from the flaming jaws of death.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(44)

You rated this post out of 5. Change rating

2017-10-20 (first published: 2015-11-02)

4,341 reads

A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....

With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...

fawtle – n. a weird little flaw built into your partner that somehow only...

Hi all, I recently moved to a new employer who have their HA setup...

Comments posted to this topic are about the item Semantic Search in SQL Server...

Comments posted to this topic are about the item Encoding URLs

I have this data in a table:

CREATE TABLE Response
( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY
, ResponseVal VARBINARY(5000)
)
GO

If I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use?