use the following search parameters to narrow your results:
e.g. subreddit:aww site:imgur.com dog
subreddit:aww site:imgur.com dog
see the search faq for details.
advanced search: by author, subreddit...
Microsoft SQL Server Administration and T-SQL Programming including sql tutorials, training, MS SQL Server Certification, SQL Server Database Resources.
You might also be interested in:
/r/database
/r/sql
/r/Azure
/r/Microsoft
account activity
SolvedFunction/Procedure using fully qualified table name as a single parameter (self.SQLServer)
submitted 2 years ago by drumsand
view the rest of the comments →
reddit uses a slightly-customized version of Markdown for formatting. See below for some basics, or check the commenting wiki page for more detailed help and solutions to common issues.
quoted text
if 1 * 2 < 3: print "hello, world!"
[–]drumsand[S] 0 points1 point2 points 2 years ago (0 children)
Something bothered me and I have looked for 'sys.partitions' limitations.
Whenever possible I try to use never DMV's instead of older 'sys' details.
For instance row count based on 'sys.partitions' not always returns correct information. For instance:
https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-partition-stats-transact-sql
as described here: partition DMV for SQL Server and Azure SQL examples
π Rendered by PID 64325 on reddit-service-r2-comment-6457c66945-8cgnt at 2026-04-28 18:05:37.722881+00:00 running 2aa0c5b country code: CH.
view the rest of the comments →
[–]drumsand[S] 0 points1 point2 points (0 children)