Good question!

I went for the first option and got it wrong and still don't know why?

I then run two profilers for the following query:

USE master

GO

SELECT * FROM sysdatabases;

GO

and got...

How about the remote access option in sp_configure?

exec sys.sp_configure 'show advanced options',1

reconfigure with override

go

exec sp_configure

Post your error message...

LOVER OF SQL (12/11/2013)

---

Thanks you so much guy, but about this command:

DBCC SHRNIKDATABASE(<db_name>)

I use NOTRUNCATE, TRUNCATEONLY or some else?

i dont understand the perfect functionality of notruncante, truncateonly... i just have...

1. Do a check whether the sql services are run.

2. If you don't know the Login/Account under which sql server was installed then you can create a new Login:

...

DBCC SHRNIKDATABASE(<db_name>)

..and don't forget to run INDEX REBUILD for all indexes because the SHRINK operation will introduce a lot of fragmentation.

Regards,

IgorMi

cliconfg.exe should be the x64 version. I've been using it (even it's an old tool) and it created the aliases under the x64 "SQL Native Client 10.0 Configuration". Ok.

Are both...

Grant Fritchey (12/11/2013)

---

IgorMi (12/11/2013)

---

bugg (12/11/2013)

---

I have considered this, but it will mean downtime to Enable READ_COMMITTED_SNAPSHOT ON, which unfortunately I cannot...

bugg (12/11/2013)

---

I have considered this, but it will mean downtime to Enable READ_COMMITTED_SNAPSHOT ON, which unfortunately I cannot do anytime soon.

Also...

Can you try create Alias using cliconfg.exe?

Yes, since you're aware of the NOLOCK consequences, and as you're describing a bit for what you're going to use it for, than you can do that. Sometimes I do...

Do you use those varchar(max) (or other heavy types) columns in WHERE conditions?

Do you have Full Text search implemented?

tinausa (12/10/2013)

---

One of the things that I have noticed is that when all SPs were working as expected, sqlsrvr.exe would take over 5gb of memory under running processes in task...

OLDCHAPPY (12/10/2013)

---

i had just ran a single index rebuild in our dev environment to confirm it. it does retain the page compression option....

OLDCHAPPY (12/10/2013)

---

IgorMi (12/10/2013)

---

Here I think it's good to remind...

Here I think it's good to remind you on...