SQL Server useful but less known features

  • Posted on: 2 November 2016
  • By: Michał Turecki

  1. Checking who is connected to the database

    sp_who

    SELECT
    NULL as [Connections by Database],
    [host_name] AS [Client Machine],
    db.name AS [Database],
    [program_name] AS [Client Program],
    COUNT(*) AS [Open Connections]
    FROM sys.dm_exec_sessions s (nolock)
    LEFT JOIN sys.dm_exec_requests r (nolock) ON r.session_id = s.session_id
    LEFT JOIN sys.databases db (nolock) ON db.database_id = r.database_id
    WHERE s.session_id >= 50 -- Ignore SQL Server processes
    GROUP BY [host_name], db.name, [program_name]
    ORDER BY [Client Machine], [Database], [Client Program]

  2. Adjusting connection pooling settings

    By default pool size is 100 per database with a command timeout (effectively a connection timeout) of 15 seconds. To increase add following to the connection string:

    Connection Timeout=30;Pooling='true';Max Pool Size=200

  3. Checking the size of column's contents

    To check how much data the column contains:

    SELECT *, DATALENGTH([column]) AS ColumnSizeInBytes FROM table

  4. Using SQL Server profiler

    Profiler is a powerful way to debug application performance problems, to check query execution time. If you're developing any application using SQL Server as a database, running it at least once for every application release can help with pinpointing possible performance issues. Remember the rule - there should be a constant number of queries regardless of the amount of records fetched - that way application will scale better. Sometimes it's better to replace a single complex query with more simpler queries because for each result row, columns shared by joins are repeated and delivered to client for processing many times.

Tags: 
programming
SQL
databases
sql-server

Comments

Cindyram (not verified)

Sun, 08/09/2019 - 12:57

generic cialis lipitor medication cialis 10mg

Cindyram (not verified)

Sun, 08/09/2019 - 12:55

generic cialis lipitor medication cialis 10mg

Cindyram (not verified)

Sun, 08/09/2019 - 12:55

generic cialis lipitor medication cialis 10mg

Cindyram (not verified)

Sun, 08/09/2019 - 12:54

generic cialis lipitor medication cialis 10mg

Cindyram (not verified)

Sun, 08/09/2019 - 11:21

cialis without a prescription sildenafil citrate order cialis

Cindyram (not verified)

Sun, 08/09/2019 - 11:17

cialis without a prescription sildenafil citrate order cialis

Cindyram (not verified)

Sun, 08/09/2019 - 11:15

cialis without a prescription sildenafil citrate order cialis

Cindyram (not verified)

Sun, 08/09/2019 - 11:13

cialis without a prescription sildenafil citrate order cialis

RandyJex (not verified)

Wed, 04/09/2019 - 21:45

If you’re upset about your weight and want to lose a little more, get this…

An overweight mother with pre-diabetes has just SHOCKED the medical
community by losing an unheard of 22lbs pounds in just 13 days…

....Without starving herself, she lost a total of 37lbs in the first month!
-> CLICK HERE to see her Transformation Pics!

...Even without exercising, she went on to burn off 84lbs (almost a pound a day)
and eliminated any sign of diabetes or any other life-ending diseases.

And the amazing thing is…

All she did was this D.I.Y. “carb-pairing” trick that reconditions your 3 female
weight-loss hormones to drastically accelerate fat-burning while still eating the
foods you love.

Check it out for yourself…

“Carb-Pairing” Melts Away 37 Pounds in Just 20 Days (WOMEN ONLY)

Enjoy!

RandyJex (not verified)

Wed, 04/09/2019 - 21:40

If you’re upset about your weight and want to lose a little more, get this…

An overweight mother with pre-diabetes has just SHOCKED the medical
community by losing an unheard of 22lbs pounds in just 13 days…

....Without starving herself, she lost a total of 37lbs in the first month!
-> CLICK HERE to see her Transformation Pics!

...Even without exercising, she went on to burn off 84lbs (almost a pound a day)
and eliminated any sign of diabetes or any other life-ending diseases.

And the amazing thing is…

All she did was this D.I.Y. “carb-pairing” trick that reconditions your 3 female
weight-loss hormones to drastically accelerate fat-burning while still eating the
foods you love.

