These topic options were described when SSC switched/upgraded the forum software back in the days. 😉

On the other hand, if you want to print or copy the full topic at...

Fred Zimmerman (10/1/2009)

---

Seemingly great answer but leaves me ?s.

1) What do you set your Recovery to on your databases backed up.

2) Aside from stated Diff backups you do, do you...

So, for a "classic" tally table ( i.e. start with 1 increment by 1 ), Pauls solution performs best.

If you actually want a dynamic tally table ( i.e. start...

Indeed strange findings.

I think the best way to tackle this problem is to use sqlprofiler to capture the load launched on both engines (FULL).

Especially check the connections settings to actually...

My guess your alias references are resulting to these strange findings !

Did you try using aliasses for both objects

DECLARE @helperStr8000 AS VARCHAR(8000)

SET @helperStr8000='bcp "SELECT * FROM dbname..tablename x

WHERE EXISTS...

if you use "dirty reads" you allow your applications to use uncommitted data !

No complains are accepted for that ! :unsure:

Cursors can cause the need to be materialized in...

Start here :

- Gails very nice summary: http://www.sqlservercentral.com/articles/64582/

- Books online topic "Implementing Restore Scenarios for SQL Server Databases"

You really need :

- Full backup (= snapshot of your database)

- log backup...

I would...

the urls both state on 32-bit win2003 std edtn : 4Gb is the max.

it depends:

- 32 bit 4GB max

- 64 bit 32GB max

http://technet.microsoft.com/en-us/library/cc758523%28WS.10%29.aspx

or

http://msdn.microsoft.com/en-us/library/aa366778%28VS.85%29.aspx#physical_memory_limits_windows_server_2003

Start with properly design of your own tables !

DON'T use varchar(max) for everything ! Only use it if needed (>8000 bytes to be stored in a single column)

Is this a single shot operation ?

Use the import / export data wizard in enterprise manager/instance/database/tables rightclick on a table object.

Check out DTS in books online

Steve already couvered the DRP part.

Just to add a little bit to Keep in mind:

- SQL2005 has many features "off by default" on a fresh install. If you perform...

Nic-1052152 (9/28/2009)

---

Hi all

I have two front ends for my database; an old one in access and a newer one in vb.net.

I have a script which will script many new clients...

Be sure to double check your sql2000 settings (config + security) before starting the upgrade.

In case of DRP, you may have to start from sql2000 again, so if you don't...