SQL Server useful but less known features
-
Checking who is connected to the database
sp_whoSELECT
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] -
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 -
Checking the size of column's contents
To check how much data the column contains:
SELECT *, DATALENGTH([column]) AS ColumnSizeInBytes FROM table -
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.
Comments
Louiealeft (not verified)
Wed, 15/05/2019 - 19:25
Permalink
discount online pharmacy 365 mg
Howdy! pharmacy tech school online beneficial website
Louiealeft (not verified)
Wed, 15/05/2019 - 02:24
Permalink
canada pharmacy 46 mg
Hi! french pharmacy online beneficial web page
Louiealeft (not verified)
Wed, 15/05/2019 - 02:21
Permalink
canada pharmacy 46 mg
Hi! french pharmacy online beneficial web page
Louiealeft (not verified)
Wed, 15/05/2019 - 02:18
Permalink
canada pharmacy 46 mg
Hi! french pharmacy online beneficial web page
Louiealeft (not verified)
Wed, 15/05/2019 - 02:15
Permalink
canada pharmacy 46 mg
Hi! french pharmacy online beneficial web page
Shawndeeby (not verified)
Tue, 14/05/2019 - 10:03
Permalink
buy provigil online without prescription 342 mg
Hi! buy modafinil online excellent website.
Shawndeeby (not verified)
Tue, 14/05/2019 - 10:00
Permalink
buy provigil online without prescription 342 mg
Hi! buy modafinil online excellent website.
Shawndeeby (not verified)
Tue, 14/05/2019 - 09:57
Permalink
buy provigil online without prescription 342 mg
Hi! buy modafinil online excellent website.
Shawndeeby (not verified)
Tue, 14/05/2019 - 09:54
Permalink
buy provigil online without prescription 342 mg
Hi! buy modafinil online excellent website.
BonhieWaf (not verified)
Tue, 14/05/2019 - 05:56
Permalink
same day cash loans
i need money desperately
loans for 18 year olds
cash loans today
same day loans bad credit
loan with bad credit
how to get a loan from the bank
same day cash loans
fast loans with bad credit
payday loan places near me
small loan bad credit
getting a personal loan
parent loan
american cash loans
BonhieWaf (not verified)
Tue, 14/05/2019 - 05:52
Permalink
same day cash loans
i need money desperately
loans for 18 year olds
cash loans today
same day loans bad credit
loan with bad credit
how to get a loan from the bank
same day cash loans
fast loans with bad credit
payday loan places near me
small loan bad credit
getting a personal loan
parent loan
american cash loans
BonhieWaf (not verified)
Tue, 14/05/2019 - 05:44
Permalink
same day cash loans
i need money desperately
loans for 18 year olds
cash loans today
same day loans bad credit
loan with bad credit
how to get a loan from the bank
same day cash loans
fast loans with bad credit
payday loan places near me
small loan bad credit
getting a personal loan
parent loan
american cash loans
DianeDam (not verified)
Tue, 14/05/2019 - 03:06
Permalink
us cash advance
unsecured loan
quick loan bad credit
apply personal loan
3000 loan
direct lenders
loans for poor credit
i need money today
payday loans with bad credit
e z money payday loans
pay day loans direct lenders
personal cash loans
top ten payday loans
loans with monthly payments
DianeDam (not verified)
Tue, 14/05/2019 - 03:01
Permalink
us cash advance
unsecured loan
quick loan bad credit
apply personal loan
3000 loan
direct lenders
loans for poor credit
i need money today
payday loans with bad credit
e z money payday loans
pay day loans direct lenders
personal cash loans
top ten payday loans
loans with monthly payments
DianeDam (not verified)
Tue, 14/05/2019 - 02:59
Permalink
us cash advance
unsecured loan
quick loan bad credit
apply personal loan
3000 loan
direct lenders
loans for poor credit
i need money today
payday loans with bad credit
e z money payday loans
pay day loans direct lenders
personal cash loans
top ten payday loans
loans with monthly payments
DianeDam (not verified)
Tue, 14/05/2019 - 02:57
Permalink
us cash advance
unsecured loan
quick loan bad credit
apply personal loan
3000 loan
direct lenders
loans for poor credit
i need money today
payday loans with bad credit
e z money payday loans
pay day loans direct lenders
personal cash loans
top ten payday loans
loans with monthly payments
BonhieWaf (not verified)
Mon, 13/05/2019 - 23:15
Permalink
90 day loans
how to get personal loan
payday loans bad credit direct lender
can i get a loan with bad credit
secure loan
holiday loans
legit payday loans
kwikcash
lend money
payday loans in maryland
take out a loan
goverment loans
small cap funds
payday loans houston
BonhieWaf (not verified)
Mon, 13/05/2019 - 23:13
Permalink
90 day loans
how to get personal loan
payday loans bad credit direct lender
can i get a loan with bad credit
secure loan
holiday loans
legit payday loans
kwikcash
lend money
payday loans in maryland
take out a loan
goverment loans
small cap funds
payday loans houston
BonhieWaf (not verified)
Mon, 13/05/2019 - 23:09
Permalink
90 day loans
how to get personal loan
payday loans bad credit direct lender
can i get a loan with bad credit
secure loan
holiday loans
legit payday loans
kwikcash
lend money
payday loans in maryland
take out a loan
goverment loans
small cap funds
payday loans houston
BonhieWaf (not verified)
Mon, 13/05/2019 - 23:05
Permalink
90 day loans
how to get personal loan
payday loans bad credit direct lender
can i get a loan with bad credit
secure loan
holiday loans
legit payday loans
kwikcash
lend money
payday loans in maryland
take out a loan
goverment loans
small cap funds
payday loans houston
DianeDam (not verified)
Mon, 13/05/2019 - 20:52
Permalink
short term loans online
loan payday
loan payday
personal loan apply online
tennessee quick cash
fastcash com
secured loans
short loans
think cash
same day loans
las vegas payday loan centers
payday loans
bad credit unsecured loans
ez payday loan
DianeDam (not verified)
Mon, 13/05/2019 - 20:49
Permalink
short term loans online
loan payday
loan payday
personal loan apply online
tennessee quick cash
fastcash com
secured loans
short loans
think cash
same day loans
las vegas payday loan centers
payday loans
bad credit unsecured loans
ez payday loan
DianeDam (not verified)
Mon, 13/05/2019 - 20:46
Permalink
short term loans online
loan payday
loan payday
personal loan apply online
tennessee quick cash
fastcash com
secured loans
short loans
think cash
same day loans
las vegas payday loan centers
payday loans
bad credit unsecured loans
ez payday loan
DianeDam (not verified)
Mon, 13/05/2019 - 20:43
Permalink
short term loans online
loan payday
loan payday
personal loan apply online
tennessee quick cash
fastcash com
secured loans
short loans
think cash
same day loans
las vegas payday loan centers
payday loans
bad credit unsecured loans
ez payday loan
BonhieWaf (not verified)
Mon, 13/05/2019 - 16:55
Permalink
where can i get a personal loan with bad credit
5000 loan bad credit
cash loans fast
direct online payday lenders
easy online payday loans
paydayadvance
advance payday
pay day loan
payday loans direct lender only
poor credit personal loans
payday loans
advance cash
eloans
loans bad credit
BonhieWaf (not verified)
Mon, 13/05/2019 - 16:42
Permalink
where can i get a personal loan with bad credit
5000 loan bad credit
cash loans fast
direct online payday lenders
easy online payday loans
paydayadvance
advance payday
pay day loan
payday loans direct lender only
poor credit personal loans
payday loans
advance cash
eloans
loans bad credit
Shawndeeby (not verified)
Mon, 13/05/2019 - 16:39
Permalink
buy provigil 74 mg
Hello! buy provigil with no prescription excellent web page.
Shawndeeby (not verified)
Mon, 13/05/2019 - 16:38
Permalink
buy provigil 74 mg
Hello! buy provigil with no prescription excellent web page.
Shawndeeby (not verified)
Mon, 13/05/2019 - 16:36
Permalink
buy provigil 74 mg
Hello! buy provigil with no prescription excellent web page.
Shawndeeby (not verified)
Mon, 13/05/2019 - 16:35
Permalink
buy provigil 74 mg
Hello! buy provigil with no prescription excellent web page.
DianeDam (not verified)
Mon, 13/05/2019 - 14:22
Permalink
easy online loans
payday loan for bad credit
get loan with bad credit
emergency cash
american payday loans
lending com
loan express
quick loans for bad credit
pay day loans direct lenders
express loan
american loans
loan direct
advance loan
st george personal loan
DianeDam (not verified)
Mon, 13/05/2019 - 14:20
Permalink
easy online loans
payday loan for bad credit
get loan with bad credit
emergency cash
american payday loans
lending com
loan express
quick loans for bad credit
pay day loans direct lenders
express loan
american loans
loan direct
advance loan
st george personal loan
DianeDam (not verified)
Mon, 13/05/2019 - 14:19
Permalink
easy online loans
payday loan for bad credit
get loan with bad credit
emergency cash
american payday loans
lending com
loan express
quick loans for bad credit
pay day loans direct lenders
express loan
american loans
loan direct
advance loan
st george personal loan
DianeDam (not verified)
Mon, 13/05/2019 - 14:16
Permalink
easy online loans
payday loan for bad credit
get loan with bad credit
emergency cash
american payday loans
lending com
loan express
quick loans for bad credit
pay day loans direct lenders
express loan
american loans
loan direct
advance loan
st george personal loan
BonhieWaf (not verified)
Mon, 13/05/2019 - 11:18
Permalink
quick loans no credit
loan market
lending com
1000 loans
texas payday loans
america advance
quick and easy loans
apply for loan
immediate loans
cash payday loans
instalment loans
advance cash services
small loans without credit checks
where can i get a loan with bad credit
DianeDam (not verified)
Mon, 13/05/2019 - 08:22
Permalink
loan approval
private personal loans
bad credit payday loans direct lenders only
america advance
montel williams loans
i need money fast
payday loans el paso tx
cash advance loan
direct lender
online pay day loans
direct payday lenders for bad credit
fast money online
cash now loans
payday advance near me
DianeDam (not verified)
Mon, 13/05/2019 - 08:20
Permalink
loan approval
private personal loans
bad credit payday loans direct lenders only
america advance
montel williams loans
i need money fast
payday loans el paso tx
cash advance loan
direct lender
online pay day loans
direct payday lenders for bad credit
fast money online
cash now loans
payday advance near me
DianeDam (not verified)
Mon, 13/05/2019 - 08:17
Permalink
loan approval
private personal loans
bad credit payday loans direct lenders only
america advance
montel williams loans
i need money fast
payday loans el paso tx
cash advance loan
direct lender
online pay day loans
direct payday lenders for bad credit
fast money online
cash now loans
payday advance near me
DianeDam (not verified)
Mon, 13/05/2019 - 08:14
Permalink
loan approval
private personal loans
bad credit payday loans direct lenders only
america advance
montel williams loans
i need money fast
payday loans el paso tx
cash advance loan
direct lender
online pay day loans
direct payday lenders for bad credit
fast money online
cash now loans
payday advance near me
BonhieWaf (not verified)
Mon, 13/05/2019 - 04:51
Permalink
i need money asap
advance cash services
personal loan interest rates
payday loans milwaukee
america cash advance
online payday loan direct lenders
get loan with bad credit
unsecured personal loans bad credit
applying for a loan
loan up
loan direct
compare personal loan rates
personal loans online
pay day loan
BonhieWaf (not verified)
Mon, 13/05/2019 - 04:43
Permalink
i need money asap
advance cash services
personal loan interest rates
payday loans milwaukee
america cash advance
online payday loan direct lenders
get loan with bad credit
unsecured personal loans bad credit
applying for a loan
loan up
loan direct
compare personal loan rates
personal loans online
pay day loan
DianeDam (not verified)
Mon, 13/05/2019 - 02:05
Permalink
same day payday loans
loan money online
e z money payday loans
payday loan lenders only
loan sites
quick short term loans
cash america loans
personal loan online
quick money online
5000 loan bad credit
where to get a loan
cash advance lenders
easy loans to get
private loans
DianeDam (not verified)
Mon, 13/05/2019 - 02:00
Permalink
same day payday loans
loan money online
e z money payday loans
payday loan lenders only
loan sites
quick short term loans
cash america loans
personal loan online
quick money online
5000 loan bad credit
where to get a loan
cash advance lenders
easy loans to get
private loans
DianeDam (not verified)
Mon, 13/05/2019 - 01:56
Permalink
same day payday loans
loan money online
e z money payday loans
payday loan lenders only
loan sites
quick short term loans
cash america loans
personal loan online
quick money online
5000 loan bad credit
where to get a loan
cash advance lenders
easy loans to get
private loans
DianeDam (not verified)
Mon, 13/05/2019 - 01:55
Permalink
same day payday loans
loan money online
e z money payday loans
payday loan lenders only
loan sites
quick short term loans
cash america loans
personal loan online
quick money online
5000 loan bad credit
where to get a loan
cash advance lenders
easy loans to get
private loans
BonhieWaf (not verified)
Sun, 12/05/2019 - 22:13
Permalink
where to get a personal loan
same day loans
quick easy loans
easy cash loans
payday cash advance
payday loans direct lender
signature loans for bad credit
mobile loans
loan direct
emergency cash
cash to go
lenders network
getting a loan with no credit
loans in houston tx
BonhieWaf (not verified)
Sun, 12/05/2019 - 22:09
Permalink
where to get a personal loan
same day loans
quick easy loans
easy cash loans
payday cash advance
payday loans direct lender
signature loans for bad credit
mobile loans
loan direct
emergency cash
cash to go
lenders network
getting a loan with no credit
loans in houston tx
BonhieWaf (not verified)
Sun, 12/05/2019 - 22:02
Permalink
where to get a personal loan
same day loans
quick easy loans
easy cash loans
payday cash advance
payday loans direct lender
signature loans for bad credit
mobile loans
loan direct
emergency cash
cash to go
lenders network
getting a loan with no credit
loans in houston tx
BonhieWaf (not verified)
Sun, 12/05/2019 - 21:58
Permalink
where to get a personal loan
same day loans
quick easy loans
easy cash loans
payday cash advance
payday loans direct lender
signature loans for bad credit
mobile loans
loan direct
emergency cash
cash to go
lenders network
getting a loan with no credit
loans in houston tx
DianeDam (not verified)
Sun, 12/05/2019 - 19:43
Permalink
small loan bad credit
quick easy money
personal loans for people with bad credit
short term lenders
payday loans direct lenders bad credit
loans today
emergency loans bad credit
online cash loans
ez cash
direct lender payday loans
emergency loan bad credit
micro loans
i need money today
personal loans with no credit
Pages