Telegram RegisterThe public register of Telegram
Telegram profile photo for کانال تخصصی SQLSERVER

Channel

کانال تخصصی SQLSERVER

@SQLSERVER_professional

On this record: Growth · Engagement · Posts · Polls · Cite this entry

854subscribers

-8 since we began measuring on 6 August 2026

Risers and fallers across the register · movement among entries of Under 1,000.

Register entry

Telegram ID-1001020776204
TypeChannel
Username@SQLSERVER_professional
CreatedBetween 1 December 2015 and 31 March 2016 — estimated from Telegram’s id allocation, not measured. How this range is calculated.
First recorded6 August 2026
Last confirmed live10 September 2026
Measurements held6
Confirmed unchanged1 time, most recently 10 September 2026
On Telegramt.me/SQLSERVER_professional

Growth

8548628586 August 2026 — 862 subscribers6 August 2026 — 862 subscribers13 August 2026 — 861 subscribers19 August 2026 — 860 subscribers2 September 2026 — 856 subscribers10 September 2026 — 854 subscribers6 August 202610 September 2026
6 measurements spanning 34 days, net -8. Dots are measurements; the straight line between them is drawn to join them, not to claim we know the path taken in between — snapshots are recorded only when a count changes, so gaps mean “no change observed”, never “interpolated”. The vertical axis spans 853–863 and does not start at zero.
Measurement log — every subscribers count we have recorded
Measured (UTC)SubscribersChange
10 Sept 2026, 05:55854-2
2 Sept 2026, 00:14856-4
19 Aug 2026, 10:57860-1
13 Aug 2026, 09:25861-1
6 Aug 2026, 22:04862no change
6 Aug 2026, 21:16862first reading

Engagement

20 posts held, back to 19 June 2018 — the reader has not yet reached the start of this channel’s public history, so older posts may sit further back, unread. Read across 1 page of Telegram’s post history, 20 posts per page.

Nothing published in the last 30 days. ERR and ER are rolling 30-day measures, so there is nothing to compute — we hold 20 posts for this entry, the most recent from 29 October 2022. An engagement rate over an empty window would be a number about nothing.

Recent posts

13 Sept 2022, 20:20 UTC≈2,920 viewsread 6 August 2026

🗣🗣مژده، مژده: راه اندازی مجدد سایت codeeatsleep.ir با حمایت های خودتان، ما را در جهت انتقال تجارب و به اشتراک گذاری مطالب یاری کنید.

9 Apr 2021, 08:08 UTC≈4,820 viewsread 6 August 2026
Poll

