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

Thomasdeage (not verified)

Fri, 11/01/2019 - 02:49

buy propecia pills
buy propecia uk
buy propecia no prescription
buy propecia
buy generic propecia

Thomasdeage (not verified)

Fri, 11/01/2019 - 02:46

buy propecia pills
buy propecia uk
buy propecia no prescription
buy propecia
buy generic propecia

Thomasdeage (not verified)

Fri, 11/01/2019 - 02:43

buy propecia pills
buy propecia uk
buy propecia no prescription
buy propecia
buy generic propecia

Thomasdeage (not verified)

Thu, 10/01/2019 - 23:54

buy propecia online without prescription
buy propecia no prescription
finasteride
buy propecia cheap
where buy propecia

Thomasdeage (not verified)

Thu, 10/01/2019 - 23:46

buy propecia online without prescription
buy propecia no prescription
finasteride
buy propecia cheap
where buy propecia

Brettirrix (not verified)

Tue, 08/01/2019 - 01:35

cipro over the counter

ndfreAsP (not verified)

Tue, 08/01/2019 - 01:10

quick payday loan online personal loan aaa title and payday loans glendale arizona

AlvinJoymn (not verified)

Mon, 07/01/2019 - 02:36

best best online pharmacy forum
testosterone best online pharmacy
best online pharmacy scams
walmart best online pharmacy
best online pharmacy no rx

AlvinJoymn (not verified)

Mon, 07/01/2019 - 02:32

best best online pharmacy forum
testosterone best online pharmacy
best online pharmacy scams
walmart best online pharmacy
best online pharmacy no rx

AlvinJoymn (not verified)

Mon, 07/01/2019 - 00:06

canadian pharmacy american express
mexican best online pharmacy
trusted best online pharmacy reviews
health pharmacy online
best online pharmacy oxycodone

AlvinJoymn (not verified)

Sun, 06/01/2019 - 20:46

cvs best online pharmacy
canadian pharmacy
alprazolam best online pharmacy
best online pharmacy forum
indian best online pharmacy

AlvinJoymn (not verified)

Sun, 06/01/2019 - 20:38

cvs best online pharmacy
canadian pharmacy
alprazolam best online pharmacy
best online pharmacy forum
indian best online pharmacy

AlvinJoymn (not verified)

Sun, 06/01/2019 - 20:34

cvs best online pharmacy
canadian pharmacy
alprazolam best online pharmacy
best online pharmacy forum
indian best online pharmacy

AlvinJoymn (not verified)

Sun, 06/01/2019 - 20:31

cvs best online pharmacy
canadian pharmacy
alprazolam best online pharmacy
best online pharmacy forum
indian best online pharmacy

Williamlieks (not verified)

Sat, 05/01/2019 - 05:56

buy generic levitra
buy levitra no rx
buy levitra 20 mg
order levitra
levitra online

Williamlieks (not verified)

Sat, 05/01/2019 - 00:42

buy vardenafil
buy levitra pills online
levitra 20mg
buy levitra no rx
purchase vardenafil

Williamlieks (not verified)

Sat, 05/01/2019 - 00:32

buy vardenafil
buy levitra pills online
levitra 20mg
buy levitra no rx
purchase vardenafil

hhydielt (not verified)

Fri, 04/01/2019 - 18:17

need fast payday loan payday loan direct lender instant payday loans uk

bfxenact (not verified)

Fri, 04/01/2019 - 11:02

100 guaranteed approval faxless payday loans bad credit no payday loan worldwide cash payday loans

Kevinvew (not verified)

Fri, 04/01/2019 - 05:30

modafinil online pharmacy
cvs pharmacy job application online
us pharmacy online
tramadol online pharmacy
canadian online pharmacy

bsfgEverm (not verified)

Fri, 04/01/2019 - 04:51

payday loan shop bad credit loans no payday loans payday loans without teletrack

Kevinvew (not verified)

Fri, 04/01/2019 - 03:34

online pharmacy no prescription
mexican pharmacies online
vyvanse online pharmacy
canadian drugs
online pharmacy technician programs

Kevinvew (not verified)

Fri, 04/01/2019 - 03:28

online pharmacy no prescription
mexican pharmacies online
vyvanse online pharmacy
canadian drugs
online pharmacy technician programs

