Viewing 15 posts - 1 through 15 (of 37 total)
Table wasn't having any index and select count(*) was doing table scan.
After adding the non-clustered index to table , select count(*) is giving result within seconds.
Thanks Jeff and Jason for...
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
September 2, 2019 at 7:39 am
Thanks Jeff for your reply.
query is not returning all data , its just returning row count .
I assume that the query should return the row count quickly , not sure...
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
September 1, 2019 at 5:20 am
I have found the root cause of the issue and want to share with you all. This error may occurred due to various reasons but in my case it was...
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
July 30, 2018 at 5:08 am
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
November 10, 2017 at 10:55 pm
pietlinden - Thursday, November 9, 2017 9:40 PMdb_owner is a ROLE, not a schema.
https://technet.microsoft.com/en-us/library/ms180977(v=sql.90).aspxThe default SCHEMA is dbo.
if db_owner...
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
November 9, 2017 at 10:00 pm
Thanks all for your replies ! But my question is regarding schemas , as we can see in every database there are some pr-defined roles and schemas with same name. ----------------- Not Everything that is faced can be changed,
Aditya Rathour
SQL DBA
but nothing can be changed until it is faced.
November 9, 2017 at 9:29 pm
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
August 28, 2017 at 12:50 am
Thanks All. ----------------- Not Everything that is faced can be changed,
Special thanks to Joe Torre and
Aditya Rathour
SQL DBA
but nothing can be changed until it is faced.
August 2, 2017 at 11:04 pm
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
August 1, 2017 at 12:13 am
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
July 31, 2017 at 11:27 pm
Over a time when data modification (insert , update , delete) takes a place indexes becomes fragmented. Indexes needs maintenance time to time.
you may schedule a weekly maintenance...
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
May 2, 2017 at 5:37 am
This prompt you getting is the authentication to the report server, by default rs uses windows authentication so enter your domain\username with password to access report server.
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
May 1, 2017 at 7:06 pm
Databases that are under availability group can not be renamed directly.
To rename database you can do following -
1- Remove database from Availability group
2- Rename database
3- Take...
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
April 25, 2017 at 11:11 pm
Refer below link , might this help you -
https://qa.sqlservercentral.com/Forums/Topic1679877-2799-1.aspx
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
April 24, 2017 at 9:59 pm
-----------------
Aditya Rathour
SQL DBA
Not Everything that is faced can be changed,
but nothing can be changed until it is faced.
April 24, 2017 at 4:38 am
Viewing 15 posts - 1 through 15 (of 37 total)