Viewing 15 posts - 46 through 60 (of 131 total)
I'm not sure if it will help but if it's due to memory leak in SQL 2016 then you can give a try using this
You can also give a...
December 16, 2019 at 10:46 am
You haven't provided the sufficient information so that anybody can help you.
December 16, 2019 at 10:32 am
You can go with DYNAMIC PIVOT/CROSSTAB as suggested by John. Alternatively, if you know the fix number of email id's then you can also go with the equivalent number of...
December 16, 2019 at 10:20 am
An inspiring article especially for the youngsters who is about to complete their Degree and enter into the world of reality called Corporate. When we are young and no one...
December 12, 2019 at 10:09 am
Getting the count from the meta tables is a lot faster.
I guess, that's purely depend upon the STATISTICS which is calculated using the HISTOGRAM with up-to 200 samples. STATISTICS is...
December 12, 2019 at 9:43 am
good to see that at least 2 members did understand what I was stating about count(*) vs count(1).
Brahmanand stated that "count(*) would need to read all data from the...
December 12, 2019 at 6:26 am
Around 2-3 times.
December 11, 2019 at 12:51 pm
Also, do you have some proof of the COUNT(*) vs the COUNT(1) thing? I'm not talking about someone's rhetorical "proof" either. I'm talking about a demonstrable and...
December 11, 2019 at 7:35 am
I think you have got it correctly.
It also refreshed my understanding on the subject. Many thanks !
I got this article quite useful to clear all the myths on AlwaysOn.
December 10, 2019 at 3:21 pm
Regarding count(*) vs count(1) your assumptions are incorrect - SQL server will treat both as the same where a count(*) is concerned and it will use the best index to...
December 10, 2019 at 12:09 pm
If you are using SQL 2016 or onward version then go for Temporal Tables to maintain the history. This is something new inbuilt feature as far as Audit Log/History is...
December 10, 2019 at 10:56 am
As far as I know, AlwaysOn in Standard Edition is just for as a workaround for Mirroring. Mirroring feature has been depreciated by Microsoft. You cannot have multiple secondary replicas...
December 10, 2019 at 10:53 am
your "requirements" do not match what you trying to do on the sql so please do clarify it exactly.
To get the records added today - which is what your...
December 10, 2019 at 10:33 am
Have also compiled a list of best practices for stored procedure out of my experience and wrote a blog. I hope one would find it handy and useful somewhere.
December 9, 2019 at 12:29 pm
Simple yet tricky question. I messed up between REBUILD Clustered Index and DROP/CREATE Clustered Index.
However, it refreshed the learning. Nice question !
December 9, 2019 at 7:31 am
Viewing 15 posts - 46 through 60 (of 131 total)