Viewing 15 posts - 121 through 135 (of 1,169 total)
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...
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...
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,...
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...
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....
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...
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....
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...
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; --...
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...
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.
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.
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...
June 23, 2016 at 2:30 am
Viewing 15 posts - 121 through 135 (of 1,169 total)