Check it out for yourself…

“Carb-Pairing” Melts Away 37 Pounds in Just 20 Days (WOMEN ONLY)

Enjoy!

RandyJex (not verified)

Wed, 04/09/2019 - 21:37

If you’re upset about your weight and want to lose a little more, get this…

An overweight mother with pre-diabetes has just SHOCKED the medical
community by losing an unheard of 22lbs pounds in just 13 days…

....Without starving herself, she lost a total of 37lbs in the first month!
-> CLICK HERE to see her Transformation Pics!

...Even without exercising, she went on to burn off 84lbs (almost a pound a day)
and eliminated any sign of diabetes or any other life-ending diseases.

And the amazing thing is…

All she did was this D.I.Y. “carb-pairing” trick that reconditions your 3 female
weight-loss hormones to drastically accelerate fat-burning while still eating the
foods you love.

Check it out for yourself…

“Carb-Pairing” Melts Away 37 Pounds in Just 20 Days (WOMEN ONLY)

Enjoy!

LarryJourn (not verified)

Wed, 04/09/2019 - 17:23

online pharmacy tech programs with financial aid cheap online pharmacy canada drugs coupon code

LarryJourn (not verified)

Wed, 04/09/2019 - 17:20

online pharmacy tech programs with financial aid cheap online pharmacy canada drugs coupon code

LarryJourn (not verified)

Wed, 04/09/2019 - 17:17

online pharmacy tech programs with financial aid cheap online pharmacy canada drugs coupon code

LarryJourn (not verified)

Wed, 04/09/2019 - 17:09

online pharmacy tech programs with financial aid cheap online pharmacy canada drugs coupon code

Haroldguics (not verified)

Wed, 04/09/2019 - 11:42

pharmacy technician classes online prescription drugs online pharmacy technician class online

Haroldguics (not verified)

Wed, 04/09/2019 - 11:39

pharmacy technician classes online prescription drugs online pharmacy technician class online

Haroldguics (not verified)

Wed, 04/09/2019 - 11:32

pharmacy technician classes online prescription drugs online pharmacy technician class online

Haroldguics (not verified)

Wed, 04/09/2019 - 11:29

pharmacy technician classes online prescription drugs online pharmacy technician class online

LarryJourn (not verified)

Mon, 02/09/2019 - 08:49

pharmacy degrees online pharmacy tech schooling online online pharmacy viagra

LarryJourn (not verified)

Mon, 02/09/2019 - 08:43

pharmacy degrees online pharmacy tech schooling online online pharmacy viagra

Josephmaymn (not verified)

Mon, 02/09/2019 - 08:42

mexican online pharmacy cvs pharmacy online online pharmacy viagra

Josephmaymn (not verified)

Mon, 02/09/2019 - 08:41

mexican online pharmacy cvs pharmacy online online pharmacy viagra

LarryJourn (not verified)

Mon, 02/09/2019 - 08:37

pharmacy degrees online pharmacy tech schooling online online pharmacy viagra

Josephmaymn (not verified)

Mon, 02/09/2019 - 08:35

mexican online pharmacy cvs pharmacy online online pharmacy viagra

Louiscut (not verified)

Sun, 01/09/2019 - 23:12

buy cialis online buy cialis no rx buy tadalafil online/#buy cialis

Louiscut (not verified)

Sun, 01/09/2019 - 23:10

buy cialis online buy cialis no rx buy tadalafil online/#buy cialis

Louiscut (not verified)

Sun, 01/09/2019 - 23:08

buy cialis online buy cialis no rx buy tadalafil online/#buy cialis

Louiscut (not verified)

Sun, 01/09/2019 - 23:04

buy cialis online buy cialis no rx buy tadalafil online/#buy cialis

Curtisarime (not verified)

Sat, 31/08/2019 - 20:40

buy sildenafil buy viagra cheap buy viagra medication

Curtisarime (not verified)

Sat, 31/08/2019 - 20:33

buy sildenafil buy viagra cheap buy viagra medication

Curtisarime (not verified)

Sat, 31/08/2019 - 20:30

buy sildenafil buy viagra cheap buy viagra medication

Louiscut (not verified)

Sat, 31/08/2019 - 18:28

