Viewing 15 posts - 121 through 135 (of 1,170 total)
Thanks for the question. Interesting one.
Igor Micev
August 2, 2016 at 2:30 am
It's also recommended to use dedicated database servers.
It depends on the size of your database(s). Planning for data is important to know.
If your database is small, up to some tens...
Igor Micev
July 28, 2016 at 2:18 am
As robert.sterbal 56890 asked for extra screens from perfmon.exe, I'm doing that again. Now for a 500GB database on a server with even faster disks (15K rpm). The gain is...
Igor Micev
July 22, 2016 at 9:32 am
robert.sterbal 56890 (7/21/2016)
Nice article.Do you plan on continued testing with different workloads and time frames? Will you publish those results as well?
The workload is pretty much similar during the day,...
Igor Micev
July 21, 2016 at 6:33 am
Alan.B (7/12/2016)
patrickmcginnis59 10839 (7/12/2016)
Igor Micev (7/12/2016)
patrickmcginnis59 10839 (7/12/2016)
An ORDER BY clause can be used explicitly in the end as well. In that case the COUNT is not deterministic. See Deterministic...
Igor Micev
July 12, 2016 at 3:01 pm
wasay_76 (7/12/2016)
Query 9 is returning 6 rows instead of one/*(9)*/ SELECT DISTINCT(COUNT(1)) FROM #TmpCounts; -- 1 row
Already noted. It counts 6 rows. The Distinct returns one row....
Igor Micev
July 12, 2016 at 7:56 am
John Bigler (7/12/2016)
In the What Index is Used When Using COUNT? section of the article, you write, "If the table has no indexes (hash) ...". I believe that...
Igor Micev
July 12, 2016 at 7:09 am
patrickmcginnis59 10839 (7/12/2016)
An ORDER BY clause can be used explicitly in the end as well. In that case the COUNT is not deterministic. See Deterministic and Nondeterministic Functions for more....
Igor Micev
July 12, 2016 at 6:29 am
Karl Klingler (7/12/2016)
in the article you pose the question "Which Is Faster: COUNT(*) or COUNT(1)?", but actually you answer with "COUNT(*) versus COUNT(ID)" (which is not the same as...
Igor Micev
July 12, 2016 at 5:40 am
pmadhavapeddi22 (7/12/2016)
/*(2)*/ SELECT COUNT(1) FROM #TmpCounts; -- 6 rows
/*(3)*/ SELECT COUNT(Column1) FROM #TmpCounts; -- 5 rows
/*(4)*/ SELECT COUNT(ALL Column1) FROM #TmpCounts; --...
Igor Micev
July 12, 2016 at 5:02 am
NParry (7/12/2016)
Just tried these out, and this:/*(9)*/ SELECT DISTINCT(COUNT(1)) FROM #TmpCounts; -- 1 row
Actually returns 6. This is on SQL Server 2008.
6 is the result from the COUNT(1) and...
Igor Micev
July 12, 2016 at 3:53 am
Easy question. I guess it was inspired from the SQL Server Profiler. There the sql statements are executed like this one.
Igor Micev
July 6, 2016 at 11:35 am
The script doesn't find the free space by database. It does it for the databases' files, so its title is not corresponding to its function.
Igor Micev
July 6, 2016 at 7:58 am
ashwan (6/23/2016)
if isolation level set to (read uncommitted) can we see previous image of the (before update)
It's the same as using hint (NOLOCK). You can place it for desired...
Igor Micev
June 23, 2016 at 2:30 am
Viewing 15 posts - 121 through 135 (of 1,170 total)