Much depends on how frequently you want to access the binary data, and how many rows you want to squeeze in to your priamry data pages.

Smaller blobs can be stored...

Books online, the documentation that comes with SQL Server is an excellent...

k.furness (1/11/2008)

---

Hi Andras

Thanks for the swift reply.

Not sure if this will work as I forgot to mention there are 150 fields Q1 to Q150

Tried to run script and got an...

And it...

What about:

SELECT x.RECENT

, x.[SSN]

, x.[Date]

FROM ( SELECT ROW_NUMBER() OVER ( PARTITION...

In addition to my previous warnings, here are some more 🙂 Do make sure that you are happy with modifications to the master database. Note also, that dbo.sp_MS_marksystemobject is not...

teligaurav (1/11/2008)

---

Hello Andras Belokosztolszki ,

Thank you For your reply

I tried your 'trick'

it is working

but i need to call sp_temp that i created as 'global' in...

Hi Gouri,

In the trigger body you have...

k.furness (1/11/2008)

---

I have the following table of date

Q1 Q2 Q3

1 2 1

1 3 2

3...

Hi,

my first comment would be is to avoid the old system tables/views on 2005. Instead of syscomments use sys.sql_modules.

Another "trick" that is worth considering, is to prefix the stored procedures...

You mentioned that there are no backups to restore. If the database has never been backed up then the recovery mode...

paulholl (1/10/2008)

---

Hello, I have a problem with one of my clients to do with a SQL Server 2005 database but I am a relatively inexpirienced with SQL Server.

A query has...

pg53 (1/10/2008)

---

I thought the registry was the only way to change it too, but I've just discovered that in SSMS it's possible to select the server node, properties, security -...

Benjamin Kovac (1/10/2008)

---

Thanks Andras,

At the moment it looks we are going to stick with MSSQL 2000, but will change in short time.Anyway thanks for your quick reply. I should say-koszi...

Benjamin Kovac (1/10/2008)

---

Hiya,

having a table for storing Terms&Condition texts (for storing multiple whitelabel terms&cond.), so wondering which data type would be better for storing the terms text itself.Should be nvarchar(max)...