Arsh

Forum Replies Created

Viewing 15 posts - 196 through 210 (of 340 total)

RE: SQL Server Mirroring Issue

Can u check this without witness ? to narrow down to any issue with the witness . Also , make sure you use the same user (preferably , AD...

September 19, 2017 at 1:30 am

#1959901
RE: Strange login connectivity issue

Make sure the user is not part of group that's denied permission.
The links below might be useful
https://blog.sqlauthority.com/2015/08/19/sql-server-login-failed-for-user-reason-token-based-server-access-validation-failed-with-an-infrastructure-error/
https://stackoverflow.com/questions/3159810/token-based-server-access-validation-failed-with-an-infrastructure-error

September 18, 2017 at 8:25 am

#1959804
RE: Read Only permissions to a user

Hey got some breakthrough here. I transferred schema ownership , removed the user (without login) from the database in question and went to the 'logins' at server level and mapped...

September 18, 2017 at 8:13 am

#1959797
RE: Read Only permissions to a user

Thom A - Monday, September 18, 2017 4:24 AM
Arsh - Monday, September 18, 2017 4:14 AM

September 18, 2017 at 7:33 am

#1959777
RE: Read Only permissions to a user

Thom A - Monday, September 18, 2017 2:41 AM
Arsh - Monday, September 18, 2017 2:36 AM

September 18, 2017 at 4:14 am

#1959736
RE: Read Only permissions to a user

Thom A - Friday, September 15, 2017 9:06 AM
Arsh - Friday, September 15, 2017 8:52 AM

September 18, 2017 at 2:36 am

#1959729
RE: Fill Factor on Clustered Index

jasona.work - Friday, September 15, 2017 8:53 AM
Arsh - Friday, September 15, 2017 8:39 AM

September 17, 2017 at 5:44 am

#1959693
RE: Read Only permissions to a user

Thom A - Friday, September 15, 2017 8:31 AM
Arsh - Friday, September 15, 2017 8:20 AM

September 15, 2017 at 8:52 am

#1959603
RE: Fill Factor on Clustered Index

jasona.work - Friday, September 15, 2017 7:37 AM
Fill factor is also important when it comes to inserts. Using your PatientID as an...

September 15, 2017 at 8:39 am

#1959597
RE: Read Only permissions to a user

Thom A - Friday, September 15, 2017 6:56 AM
Arsh - Friday, September 15, 2017 6:39 AM
Also, is...

September 15, 2017 at 8:20 am

#1959592
RE: High Memory consuming by Database

Scalability has to be looked into . Even with one instance on the box , SQL server will exceed the max memory if it requires (forced to) ?

September 15, 2017 at 6:49 am

#1959573
RE: Occasional mysterious time outs on SQL Server db table

What is the mode of stats update is your DB configured for ? Even if its AUTO , the synchronous update might stall the query execution until the stats are updated...

September 15, 2017 at 2:18 am

#1959548
RE: Best solution to provide read copy for MIS environment in SQL Server 2008R2

Since , not all the tables are required , I would go with option 4 , as log shipping or mirroring would involve all the tables . Understand the...

September 15, 2017 at 1:53 am

#1959545
RE: Basics of Statistics (data distribution)

I started with this sometime back with a slow build up with examples. Just completed the first post starting with the definition... Can visit @
sqlempire.wordpress.com

September 14, 2017 at 6:58 am

#1959414
RE: How does a integer/any data record store in SQL Server page

The master data required for page management also comprises that extra space . Like the Offset , IAM info etc.

September 14, 2017 at 5:31 am

#1959397

Viewing 15 posts - 196 through 210 (of 340 total)