you should have the indexes that are required to support your queries - having them as Columnstore or not will depend on your needs and on your testing that have...

SELECT REPLACE(oldvalue,'*', replicate('0', 12 - len(t.oldvalue) + 1)) newvalue
from (values 
         ('ABC*1')
       ...

• This reply was modified 6 years, 3 months ago by frederico_fonseca.

another one - just weeding out options as not quite sure of what the issue is.

EXEC xp_logininfo 'xxx'

and another option - it is possible that the user is setup on...

• This reply was modified 6 years, 3 months ago by frederico_fonseca.

its now necessarily as you think - just by looking at the image you have tasks running in parallel - maybe it was just timing of when you took the...

the way you have it setup it should execute them in parallel - except potentially the drop of indexes as that locks system tables - but that should be fast...

Test it - easy enough for you to create a table with normal compression and...

you didn't tell us what you mean by "the data returns instantaneously" - if by this you mean it returns to your SSMS grid then do not use this as...

can you give the output of these please.

select containment_desc
from sys.databases 
where name = db_name()

select  type_desc
, is_disabled
, default_database_name

from sys.server_principals
where name =  'xxxx' -- replace with login...

try the following code - without changes other than the login name and give us the output

if (original_login() <> suser_name())
begin
    print 'revert'
  ...

potentially something similar to this

select customerid
     , max(case when [Data Entry] = 'entry' then [Data Entry] else null end) as [Data Entry]
 ...

you will most likely need to get your network/windows admins involved - there could be many reasons and none associated with SQL Server itself.

have a look at this google...

go to tools -> options - > Environment -> international settings.

probably set to "same as Microsoft Windows"

but this should not affect your code - unless you are copying/pasting from SSMS...

If you are sysadmin you can't give permissions to yourself - neither do you need it on this case so remove that from your script.

regarding setuser - do not use...

well.. first link I got when I searched was the one that Oracle themselves supply - so I wonder if you did find it on your googling and did you...

did you bother googling? there are a few tools (mostly commercial) including one from Oracle that can either put them on a format you can read or that will...