Hi Wayne

When execute the above string , i must be able to get only the values from 1...

Thanks Wayne, this works, but got one more doubt, is there any other way to get numbers between 1 and 100 in the given string ?

Hi Laurence

To add to the above post, its vital to get a proper SAN, i have...

Thanks Adi

i have done the below, but its not working

ALTER TRIGGER [dbo].[TrCheckMax] ON [dbo].[DefinePayThruServiceAmountBasedLevels] ...

Thanks Lutz, Sorry for the late reply, I have included a primarykey on the table for ID, this has been clustered index already, this has reduced the time to almost...

Please find the Execution plan, its not working on Chrome 🙂

Thanks Guys, this is been updated from a Java application, i dont know how i can get an exection plan from the application,

i have made the same SQL on...

thanks a lot guys, this worked, thanks for your help 🙂

Hi Steve

Its occurs regardless of any query or any servers, i have tried to reinstall management tools, dint work, installed the whole instance it...

thanks Magic 🙂

Its a nice debate, as you have mentioned if a person works on the same environment and say its a stable platform without any problems and not much new development,...

you can also log into the server and then open SSMS and use local host or ' .' to connect to the local server, then you can use Select @@servername...

I would run a trace on that database and see whats going on in that database, hope this helps 🙂

There is not a thing called as correct fill factor, that depends upon table to table, just start with 80 and test it if this work for you and adjust...

Are you assigning the result set to a varchar or a nvarchar, if you are assigning to a nvarchar then the output must be there, else check the entry...