bgdbophy (not verified)

Fri, 04/01/2019 - 02:42

payday loans direct lender cash check one application payday loan

bgdbophy (not verified)

Fri, 04/01/2019 - 02:38

payday loans direct lender cash check one application payday loan

bfxenact (not verified)

Thu, 03/01/2019 - 22:30

winthrop faxless payday loans 1 hour payday loans no credit check anyone can get payday loan

bfxenact (not verified)

Thu, 03/01/2019 - 22:26

winthrop faxless payday loans 1 hour payday loans no credit check anyone can get payday loan

bfxenact (not verified)

Thu, 03/01/2019 - 22:23

winthrop faxless payday loans 1 hour payday loans no credit check anyone can get payday loan

ndfreAsP (not verified)

Thu, 03/01/2019 - 09:02

safe online payday loan debt relief alberta payday loans

ndfreAsP (not verified)

Thu, 03/01/2019 - 08:57

safe online payday loan debt relief alberta payday loans

ndfreAsP (not verified)

Thu, 03/01/2019 - 08:46

safe online payday loan debt relief alberta payday loans

ndfreAsP (not verified)

Thu, 03/01/2019 - 08:41

safe online payday loan debt relief alberta payday loans

KeithTrera (not verified)

Thu, 03/01/2019 - 03:46

pharmacy tech training online
online pharmacy technician
online pharmacy no perscription
pharmacies online
canada pharmacy no prescription needed

KeithTrera (not verified)

Thu, 03/01/2019 - 00:30

online pharmacy hydrocodone
are online pharmacies legit
best canadian online pharmacy
canada pharmacy no prescription
india pharmacy online

KeithTrera (not verified)

Thu, 03/01/2019 - 00:25

online pharmacy hydrocodone
are online pharmacies legit
best canadian online pharmacy
canada pharmacy no prescription
india pharmacy online

Brettirrix (not verified)

Mon, 31/12/2018 - 20:24

hydrochlorothiazide

SpencerDip (not verified)

Mon, 31/12/2018 - 09:18

free samples of cialis
free samples of cialis
cialis free trial
cialis coupon free trial
free cialis trial

SpencerDip (not verified)

Mon, 31/12/2018 - 06:03

free cialis voucher
cialis coupon 2017
cialis free samples
how to get cialis free
cialis com free trial

SpencerDip (not verified)

Mon, 31/12/2018 - 01:50

cialis com free offer
free cialis pills
cialis 30 day free trial
free cialis pills
free samples of cialis by mail

SpencerDip (not verified)

Mon, 31/12/2018 - 01:47

cialis com free offer
free cialis pills
cialis 30 day free trial
free cialis pills
free samples of cialis by mail

SpencerDip (not verified)

Mon, 31/12/2018 - 01:44

cialis com free offer
free cialis pills
cialis 30 day free trial
free cialis pills
free samples of cialis by mail

SpencerDip (not verified)

Mon, 31/12/2018 - 01:37

cialis com free offer
free cialis pills
cialis 30 day free trial
free cialis pills
free samples of cialis by mail

Dannyvef (not verified)

Sun, 30/12/2018 - 16:35

cialis free trial
free cialis trial online
cialis coupons
cialis daily use
cialis com free trial

Михаил (not verified)

Sun, 30/12/2018 - 09:00

Перезвоните мне пожалуйста 8 (953) 344-62-67 Антон.

rgvEverm (not verified)

Sun, 30/12/2018 - 05:06

viagra online generic viagra free samples generic viagra for sale

rgvEverm (not verified)

Sun, 30/12/2018 - 05:03

viagra online generic viagra free samples generic viagra for sale

Brettirrix (not verified)

Sun, 30/12/2018 - 00:52

lasix cymbalta 50 mg seroquel for sleep cipro augmentin Cialis Over The Counter

jjnreAsP (not verified)

Sat, 29/12/2018 - 13:22

when does viagra go generic what would happen if a girl took viagra generic viagra names

jjnreAsP (not verified)

Sat, 29/12/2018 - 13:13

when does viagra go generic what would happen if a girl took viagra generic viagra names

FrankNeday (not verified)

Sat, 29/12/2018 - 11:59

free sample of viagra or cialis
free cialis coupon
cialis com free offer
cialis free sample
cialis free trial online

Pages