جهت نمایش فروش ماهانهCurrMonthSales بهمراه فروش ماه قبل در یک سطر، کدام کوئری صحیح است؟

  1. LEAD(ms.currMonthSales) OVER (ORDER BY ms.saleyear, ms.salemonth )23%
  2. LAST_VALUE (ms.currMonthSales) OVER (ORDER BY ms.saleyear DESC, ms.salemonth DESC)27%
  3. LAG (ms.currMonthSales) OVER (ORDER BY ms.saleyear, ms.salemonth)26%
  4. LAG (ms.currMonthSales) OVER (ORDER BY ms.saleyear DESC, ms.salemonth DESC23%

Shares as published, totalling 99%. No per-option vote count is published by Telegram, so none is shown.

4 Apr 2021, 03:33 UTC≈4,070 viewsread 6 August 2026
Poll

در sql 2019 یک فایل دیتابیس (Mdf) حداکثر تا چه حجمی می تواند رشد کند؟

  1. محدود به حجم دیسک36%
  2. ۲ ترا بایت19%
  3. نا محدود26%
  4. ۱۶ ترابایت19%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

30 Mar 2021, 19:13 UTC≈3,810 viewsread 6 August 2026
Photo

عملیات انجام شده از زمان بروزرسانی یک رکورد، تا ثبت نهایی تغییرات بر روی دیسک

30 Mar 2021, 19:08 UTC≈3,270 viewsread 6 August 2026
Poll

قبل از نوشته شدن یک dirty page بر روی دیسک، چه عملیاتی باید حتما انجام شده باشد؟

  1. رخ دادن checkpoint34%
  2. نوشته شدن لاگ مرتبط بر روی دیسک25%
  3. مارک شدن pageبه عنوان old17%
  4. مارک شدن page به عنوان ready to write24%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

29 Mar 2021, 19:01 UTC≈2,960 viewsread 6 August 2026
Poll

نتیجه اجرای دستور زیر چیست؟ UPDATE dbo.strings SET stringval= TRIM(stringval)

  1. حذف فضاهای خالی از مقادیر رشته ای جدول28%
  2. حذف فضاهای خالی از ابتدای مقادیر ستون7%
  3. حذف فضاهای خالی از انتهای مقادیر ستون6%
  4. حذف فضاهای خالی تنهااز ابتدا و انتهای مقادیر و نه بین آن ها59%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

27 Mar 2021, 16:54 UTC≈3,050 viewsread 6 August 2026

#آموزش T-SQL ✍️در اسکریپت بالا دو نکته آموزشی وجود دارد که دومی مهمتره!! : 🦻نکته اول: آشنایی با عملکرد تابع NULLIF() که اگر دو مقدار ورودی به آن، شبیه یکدیگر باشند خروجی تابع مقدار NULL و در غیر اینصورت اولین مقدار را به عنوان خروجی نمایش می دهد. https://www.w3schools.com/sql/func_sqlserver_nullif.asp 🦻نکته دوم و مهمتر: زمانی که دو مقدار ورودی در این تابع از یک نوع نباشند یا به عبارتی data type متفاوت داشته باشند مث…

27 Mar 2021, 04:09 UTC≈2,510 viewsread 6 August 2026
Poll

خروجی اسکریپت زیر کدام گزینه است؟ Select nullif(0,'0') Select nullif(0,null) Select nullif(0,' ') Select nullif(1,' ')

  1. 0,0,0,140%
  2. Null,0,null,116%
  3. Null,0,0,118%
  4. 0,null,null,null26%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

17 Dec 2019, 04:10 UTC≈4,920 viewsread 6 August 2026

#معرفی نرم افزار در رابطه با اهمیت و کاربرد وسیع ایندکس در sql server بارها مطلب عنوان کرده ایم اما موضوع مهمی که ممکن است از آن غافل شویم، نگهداری از ایندکس می باشد. یکی از موارد مهم در نگهداری از ایندکس ها توجه به میزان fragmentation است که تأثیر بسزایی در کاهش کارایی آن خواهد داشت. اگر چه برای کنترل و مدیریت Fragmentation اسکریپت و ابزار داخلی در sql server وجود دارد(که بخش هایی مانند طراحی جاب و ... بر عهده خود…

Showing the 12 most recent of 20 posts we hold for @SQLSERVER_professional. View and reaction counts are the latest single reading for each post, not a live figure, and a recent post is still accumulating both. A view count marked ≈ was rounded by Telegram before we ever saw it — t.me prints views in full below 1,000 and to three significant figures above, so ≈1,200,000 means somewhere between 1,150,000 and 1,249,999. Unmarked counts are exact. Text is reproduced from the public post preview and truncated for length.

Polls

The 5 polls we hold for this entry, as Telegram rendered them when we read the post. A poll’s figures keep moving after that, so each one is dated.

9 Apr 2021, 08:08 UTCAnonymous Quiz214 voters

جهت نمایش فروش ماهانهCurrMonthSales بهمراه فروش ماه قبل در یک سطر، کدام کوئری صحیح است؟

  1. LEAD(ms.currMonthSales) OVER (ORDER BY ms.saleyear, ms.salemonth )23%
  2. LAST_VALUE (ms.currMonthSales) OVER (ORDER BY ms.saleyear DESC, ms.salemonth DESC)27%
  3. LAG (ms.currMonthSales) OVER (ORDER BY ms.saleyear, ms.salemonth)26%
  4. LAG (ms.currMonthSales) OVER (ORDER BY ms.saleyear DESC, ms.salemonth DESC23%

Shares as published, totalling 99%. No per-option vote count is published by Telegram, so none is shown.

4 Apr 2021, 03:33 UTCAnonymous Quiz473 voters

در sql 2019 یک فایل دیتابیس (Mdf) حداکثر تا چه حجمی می تواند رشد کند؟

  1. محدود به حجم دیسک36%
  2. ۲ ترا بایت19%
  3. نا محدود26%
  4. ۱۶ ترابایت19%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

30 Mar 2021, 19:08 UTCAnonymous Quiz220 voters

قبل از نوشته شدن یک dirty page بر روی دیسک، چه عملیاتی باید حتما انجام شده باشد؟

  1. رخ دادن checkpoint34%
  2. نوشته شدن لاگ مرتبط بر روی دیسک25%
  3. مارک شدن pageبه عنوان old17%
  4. مارک شدن page به عنوان ready to write24%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

29 Mar 2021, 19:01 UTCAnonymous Quiz306 voters

نتیجه اجرای دستور زیر چیست؟ UPDATE dbo.strings SET stringval= TRIM(stringval)

  1. حذف فضاهای خالی از مقادیر رشته ای جدول28%
  2. حذف فضاهای خالی از ابتدای مقادیر ستون7%
  3. حذف فضاهای خالی از انتهای مقادیر ستون6%
  4. حذف فضاهای خالی تنهااز ابتدا و انتهای مقادیر و نه بین آن ها59%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

27 Mar 2021, 04:09 UTCAnonymous Quiz198 voters

خروجی اسکریپت زیر کدام گزینه است؟ Select nullif(0,'0') Select nullif(0,null) Select nullif(0,' ') Select nullif(1,' ')

  1. 0,0,0,140%
  2. Null,0,null,116%
  3. Null,0,0,118%
  4. 0,null,null,null26%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

Percentages only — there are no per-option vote counts here, because Telegram publishes none. The public post preview gives each option’s share and a single voter total, and nothing else. Multiplying one by the other would produce a per-option tally that looks measured and is not: the shares are rounded to whole numbers before we ever see them. We print what was published and leave the column that does not exist empty.

The shares need not add up to 100. Rounding alone puts many polls at 99 or 101. A poll that allows more than one answer per voter runs well past 100 by design, and several here do. The bars are drawn against a fixed 100% track at each option’s own percentage rather than normalised to the total, so a poll that exceeds it shows that it does instead of being quietly rescaled.

Read from the 20 most recent posts we hold, published 19 June 2018 to 29 October 2022. Telegram labels each poll by kind — an anonymous poll, a quiz, a closed set of final results — and that label is reproduced rather than paraphrased.

Cite this entry

A live page changes as we take new readings, so a citation should name the measurement it is based on, not just the URL. The line below cites the subscriber count as measured 10 September 2026 — this entry's latest reading, not the date you are reading this.

“کانال تخصصی SQLSERVER” (@SQLSERVER_professional), 854 subscribers as measured 10 September 2026. Telegram Register, tgregister.com/channel/SQLSERVER_professional.

Full measurement history, CC BY 4.0. Every reading this register holds for this entry, not just the latest one, as a dated, downloadable record: CSV · JSON. Free to use with attribution to tgregister.com. Each file carries its own generation timestamp, which is the figure to cite for exactly when the data was retrieved.