How many rows can it be returned by the function? Maybe you could store the rows in a temp table and index it?

How the function looks like - can you...

Maybe you could create staging table - with the structure exactly same as the partitioned table you have. Load data into staging table and then switch the table into the...

Hi,

It would be better in this case to write the query this way:

DECLARE @i INT;

SET @i = 10;

INSERT INTO test...

Hi,

Wouldn't LIKE work for you?

select SubstriptionID from Subscription where Subs LIKE '%SNA: The comba Marketing%'

Regards

Piotr

Count me in Jack 🙂

Piotr

Actually, this is simpler I think:

DECLARE @string VARCHAR(10)

SET @string = 'Sarat'

SELECT

CASE

WHEN @string = lower(@string) COLLATE Latin1_General_CS_AI ...

Hi,

This is something I think would be very useful and wouldn't require huge rework from the SQL Server team: to be able to define user friendly messages, something along these...

Wouldn't it be easier to load the data back to SSIS pack and process them properly there? Or process the data and load them in their final state to the...

So the difference is not that big. I suppose it is a matter of the amount of data matching the search criteria.

You can add another index if you cant modify...

Option 1 seems to be better. You should look at the IO cost: execute SET STATISTICS IO ON and then the queries.

Also, run both queries in one batch - both...

How the user is executing this proc? What type of application is used?

Regards

Piotr

Just out of curiosity, what are you trying to achieve with this approach? Why would you query a table you don't know exists?

Regards

Piotr

Maybe you could try to create a user without login, assign it to roles change execution context to it and try to exec the sp_start_job?

As in:

use msdb

go

create user utest without...

It looks your database is subject to replication, isn't it? I found article of Paul Ibison[/url] that discusses similar (I think) issue. It looks like you will have to drop...

Hi, you have to add user to one of the roles defined in the msdb, as per BOL:

By default, members of the sysadmin fixed server role can execute this stored...