buy cialis online without prescription buy cialis usa buy cialis no rx/#purchase cialis online no prescription

Louiscut (not verified)

Sat, 31/08/2019 - 18:20

buy cialis online without prescription buy cialis usa buy cialis no rx/#purchase cialis online no prescription

Louiscut (not verified)

Sat, 31/08/2019 - 18:16

buy cialis online without prescription buy cialis usa buy cialis no rx/#purchase cialis online no prescription

Louiscut (not verified)

Sat, 31/08/2019 - 18:14

buy cialis online without prescription buy cialis usa buy cialis no rx/#purchase cialis online no prescription

Brettirrix (not verified)

Fri, 30/08/2019 - 07:28

buy vibramycin

StevFreell (not verified)

Thu, 29/08/2019 - 15:37

Buy Cipro 500mg Allergia Propecia viagra online prescription Propecia Disfunzione Erettile

StevFreell (not verified)

Thu, 29/08/2019 - 15:34

Buy Cipro 500mg Allergia Propecia viagra online prescription Propecia Disfunzione Erettile

StevFreell (not verified)

Thu, 29/08/2019 - 15:28

Buy Cipro 500mg Allergia Propecia viagra online prescription Propecia Disfunzione Erettile

Jamiejella (not verified)

Wed, 28/08/2019 - 11:10

buy finasteride where buy propecia order propecia/#where buy propecia

Jamiejella (not verified)

Wed, 28/08/2019 - 11:06

buy finasteride where buy propecia order propecia/#where buy propecia

Jamiejella (not verified)

Wed, 28/08/2019 - 11:03

buy finasteride where buy propecia order propecia/#where buy propecia

Jamiejella (not verified)

Wed, 28/08/2019 - 10:59

buy finasteride where buy propecia order propecia/#where buy propecia

zetMarion (not verified)

Sun, 25/08/2019 - 15:51

Поршев Андрей Викторович мошенник
город Казань

Машина Камри госномер У033ВС116 вин XW7BF4FKX0S0007025
сервис Восстания 8А
дом Казань, ул. Лукина д.41, кв.126
мобильный 8(951)069-79-47

замена sti

этот человек-обманщик
обещает поставку любых деталей по приемлемой цене и исчезает
отключает телефон когда вы звоните
с ним лучше не заключать никаких договоренностей
он берет деньги и исчезает.

zetMarion (not verified)

Sun, 25/08/2019 - 15:44

Поршев Андрей Викторович мошенник
город Казань

Машина Камри госномер У033ВС116 вин XW7BF4FKX0S0007025
сервис Восстания 8А
дом Казань, ул. Лукина д.41, кв.126
мобильный 8(951)069-79-47

замена sti

этот человек-обманщик
обещает поставку любых деталей по приемлемой цене и исчезает
отключает телефон когда вы звоните
с ним лучше не заключать никаких договоренностей
он берет деньги и исчезает.

zetMarion (not verified)

Sun, 25/08/2019 - 15:40

Поршев Андрей Викторович мошенник
город Казань

Машина Камри госномер У033ВС116 вин XW7BF4FKX0S0007025
сервис Восстания 8А
дом Казань, ул. Лукина д.41, кв.126
мобильный 8(951)069-79-47

замена sti

этот человек-обманщик
обещает поставку любых деталей по приемлемой цене и исчезает
отключает телефон когда вы звоните
с ним лучше не заключать никаких договоренностей
он берет деньги и исчезает.

zetMarion (not verified)

Sun, 25/08/2019 - 15:37

Поршев Андрей Викторович мошенник
город Казань

Машина Камри госномер У033ВС116 вин XW7BF4FKX0S0007025
сервис Восстания 8А
дом Казань, ул. Лукина д.41, кв.126
мобильный 8(951)069-79-47

замена sti

этот человек-обманщик
обещает поставку любых деталей по приемлемой цене и исчезает
отключает телефон когда вы звоните
с ним лучше не заключать никаких договоренностей
он берет деньги и исчезает.

cwCiz (not verified)

Sun, 25/08/2019 - 14:34

cialis without prescription sildenafil citrate discount cialis

cwCiz (not verified)

Sun, 25/08/2019 - 14:30

cialis without prescription sildenafil citrate discount cialis

Pages