Sign in
MSDN Blogs
Microsoft Blog Images
More ...
Microsoft SQL Server Tips & Tricks
Tips and Tricks for the SQL Server Enthusiast
RSS for posts
Database Engine
blogs
Analysis services
blogs
Reporting services
blogs
Integration services
blogs
Data access tech blogs
Database Engine videos
Analysis services videos
Reporting services videos
Integration services videos
Data access tech Videos
Common Tasks
Blog Home
Email Blog Author
About
RSS for comments
RSS for posts
Atom
Search
Tags
analysis services
Backup
Cluster
DBVideo
Encryption
Installation
OLAP
Performance
query plan
replication
Security
Setup
SQL
sql 2000
sql 2005
SQL 2008
SQL query plan
SQL Server
SQL Server 2000
SQL Server 2005
sql Server 2008
SQL Server 2008 R2
Transactional Replication
update statistics
Upgrade
Archives
Archives
April 2013
(2)
March 2013
(1)
December 2012
(2)
June 2012
(7)
May 2012
(1)
April 2012
(3)
March 2012
(5)
February 2012
(4)
January 2012
(3)
December 2011
(4)
November 2011
(3)
October 2011
(4)
September 2011
(1)
August 2011
(5)
July 2011
(3)
June 2011
(6)
May 2011
(10)
April 2011
(1)
March 2011
(1)
February 2011
(6)
January 2011
(3)
December 2010
(4)
November 2010
(2)
October 2010
(4)
September 2010
(9)
August 2010
(4)
June 2010
(4)
May 2010
(15)
April 2010
(18)
March 2010
(18)
February 2010
(7)
December 2009
(8)
November 2009
(7)
October 2009
(10)
September 2009
(6)
August 2009
(13)
July 2009
(5)
June 2009
(15)
May 2009
(5)
April 2009
(15)
March 2009
(15)
February 2009
(8)
January 2009
(9)
December 2008
(5)
November 2008
(2)
October 2008
(10)
September 2008
(5)
August 2008
(2)
July 2008
(7)
June 2008
(4)
May 2008
(1)
April 2008
(1)
June, 2008
MSDN Blogs
>
Microsoft SQL Server Tips & Tricks
>
June, 2008
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Microsoft SQL Server Tips & Tricks
Useful Documents while Troubleshootig Performance issues in the SQL Server 2005
Posted
over 5 years ago
by
sequelguy
0
Comments
The performance issue of the SQL Server can be anything from the connectivity issue of the application to Query running slow or query timeouts. So the first thing that we need to find out during the performance troubleshooting is to find what is the exact...
Microsoft SQL Server Tips & Tricks
Installation of SQL Server Express Edition on Windows Vista while Installing Microsoft Office Accounting 2008
Posted
over 5 years ago
by
sequelguy
0
Comments
There have been a number of instances where the installation of the sql express edition on Windows Vista which also gets installed along with Microsoft Office Accounting 2008 fails which ultimately causes the installation of the Office Accounting 2008...
Microsoft SQL Server Tips & Tricks
ERROR 29506 while installing the SP2 on the sql server 2005
Posted
over 5 years ago
by
sequelguy
0
Comments
While installing SP2 on the SQL server 2005, the installation may fail. Whenever the SQL server installation fails it creates a log in the following location. C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\ The above location generally...
Microsoft SQL Server Tips & Tricks
How to Change the Dynamic Port of the SQL Server Named Instance to an Static Port in a SQL Server 2005 Cluster
Posted
over 5 years ago
by
sequelguy
7
Comments
In SQL server the default instance has a listener which listens on the fixed port which is TCP port 1433. This is the default behavior. However for the named instance the port on which the SQL server listens is random and is dynamically selected when...
Page 1 of 1 (4 items)