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...
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...
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...
July 30, 2018 at 5:08 am
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...
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.
November 9, 2017 at 9:29 pm
August 28, 2017 at 12:50 am
August 1, 2017 at 12:13 am
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...
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.
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...
April 25, 2017 at 11:11 pm
Refer below link , might this help you -
https://www.sqlservercentral.com/Forums/Topic1679877-2799-1.aspx
April 24, 2017 at 9:59 pm
April 24, 2017 at 4:38 am
Viewing 15 posts - 1 through 15 (of 37 total)