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
How to
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
Upgrade
Archives
Archives
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)
May, 2009
MSDN Blogs
>
Microsoft SQL Server Tips & Tricks
>
May, 2009
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Microsoft SQL Server Tips & Tricks
INFO: SQL 2000 MSDE installation will fail if you have number of CPUs on a box which is not in power of 2.
Posted
over 4 years ago
by
Parikshit Savjani
17
Comments
Consider a scenario where you are doing a new install ation of SQL Server 2000 MSDE on a computer and you get messages like: Setup failed to configure the server. Refer to the server error logs and setup error logs for more information Normally...
Microsoft SQL Server Tips & Tricks
Data type precedence while using UNION statement differs in behavior between SQL Server 2000 and SQL Server 2005
Posted
over 4 years ago
by
Rajesh Setlem
1
Comments
It originally seemed to be a quite complex problem, involving an update trigger that was failing in SQL Server 2005, but had never failed in SQL Server 2000, giving a message like "Syntax error converting the varchar value 'whatever' to a column of...
Microsoft SQL Server Tips & Tricks
How to determine the space used by the system and user objects in Microsoft Sql Server 2005
Posted
over 4 years ago
by
Parikshit Savjani
1
Comments
--Query to find space utilized by System tables SELECT [System Table Name] , ( SELECT ROWS FROM SysIndexes S WHERE S . Indid < 2 AND S . ID = OBJECT_ID ( A . [System Table Name] )) AS [Total Rows] , [Total Space Used in MB] FROM ( SELECT QUOTENAME...
Microsoft SQL Server Tips & Tricks
SQL Server Management studio issues
Posted
over 4 years ago
by
Parikshit Savjani
2
Comments
What will happen if the indispensible SSMS crashes or worse just hangs? A lot of fretting!! (For the not-so SQLCMD savvy)....!! I have enclosed here two scenarios and their corresponding resolutions PROBLEM 1 When we start up SQL Server Management...
Microsoft SQL Server Tips & Tricks
The installation of client tools in sql 2005 fails with error 1722
Posted
over 4 years ago
by
Parikshit Savjani
7
Comments
Recently we encountered an issue while installation of client tools in sql 2005, so I would like to share the same in the following blog Problem Description The installation of the Client tools in SQL Server 2005 fails with the following error...
Page 1 of 1 (5 items)