I don't know DB2 at all

I have just had a quick look and the DB2 create table syntax is not too far off SQL Server and you can get the...

Hi There,

You could add the DB2 server as a linked server and then select the data you want direct into SQL Server.

http://support.microsoft.com/kb/222937

Or export all the data into...

Hi there,

Michelle has an updated version of this script:

http://sqlfool.com/2011/06/index-defrag-script-v4-1/

Running the script creates all the necessary functions and stored procs, a little way down the script is a suggested...

They Say you learn something new every day...

I''m now off to change a couple of scripts which us ISNUMERIC to capture where I'm filtering numbers..

Thanks for pointing this out everyone.....

Hi There

ISNUMERIC may help with this..

http://technet.microsoft.com/en-us/library/ms186272(v=sql.105).aspx

Hi There,

It depends on the recovey model the database uses, full or bulk, backup the logs. In simple there is no need to back them up.

Eariler in the thread I...

Hi There,

what issues are you seeing?

the max memory setting should be set at a level which allows for the OS and any other software on the server, so for example...

Hi There,

Welcome to SSC.. 🙂

A great starting point to start to learn is to follow the stairway series on this site. Take a look at database design, indexes and basic...

Hi,

Clearing the plan cache would be a bad idea, your performance would be degraded as the first execution of the SP would have to workout the best plan.

What has prompted...

Hi There,

From Microsoft

"As a database is changed by such actions as adding indexes or changing data in indexed columns, the original query plans used to access its tables should be...

Hi,

My Take on it.. 🙂

WITH DocCTE (DivIDCte, DivIDCount)

AS

(SELECT DivID,

COUNT(DivID)

FROM Doc GROUP BY DivID)

SELECTID,

Div,

'Count' = ISNULL(DivIDCount,0)

FROM...

Hi,

The user at the schema level, does it have permission to create/update/delete etc?

Hi There,

This is a big question really. It depends will be the answer.. 🙂 you will need to look at things like what load is on each instance, what other...

Hi there,

There is a good article on isolation levels by SQL Server CAT here:

http://blogs.msdn.com/b/sqlcat/archive/2011/02/20/concurrency-series-basics-of-transaction-isolation-levels.aspx

Hi There,

This is a good starting point for AWE:

http://technet.microsoft.com/en-us/library/ms175581(v=sql.100).aspx

http://technet.microsoft.com/en-us/library/ms190673(v=sql.100).aspx

You will need the /pae switch, as well as lock pages in memory in secpol. don't forget to...