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
Linked Server
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
July 2013
(1)
May 2013
(2)
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)
MSDN Blogs
>
Microsoft SQL Server Tips & Tricks
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Microsoft SQL Server Tips & Tricks
The hidden gems among DMVs: sys.dm_os_sys_memory
Posted
over 3 years ago
by
AmruthaVarshiniJ
4
Comments
I have always been a big fan of troubleshooting SQL Server performance issues with the help of DMVs. Not only does this allow me to track down the culprit without the help of any external tools/EXEs but it also gives a sysadmin an unbridled sense of power...
Microsoft SQL Server Tips & Tricks
While Installing SQL 2005 Express Edition we hit the error -- The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <Computer Name> Error:2147749896 (0x80041008)
Posted
over 3 years ago
by
AmruthaVarshiniJ
2
Comments
Symptoms: Application Popup Error: =========================== The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <Computer Name> Error:2147749896 (0x80041008). [Environment]...
Microsoft SQL Server Tips & Tricks
How to set Soft-NUMA for SQL Server 2008 R2
Posted
over 3 years ago
by
AmruthaVarshiniJ
0
Comments
This is probably one of the murky topics of SQL Server. Add to this equation, hardware NUMA and the CPU Mask values can be a tough one to determine. Books Online has an article on how to configure Soft-NUMA for a SQL Server 2008 R2 instance. Rob Dorr...
Microsoft SQL Server Tips & Tricks
RESTORE DATABASE TASK IN SQL 2000 FROM ENTERPRISE MANAGER MAY HANG AT TIMES
Posted
over 3 years ago
by
AmruthaVarshiniJ
0
Comments
PROBLEM DESCRIPTION ================ While performing Restore Database task in SQL 2000 from Enterprise Manager it may hang or appears hung at times . H owever you may not find any specific errors in the SQL server error log, application log...
Microsoft SQL Server Tips & Tricks
Can I listen to you Mr. MSDTC?
Posted
over 3 years ago
by
sequelguy
0
Comments
MSDTC unlike on earlier version of Windows, support multiple instances on Windows 2008. You can create a Clustered MSDTC resource in each Cluster Group. The below link gives you more information understanding MSDTC resources in Windows 2008 Failover...
Microsoft SQL Server Tips & Tricks
SQL Server 2008 R2 setup fails on Windows 7 with the error: Version's parameters must be greater than or equal to zero
Posted
over 3 years ago
by
AmruthaVarshiniJ
11
Comments
Symptom: While installing SQL Server 2008 R2 RTM in a Windows 7 box, noticed an error message: SQL Server Setup has encountered the following error: Version's parameters must be greater than or equal to zero. This error occurs after...
Microsoft SQL Server Tips & Tricks
The bcp utility fails to export the data:
Posted
over 3 years ago
by
AmruthaVarshiniJ
0
Comments
Scenario SQL Server 2000 bcp utility fails to export data with the below error message: Operating-system error: There is no OS level error DB_LIBRARY error: Specified server name attribute could not be found Cause You...
Microsoft SQL Server Tips & Tricks
INF: Permissions required for SQL Server Service account to use SSL certificate
Posted
over 3 years ago
by
Nikesh Mhatre
2
Comments
In this blog, we will discuss a scenario which is common across the SQL Server environment using certificates. With the help of another security expert, we were able to find an additional permission required for SQL service account (Non Sys admin) to...
Microsoft SQL Server Tips & Tricks
Installing Client tools for SQL 2008 doesn’t populate the SMO in the SQL Assemblies folder
Posted
over 3 years ago
by
AmruthaVarshiniJ
0
Comments
Recently I encountered this issue. Customer was trying to install SMO by using the following switch in the setup command line for SQL 2008: /FEATURES=SNAC_SDK However, the installation didn’t cache the SMO dll’s in the c:\program...
Microsoft SQL Server Tips & Tricks
Backup Software fails to take System State backup if SQL server VSS writer Service is running
Posted
over 3 years ago
by
AmruthaVarshiniJ
0
Comments
This blog describes a very simple but tricky issue. A Backup software was unable to take system state back up. The issue was narrowed down to a situation where the SQL Server VSS writer service fails to connect to a non existing SQL instance. When we...
Microsoft SQL Server Tips & Tricks
Unable to see the properties of DTC in the Component Services
Posted
over 3 years ago
by
sequelguy
0
Comments
After Preparing and Installing SQL Server 2008 Cluster on a Windows 2008 Server Cluster from the "Advanced" option in the Landing Page, we are unable to see the properties of one of the Instances of DTC in the Component Services UI. It appears blank with...
Microsoft SQL Server Tips & Tricks
A query in SQL Server Management studio could fail with Error: "An error occurred while executing batch. Error message is: The file exists
Posted
over 3 years ago
by
AmruthaVarshiniJ
2
Comments
Below is one of the scenarios, I recently witnessed where a query was failing when executed from SSMS (SQL 2008) on windows client machine. There is no local SQL installation on the machine and had registered a remote SQL Server instance. When tried to...
Microsoft SQL Server Tips & Tricks
Monotonically increasing clustered index keys can cause LATCH contention
Posted
over 3 years ago
by
AmruthaVarshiniJ
1
Comments
In this post, I shall explain why monotonically increasing or decreasing clustered index key columns can create hot spots for your index pages with the help of an example. A hot spot is simply an active portion of the table which is accessed more frequently...
Microsoft SQL Server Tips & Tricks
GUID vs INT Debate
Posted
over 3 years ago
by
AmruthaVarshiniJ
3
Comments
I recently read a blog post on what was better using GUIDs or Integer values. This is been an age long debate and there are advocates in both camps stressing on the disadvantages of the other. Well both implementations have their advantages and disadvantages...
Microsoft SQL Server Tips & Tricks
SQL Server Performance Dashboard Reports in SSMS – Introduction, Install, DateDiff error & Modified for SQL 2008
Posted
over 3 years ago
by
AmruthaVarshiniJ
3
Comments
SQL Server Performance Dashboard Reports in SSMS – Introduction, Install, DateDiff error & Modified for SQL 2008 Many of you seasoned DBA’s out there would have heard about the SQL Server 2005 Performance Dashboard Reports and used...
Microsoft SQL Server Tips & Tricks
SQL Express 2005 Setup Failure
Posted
over 3 years ago
by
AmruthaVarshiniJ
0
Comments
ISSUE: You have SQL 2005 SP2 Express Edition or any of earlier version of SQL Express and you decide to apply SP3 to SQL Express edition. You download the http://www.microsoft.com/downloads/details.aspx?FamilyID=3181842a-4090-4431-acdd-9a1c832e65a6&displaylang...
Microsoft SQL Server Tips & Tricks
INF: New SQL Server features in SQL Server 2008 R2 –Part 2
Posted
over 3 years ago
by
AmruthaVarshiniJ
0
Comments
Continued from http://blogs.msdn.com/b/sqlserverfaq/archive/2010/05/13/inf-new-sql-server-features-in-sql-server-2008-r2-part-1.aspx There are a host of enhancements that come as a part of SQL Server 2008 R2. I have outlined some more features below...
Microsoft SQL Server Tips & Tricks
INF: New SQL Server features in SQL Server 2008 R2 – Part 1
Posted
over 3 years ago
by
AmruthaVarshiniJ
4
Comments
SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 by providing a wealth of new features and capabilities that can benefit your entire organization. Many of these features are already documented in SQL Server Books Online at http://msdn...
Microsoft SQL Server Tips & Tricks
SQL 2008 R2 CTP3 Upgrade directly to RTM.
Posted
over 3 years ago
by
AmruthaVarshiniJ
0
Comments
“ We’re getting questions on whether folks can upgrade directly from CTP3 to RTM. The recommended and supported approach is to uninstall CTP3 and install the final release version when it is available. We apologise for any conflicting information you...
Microsoft SQL Server Tips & Tricks
Incorrect BufferCount data transfer option can lead to OOM condition
Posted
over 3 years ago
by
AmruthaVarshiniJ
2
Comments
SQL Server Books Online holds information on a variety of topics concerning the product which can overwhelm any user. Today, I shall demystify two parameter options for the most commonly automated DBA activity: Database Backups. SQL Server database backups...
Microsoft SQL Server Tips & Tricks
How to “REGENERATE DEK” with a different certificate on Encrypted Mirrored database
Posted
over 3 years ago
by
AmruthaVarshiniJ
0
Comments
As part of Encryption Key management in SQL Server 2008 Transparent Data Encryption (TDE) implementation, SQL server allows re-encryption of a mirrored database without breaking the Mirroring setup. In the following post I would be describing the script...
Microsoft SQL Server Tips & Tricks
SQL Server Agent cannot start because the instance of the Server Instance is not the expected Instance
Posted
over 3 years ago
by
AmruthaVarshiniJ
1
Comments
Problem: SQL Server Agent cannot start because the instance of the Server Instance is not the expected Instance The SQL Server Agent may fail to start after a restart of the SQL Services. You may see this issue when you have multiple SQL Server...
Microsoft SQL Server Tips & Tricks
SQL Server 2008 & SQL Server 2008 R2 clustering FAQ’s:
Posted
over 3 years ago
by
AmruthaVarshiniJ
1
Comments
1. Can I use SQL 2008 slipstreamed installer to install SQL Server 2008 failover cluster? Yes. Launch the setup.exe from command prompt with PCUSource = <path to extracted SP1>. Refer http://blogs.msdn.com/petersad/archive/2009/03/02/sql-server...
Microsoft SQL Server Tips & Tricks
Unable to install Service Pack 1 for SQL Server 2008.
Posted
over 3 years ago
by
AmruthaVarshiniJ
1
Comments
Issue : The Service Pack 1 installation on SQL Server 2008 fails with the following errors : detail.txt: Instance INST01 overall summary: Final result: The patch installer has failed to update the shared features. To determine the reason...
Microsoft SQL Server Tips & Tricks
Unable to open excel files using a cscript in SQL Server Jobs
Posted
over 3 years ago
by
AmruthaVarshiniJ
11
Comments
· Disclaimer : Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office...
Page 5 of 13 (316 items)
«
3
4
5
6
7
»