also before you run these tests make sure you clear the buffer cache and make sure they are both compiled - otherwise you will skew your results

I've experienced similar - i think this is to do with your UDF

try creating a temp table (for test purposes) and insert into the test table the data returned from...

well - I kind of agree, but it's a difficult call.

this is not a "coding" role - where you get to create new features, but a "consultancy" or "advisory" role...

usefull info steve.. thanks

One more thing to add to the conversation

I'd love to call them "DBA" - however this is for one of our foreign offices (india) and i'm informed that the...

sumanta.roy52 (4/9/2009)

---

Hi Michel..Thanks for your information.... I want to know more about it. Say, I have one application which is using SQL server and it has multiple instances. Can the...

An instance is an installation of SQL server.

you can have many instances on one server.

Each instance will have a set of system databases and it's own configuration.

Each instance can...

if you can risk gost data in your select statement then you could change the code to use NOLOCK

Select * from table WITH (NOLOCK)

there are certain risks involved (possible...

nice try -

unfortunatly the output of a proc can be anyting and is not stored in syscomments or syscolumns....

i went that way to start with ..... i think this...

bank holidays and non working days functions

PCI compliance for credit and bank data out of the box

I think the only way to answer this question is if you can identify what kind of DBA you are and what kind of environment it is.

I've consulted for many...

sorry - the original function was designed to split integers - you should be able to modify the code so output a list of varchars rather than int

MV

astebler (12/15/2008)

---

I see the following errors in the SQL Agent Error Log each time a job is started:

- [298] SQLServer Error: 6, Specified SQL server not found....

I use a function to turn comma separated lists in varchars into tables (don't ask - i know it breaks 1st nornal form - it's something i inherited)

you should be...