last data update: 2011/10/15, 05:18

Website loading time

during the test: 0.54 s

cable connection (average): 0.76 s

DSL connection (average): 0.97 s

modem (average): 12.41 s

HTTP headers

Information about DNS servers

sqlserverplanet.comMX10aspmx.l.google.comIN14400
sqlserverplanet.comMX20alt1.aspmx.l.google.comIN14400
sqlserverplanet.comMX30alt2.aspmx.l.google.comIN14400
sqlserverplanet.comMX40aspmx2.googlemail.comIN14400
sqlserverplanet.comMX50aspmx3.googlemail.comIN14400
sqlserverplanet.comA72.55.186.63IN14400
sqlserverplanet.comSOAns1.panelboxmanager.comlogs.logs.privatedns.com201108310086400 7200 3600000 86400 IN 43200
sqlserverplanet.comNSns1.panelboxmanager.comIN43200
sqlserverplanet.comNSns2.panelboxmanager.comIN43200

Received from the first DNS server

Request to the server "sqlserverplanet.com"
You used the following DNS server:
DNS Name: ns1.panelboxmanager.com
DNS Server Address: 72.55.186.20#53
DNS server aliases:

HEADER opcode: REQUEST, status: NOERROR, id: 40254
flag: qr aa rd REQUEST: 1, ANSWER: 9, AUTHORITY: 0, ADDITIONAL: 0

REQUEST SECTION:
sqlserverplanet.com. IN ANY

ANSWER SECTION:
sqlserverplanet.com. 86400 IN SOA ns1.panelboxmanager.com. logs.logs.privatedns.com. 2011083100 86400 7200 3600000 86400
sqlserverplanet.com. 86400 IN NS ns2.panelboxmanager.com.
sqlserverplanet.com. 86400 IN NS ns1.panelboxmanager.com.
sqlserverplanet.com. 14400 IN A 72.55.186.63
sqlserverplanet.com. 14400 IN MX 20 alt1.aspmx.l.google.com.
sqlserverplanet.com. 14400 IN MX 30 alt2.aspmx.l.google.com.
sqlserverplanet.com. 14400 IN MX 40 aspmx2.googlemail.com.
sqlserverplanet.com. 14400 IN MX 50 aspmx3.googlemail.com.
sqlserverplanet.com. 14400 IN MX 10 aspmx.l.google.com.

Received 292 bytes from address 72.55.186.20#53 in 9 ms

Received from the second DNS server

Request to the server "sqlserverplanet.com"
You used the following DNS server:
DNS Name: ns2.panelboxmanager.com
DNS Server Address: 184.107.100.12#53
DNS server aliases:

HEADER opcode: REQUEST, status: NOERROR, id: 63311
flag: qr aa rd REQUEST: 1, ANSWER: 9, AUTHORITY: 0, ADDITIONAL: 0

REQUEST SECTION:
sqlserverplanet.com. IN ANY

ANSWER SECTION:
sqlserverplanet.com. 86400 IN SOA ns1.panelboxmanager.com. logs.logs.privatedns.com. 2011083100 86400 7200 3600000 86400
sqlserverplanet.com. 86400 IN NS ns1.panelboxmanager.com.
sqlserverplanet.com. 86400 IN NS ns2.panelboxmanager.com.
sqlserverplanet.com. 14400 IN A 72.55.186.63
sqlserverplanet.com. 14400 IN MX 20 alt1.aspmx.l.google.com.
sqlserverplanet.com. 14400 IN MX 30 alt2.aspmx.l.google.com.
sqlserverplanet.com. 14400 IN MX 40 aspmx2.googlemail.com.
sqlserverplanet.com. 14400 IN MX 50 aspmx3.googlemail.com.
sqlserverplanet.com. 14400 IN MX 10 aspmx.l.google.com.

Received 292 bytes from address 184.107.100.12#53 in 30 ms

Subdomains (the first 50)

Typos (misspells)

