MENU
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
HTTP/1.1 200 OK
Date: Sat, 15 Oct 2011 12:18:37 GMT
Server: Apache
Last-Modified: Tue, 11 Oct 2011 17:42:53 GMT
Accept-Ranges: bytes
Content-Length: 85086
Cache-Control: max-age=300, must-revalidate
Expires: Sat, 15 Oct 2011 12:23:37 GMT
Vary: Accept-Encoding,Cookie
Connection: close
Content-Type: text/html; charset=UTF-8
Information about DNS servers
sqlserverplanet.com | MX | 10 | aspmx.l.google.com | IN | 14400 |
sqlserverplanet.com | MX | 20 | alt1.aspmx.l.google.com | IN | 14400 |
sqlserverplanet.com | MX | 30 | alt2.aspmx.l.google.com | IN | 14400 |
sqlserverplanet.com | MX | 40 | aspmx2.googlemail.com | IN | 14400 |
sqlserverplanet.com | MX | 50 | aspmx3.googlemail.com | IN | 14400 |
sqlserverplanet.com | A | 72.55.186.63 | IN | 14400 | |
sqlserverplanet.com | SOA | ns1.panelboxmanager.com | logs.logs.privatedns.com | 2011083100 | 86400 7200 3600000 86400 IN 43200 |
sqlserverplanet.com | NS | ns1.panelboxmanager.com | IN | 43200 | |
sqlserverplanet.com | NS | ns2.panelboxmanager.com | IN | 43200 |
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
Phrase | Quantity |
---|---|
the | 36 |
to | 29 |
be | 21 |
and | 17 |
of | 15 |
can | 14 |
SQL | 13 |
on | 12 |
for | 12 |
Server | 11 |
in | 10 |
is | 9 |
that | 8 |
you | 8 |
data | 6 |
database | 6 |
Azure | 6 |
This | 6 |
support | 6 |
an | 6 |
than | 5 |
it | 5 |
here. | 5 |
are | 5 |
has | 5 |
much | 5 |
more | 5 |
will | 5 |
spacial | 5 |
this | 5 |
with | 5 |
not | 4 |
The | 4 |
by | 4 |
from | 4 |
It | 4 |
now | 4 |
into | 4 |
as | 4 |
rather | 4 |
files | 4 |
committed | 4 |
then | 4 |
run | 4 |
source | 4 |
search | 3 |
Full | 3 |
New | 3 |
also | 3 |
documents | 3 |
up | 3 |
– | 3 |
Data | 3 |
More | 3 |
objects | 3 |
sql | 3 |
row | 3 |
queries | 3 |
index | 3 |
all | 3 |
On | 3 |
Performance | 3 |
allowing | 3 |
two word phrases repeated minimum three times
Phrase | Quantity |
---|---|
SQL Server | 9 |
can be | 7 |
to be | 7 |
rather than | 4 |
on the | 3 |
for the | 3 |
will be | 3 |
of the | 3 |
committed on | 3 |
three word phrases repeated minimum three times
B tags
U tags
I tags
images
file name | alternative text |
---|---|
sqlserverplanet_logo_03.gif | |
Indexed_Views_Execution_Plan.png | :) |
Statlerandwaldorf.jpg | Cannot insert explicit value for identity column in table |
icon_smile.gif | RSS |
Identity_Insert_Error.png | |
Turn_on_execution_plan.png | |
Execution_plan_tab.png | |
Index_Seek.png | |
clustered_index_seek_execution_plan.png | |
Missing_Indexes.png | |
Batch_Requests_sec.png | |
Thick_Arrows_Execution_Plan.png | |
FindPlanHandle.png | |
set_statistics_time_on.png | |
rss.png | |
derek_dieter.jpg | |
facebookico.gif | |
twitterico.gif | |
linkedinico.gif | |
rssico.gif |
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
address | anchor text |
---|---|
HTTP://sqlserverplanet.com | img |
http://sqlserverplanet.com | SQL Server Planet |
#content | Skip to content |
http://sqlserverplanet.com | Home |
http://sqlserverplanet.com/about/ | About |
http://sqlserverplanet.com/consulting/ | Consulting |
http://sqlserverplanet.com/archives/ | Archives |
http://sqlserverplanet.com/add-site/ | Resources |
http://sqlserverplanet.com/feed/ | Feed |
http://sqlserverplanet.com/ddl/indexed-views/ | Indexed Views |
http://sqlserverplanet.com/author/deetro/ | Derek Dieter |
http://files.sqlserverplanet.com/wp-content/uploads/2011/09/Indexed_Views_Execution_Plan.png | |
http://files.sqlserverplanet.com/wp-content/uploads/2011/09/Statlerandwaldorf.jpg | |
http://sqlserverplanet.com/category/dba/ | DBA |
http://sqlserverplanet.com/category/ddl/ | DDL |
http://sqlserverplanet.com/category/design/ | Design |
http://sqlserverplanet.com/ddl/indexed-views/#respond | Comment |
http://sqlserverplanet.com/query-optimizer/auto-update-statistics-auto-create-statistics/ | Auto Update Statistics & Auto Create Statistics |
http://sqlserverplanet.com/author/deetro/ | Derek Dieter |
http://sqlserverplanet.com/category/dba/ | DBA |
http://sqlserverplanet.com/category/query-optimizer/ | Query Optimizer |
http://sqlserverplanet.com/category/sql-optimization/ | SQL Optimization |
http://sqlserverplanet.com/tag/statistics/ | statistics |
http://sqlserverplanet.com/query-optimizer/auto-update-statistics-auto-create-statistics/#respond | Comment |
http://sqlserverplanet.com/query-optimizer/using-dbcc-updateusage/ | Using DBCC UPDATEUSAGE |
http://sqlserverplanet.com/author/deetro/ | Derek Dieter |
http://sqlserverplanet.com/category/dba/ | DBA |
http://sqlserverplanet.com/category/query-optimizer/ | Query Optimizer |
http://sqlserverplanet.com/query-optimizer/using-dbcc-updateusage/#respond | Comment |
http://sqlserverplanet.com/dba/using-identity_insert/ | Using IDENTITY_INSERT |
http://sqlserverplanet.com/author/deetro/ | Derek Dieter |
http://files.sqlserverplanet.com/wp-content/uploads/2011/09/Identity_Insert_Error.png | Cannot insert explicit value for identity column in table |
http://sqlserverplanet.com/category/dba/ | DBA |
http://sqlserverplanet.com/dba/using-identity_insert/#respond | Comment |
http://sqlserverplanet.com/troubleshooting/monitory-queries-against-a-table/ | Monitor Queries against a Table |
http://sqlserverplanet.com/author/deetro/ | Derek Dieter |
http://sqlserverplanet.com/category/dba/ | DBA |
http://sqlserverplanet.com/category/dmv-queries/ | DMV Queries |
http://sqlserverplanet.com/category/troubleshooting/ | Troubleshooting |
http://sqlserverplanet.com/troubleshooting/monitory-queries-against-a-table/#respond | Comment |
http://sqlserverplanet.com/sql-optimization/execution-plans/ | Execution Plans |
http://sqlserverplanet.com/author/deetro/ | Derek Dieter |
http://files.sqlserverplanet.com/wp-content/uploads/2011/09/Turn_on_execution_plan.png | |
http://files.sqlserverplanet.com/wp-content/uploads/2011/09/Execution_plan_tab.png | |
http://files.sqlserverplanet.com/wp-content/uploads/2011/09/Index_Seek.png | |
http://files.sqlserverplanet.com/wp-content/uploads/2011/09/clustered_index_seek_execution_plan.png | |
http://files.sqlserverplanet.com/wp-content/uploads/2011/09/Missing_Indexes.png | |
http://sqlserverplanet.com/category/sql-optimization/ | SQL Optimization |
http://sqlserverplanet.com/category/troubleshooting/ | Troubleshooting |
http://sqlserverplanet.com/sql-optimization/execution-plans/#respond | Comment |
http://sqlserverplanet.com/sql-optimization/understanding-batch-requests-sec/ | Understanding Batch Requests / sec |
http://sqlserverplanet.com/author/deetro/ | Derek Dieter |
http://files.sqlserverplanet.com/wp-content/uploads/2011/09/Batch_Requests_sec.png | |
http://sqlserverplanet.com/category/dba/ | DBA |
http://sqlserverplanet.com/category/sql-optimization/ | SQL Optimization |
http://sqlserverplanet.com/sql-optimization/understanding-batch-requests-sec/#comments | 2 Comments |
http://sqlserverplanet.com/sql-optimization/understanding-sql-server-deadlocks/ | Understanding SQL Server Deadlocks |
http://sqlserverplanet.com/author/deetro/ | Derek Dieter |
http://sqlserverplanet.com/troubleshooting/turn-on-deadlock-trace-flag/ | turn on trace flags |
http://files.sqlserverplanet.com/wp-content/uploads/2010/09/Thick_Arrows_Execution_Plan.png | |
http://sqlserverplanet.com/category/concurrency/ | Concurrency |
http://sqlserverplanet.com/category/sql-optimization/ | SQL Optimization |
http://sqlserverplanet.com/category/troubleshooting/ | Troubleshooting |
http://sqlserverplanet.com/sql-optimization/understanding-sql-server-deadlocks/#comments | 2 Comments |
http://sqlserverplanet.com/sql-optimization/comparing-query-performance/ | Comparing Query Performance |
http://sqlserverplanet.com/author/deetro/ | Derek Dieter |
http://files.sqlserverplanet.com/wp-content/uploads/2011/08/FindPlanHandle.png | |
http://files.sqlserverplanet.com/wp-content/uploads/2011/08/set_statistics_time_on.png | |
http://sqlserverplanet.com/category/sql-optimization/ | SQL Optimization |
http://sqlserverplanet.com/sql-optimization/comparing-query-performance/#respond | Comment |
http://sqlserverplanet.com/sql-server-denali/sql-server-denali-features-update/ | SQL Server Denali – Features Update |
http://sqlserverplanet.com/author/deetro/ | Derek Dieter |
http://sqlserverplanet.com/sql-server-denali/sql-server-denali-pagination-using-order-by/ | OFFSET and FETCH parameters for the ORDER BY |
http://sqlserverplanet.com/category/sql-server-denali/ | SQL Server Denali |
http://sqlserverplanet.com/sql-server-denali/sql-server-denali-features-update/#respond | Comment |
http://sqlserverplanet.com/page/2/ | |
http://sqlserverplanet.com/consulting/ | |
http://sqlserverplanet.com/category/auditing/ | Auditing |
http://sqlserverplanet.com/category/concurrency/ | Concurrency |
http://sqlserverplanet.com/category/data-warehouse/ | Data Warehouse |
http://sqlserverplanet.com/category/dba/ | DBA |
http://sqlserverplanet.com/category/ddl/ | DDL |
http://sqlserverplanet.com/category/design/ | Design |
http://sqlserverplanet.com/category/dmv-queries/ | DMV Queries |
http://sqlserverplanet.com/category/hosting/ | Hosting |
http://sqlserverplanet.com/category/indexes/ | Indexing |
http://sqlserverplanet.com/category/maintenance/ | Maintenance |
http://sqlserverplanet.com/category/oracleequivalents/ | OracleEquivalents |
http://sqlserverplanet.com/category/personal-blog/ | Personal Blog |
http://sqlserverplanet.com/category/query-hints/ | Query Hints |
http://sqlserverplanet.com/category/query-optimizer/ | Query Optimizer |
http://sqlserverplanet.com/category/reporting-services/ | Reporting Services |
http://sqlserverplanet.com/category/scripts/ | Scripts |
http://sqlserverplanet.com/category/security/ | Security |
http://sqlserverplanet.com/category/server-objects/ | Server Objects |
http://sqlserverplanet.com/category/sql/ | SQL |
http://sqlserverplanet.com/category/sql-optimization/ | SQL Optimization |
http://sqlserverplanet.com/category/sql-server/ | SQL Server |
http://sqlserverplanet.com/category/sql-server-2000/ | SQL Server 2000 |
http://sqlserverplanet.com/category/sql-server-2005/ | SQL Server 2005 |
http://sqlserverplanet.com/category/sql-server-2008/ | SQL Server 2008 |
http://sqlserverplanet.com/category/sql-server-denali/ | SQL Server Denali |
http://sqlserverplanet.com/category/tools/ | Tools |
http://sqlserverplanet.com/category/troubleshooting/ | Troubleshooting |
http://sqlserverplanet.com/category/tsql/ | TSQL |
http://sqlserverplanet.com/category/video-training/ | video training |
http://sqlserverplanet.com/category/xml/ | XML |
external links
address | anchor text |
---|---|
http://msdn.microsoft.com/en-us/library/ms178104.aspx | article |
http://msdn.microsoft.com/en-us/library/ms187504(v=SQL.105).aspx | lock partitioning |
http://msdn.microsoft.com/en-us/data/hh297028 | http://msdn.microsoft.com/en-us/data/hh297028 |
http://msdn.microsoft.com/en-us/data/gg427686 | Download here |
http://blogs.msdn.com/b/sqlfts/archive/2011/07/21/introducing-fulltext-statistical-semantic-search-in-sql-server-codename-denali-release.aspx | here |
http://msdn.microsoft.com/query/dev10.query?appId=Dev10IDEF1&l=EN-US&k=k(SEQUENCE_TSQL);k(SQL105.SWB.TSQLRESULTS.F1);k(SQL105.SWB.TSQLQUERY.F1)&rd=true | here |
http://msdn.microsoft.com/en-us/library/hh212961(v=sql.110).aspx | MSDN article. |
http://www.youtube.com/watch?v=C2LY_FhMnfc&feature=youtube_gdata | here |
http://www.youtube.com/watch?v=vPN8_PCsJm4&feature=mfu_in_order&list=UL | here |
http://msdn.microsoft.com/en-us/library/ms188659(v=sql.110).aspx | custom defined |
http://msdn.microsoft.com/en-us/library/ff929071(v=sql.110).aspx | Article here |
http://msdn.microsoft.com/en-us/library/ff878345(v=sql.110).aspx | MDSN Article |
http://www.microsoft.com/download/en/details.aspx?id=26726 | features pack |
http://twitter.com/statuses/user_timeline/sqlserverplanet.rss | RSS |
http://twitter.com/sqlserverplanet | Random MVP RSS Feeds |
http://t.co/dgc5o4Zj | http://t.co/dgc5o4Zj |
http://twitter.com/SQLServerPlanet/statuses/123793030095454211 | about 1 hour ago |
http://twitterfeed.com | twitterfeed |
http://t.co/1l2rfgXY | http://t.co/1l2rfgXY |
http://twitter.com/SQLServerPlanet/statuses/123763762233749505 | about 3 hours ago |
http://twitterfeed.com | twitterfeed |
http://t.co/CKpmd1cy | http://t.co/CKpmd1cy |
http://twitter.com/SQLServerPlanet/statuses/123539438964969472 | about 18 hours ago |
http://twitterfeed.com | twitterfeed |
http://t.co/BSGhZ6L8 | http://t.co/BSGhZ6L8 |
http://twitter.com/SQLServerPlanet/statuses/123539437702492161 | about 18 hours ago |
http://twitterfeed.com | twitterfeed |
http://t.co/gltNnjbd | http://t.co/gltNnjbd |
http://twitter.com/SQLServerPlanet/statuses/123495396298338304 | about 21 hours ago |
http://twitterfeed.com | twitterfeed |
http://search.twitter.com/search?q=%23SQLPASS | #SQLPASS |
http://t.co/ztpxRT39 | http://t.co/ztpxRT39 |
http://twitter.com/SQLServerPlanet/statuses/123407738184282112 | 02:41:12 PM October 10, 2011 |
http://twitterfeed.com | twitterfeed |
http://t.co/fNmSyV23 | http://t.co/fNmSyV23 |
http://twitter.com/SQLServerPlanet/statuses/123180029193625600 | 11:36:22 PM October 09, 2011 |
http://twitterfeed.com | twitterfeed |
http://t.co/wWgxMmy5 | http://t.co/wWgxMmy5 |
http://twitter.com/SQLServerPlanet/statuses/123180027956305920 | 11:36:21 PM October 09, 2011 |
http://twitterfeed.com | twitterfeed |
http://t.co/QZTlXoqr | http://t.co/QZTlXoqr |
http://twitter.com/SQLServerPlanet/statuses/122755401803501569 | 07:29:03 PM October 08, 2011 |
http://twitterfeed.com | twitterfeed |
http://t.co/twpFC4N0 | http://t.co/twpFC4N0 |
http://twitter.com/SQLServerPlanet/statuses/122362381820100608 | 05:27:19 PM October 07, 2011 |
http://twitterfeed.com | twitterfeed |
http://www.facebook.com/profile.php?id=181246332850 | |
http://twitter.com/sqlserverplanet | |
http://www.linkedin.com/groups?gid=2065783 | |
http://feeds.feedburner.com/sqlserverplanet |