aqlserverplanet.com
zqlserverplanet.com
xqlserverplanet.com
dqlserverplanet.com
eqlserverplanet.com
wqlserverplanet.com
s1lserverplanet.com
s2lserverplanet.com
swlserverplanet.com
salserverplanet.com
sqkserverplanet.com
sqpserverplanet.com
sqoserverplanet.com
sqlaerverplanet.com
sqlzerverplanet.com
sqlxerverplanet.com
sqlderverplanet.com
sqleerverplanet.com
sqlwerverplanet.com
sqlswrverplanet.com
sqlssrverplanet.com
sqlsdrverplanet.com
sqlsrrverplanet.com
sqls4rverplanet.com
sqls3rverplanet.com
sqlseeverplanet.com
sqlsedverplanet.com
sqlsefverplanet.com
sqlsetverplanet.com
sqlse5verplanet.com
sqlse4verplanet.com
sqlsercerplanet.com
sqlserberplanet.com
sqlsergerplanet.com
sqlserferplanet.com
sqlservwrplanet.com
sqlservsrplanet.com
sqlservdrplanet.com
sqlservrrplanet.com
sqlserv4rplanet.com
sqlserv3rplanet.com
sqlserveeplanet.com
sqlservedplanet.com
sqlservefplanet.com
sqlservetplanet.com
sqlserve5planet.com
sqlserve4planet.com
sqlserverolanet.com
sqlserverllanet.com
sqlserver-lanet.com
sqlserver0lanet.com
sqlserverpkanet.com
sqlserverppanet.com
sqlserverpoanet.com
sqlserverplznet.com
sqlserverplsnet.com
sqlserverplwnet.com
sqlserverplqnet.com
sqlserverplabet.com
sqlserverplamet.com
sqlserverplajet.com
sqlserverplahet.com
sqlserverplanwt.com
sqlserverplanst.com
sqlserverplandt.com
sqlserverplanrt.com
sqlserverplan4t.com
sqlserverplan3t.com
sqlserverplaner.com
sqlserverplanef.com
sqlserverplaneg.com
sqlserverplaney.com
sqlserverplane6.com
sqlserverplane5.com
qlserverplanet.com
slserverplanet.com
sqserverplanet.com
sqlerverplanet.com
sqlsrverplanet.com
sqlseverplanet.com
sqlsererplanet.com
sqlservrplanet.com
sqlserveplanet.com
sqlserverlanet.com
sqlserverpanet.com
sqlserverplnet.com
sqlserverplaet.com
sqlserverplant.com
sqlserverplane.com
qslserverplanet.com
slqserverplanet.com
sqslerverplanet.com
sqlesrverplanet.com
sqlsreverplanet.com
sqlsevrerplanet.com
sqlserevrplanet.com
sqlservreplanet.com
sqlserveprlanet.com
sqlserverlpanet.com
sqlserverpalnet.com
sqlserverplnaet.com
sqlserverplaent.com
sqlserverplante.com
ssqlserverplanet.com
sqqlserverplanet.com
sqllserverplanet.com
sqlsserverplanet.com
sqlseerverplanet.com
sqlserrverplanet.com
sqlservverplanet.com
sqlserveerplanet.com
sqlserverrplanet.com
sqlserverpplanet.com
sqlserverpllanet.com
sqlserverplaanet.com
sqlserverplannet.com
sqlserverplaneet.com
sqlserverplanett.com

Location

IP: 72.55.186.63

continent: NA, country: Canada (CAN), city: Montreal

Website value

rank in the traffic statistics:

There is not enough data to estimate website value.

Basic information

website build using CSS

code weight: 83.09 KB

text per all code ratio: 11 %

title: SQL Server Planet

description: SQL Server Planet: Tips and Articles on SQL Server

keywords: SQL Server Planet

encoding: UTF-8

language: en-US

Website code analysis

one word phrases repeated minimum three times

PhraseQuantity
the36
to29
be21
and17
of15
can14
SQL13
on12
for12
Server11
in10
is9
that8
you8
data6
database6
Azure6
This6
support6
an6
than5
it5
here.5
are5
has5
much5
more5
will5
spacial5
this5
with5
not4
The4
by4
from4
It4
now4
into4
as4
rather4
files4
committed4
then4
run4
source4
search3
Full3
New3
also3
documents3
up3
3
Data3
More3
objects3
sql3
row3
queries3
index3
all3
On3
Performance3
allowing3

two word phrases repeated minimum three times

PhraseQuantity
SQL Server9
can be7
to be7
rather than4
on the3
for the3
will be3
of the3
committed on3

three word phrases repeated minimum three times

B tags

U tags

I tags

images

file namealternative text
:)
Cannot insert explicit value for identity column in table
RSS

headers

H1

SQL Server Planet

H2

Indexed Views

Auto Update Statistics & Auto Create Statistics

Using DBCC UPDATEUSAGE

Using IDENTITY_INSERT

Monitor Queries against a Table

Execution Plans

Understanding Batch Requests / sec

Understanding SQL Server Deadlocks

Comparing Query Performance

SQL Server Denali – Features Update

Random MVP RSS Feeds

Newsletter Signup

Connect

Categories

H3

Indexed Views

Auto Update Statistics & Auto Create Statistics

Using DBCC UPDATEUSAGE

Using IDENTITY_INSERT

Monitor Queries against a Table

Execution Plans

Understanding Batch Requests / sec

Understanding SQL Server Deadlocks

Comparing Query Performance

SQL Server Denali – Features Update

Random MVP RSS Feeds

Newsletter Signup

Connect

Categories

H4

Plan Caching

Buffer Caching

Network Traffic

Disk Usage

On the Horizon

H5

H6

internal links

addressanchor text
img
SQL Server Planet
Skip to content
Home
About
Consulting
Archives
Resources
Feed
Indexed Views
Derek Dieter
DBA
DDL
Design
Comment
Auto Update Statistics & Auto Create Statistics
Derek Dieter
DBA
Query Optimizer
SQL Optimization
statistics
Comment
Using DBCC UPDATEUSAGE
Derek Dieter
DBA
Query Optimizer
Comment
Using IDENTITY_INSERT
Derek Dieter
Cannot insert explicit value for identity column in table
DBA
Comment
Monitor Queries against a Table
Derek Dieter
DBA
DMV Queries
Troubleshooting
Comment
Execution Plans
Derek Dieter
SQL Optimization
Troubleshooting
Comment
Understanding Batch Requests / sec
Derek Dieter
DBA
SQL Optimization
2 Comments
Understanding SQL Server Deadlocks
Derek Dieter
turn on trace flags
Concurrency
SQL Optimization
Troubleshooting
2 Comments
Comparing Query Performance
Derek Dieter
SQL Optimization
Comment
SQL Server Denali – Features Update
Derek Dieter
OFFSET and FETCH parameters for the ORDER BY
SQL Server Denali
Comment
Auditing
Concurrency
Data Warehouse
DBA
DDL
Design
DMV Queries
Hosting
Indexing
Maintenance
OracleEquivalents
Personal Blog
Query Hints
Query Optimizer
Reporting Services
Scripts
Security
Server Objects
SQL
SQL Optimization
SQL Server
SQL Server 2000
SQL Server 2005
SQL Server 2008
SQL Server Denali
Tools
Troubleshooting
TSQL
video training
XML

external links

addressanchor text
article
lock partitioning
http://msdn.microsoft.com/en-us/data/hh297028
Download here
here
here
MSDN article.
here
here
custom defined
Article here
MDSN Article
features pack
RSS
Random MVP RSS Feeds
http://t.co/dgc5o4Zj
about 1 hour ago
twitterfeed
http://t.co/1l2rfgXY
about 3 hours ago
twitterfeed
http://t.co/CKpmd1cy
about 18 hours ago
twitterfeed
http://t.co/BSGhZ6L8
about 18 hours ago
twitterfeed
http://t.co/gltNnjbd
about 21 hours ago
twitterfeed
#SQLPASS
http://t.co/ztpxRT39
02:41:12 PM October 10, 2011
twitterfeed
http://t.co/fNmSyV23
11:36:22 PM October 09, 2011
twitterfeed
http://t.co/wWgxMmy5
11:36:21 PM October 09, 2011
twitterfeed
http://t.co/QZTlXoqr
07:29:03 PM October 08, 2011
twitterfeed
http://t.co/twpFC4N0
05:27:19 PM October 07, 2011
twitterfeed