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)
May, 2011
MSDN Blogs
>
Microsoft SQL Server Tips & Tricks
>
May, 2011
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Microsoft SQL Server Tips & Tricks
INF : Restore Database UI fails with error: "Length cannot be less than zero. Parameter name: length"
Posted
over 2 years ago
by
Balmukund
0
Comments
Recently we came across a situation where one of the customer was trying to restore a Database backup using SSMS and while going to Options tab UI failed with the error: "Length cannot be less than zero. Parameter name: length" ...
Microsoft SQL Server Tips & Tricks
INF : How does Logical Record Feature Works in Merge Replication
Posted
over 2 years ago
by
Balmukund
0
Comments
By default, merge replication processes data changes on a row-by-row basis. In many circumstances this is appropriate, but for some applications, it is essential that related rows be processed as a unit. The logical records feature of merge replication...
Microsoft SQL Server Tips & Tricks
INF: SQL Server Extended Stored Procedures & behaviour change starting with Windows 2008
Posted
over 2 years ago
by
Balmukund
0
Comments
Many of you SQL folks out there have extended stored procedures installed and being used in your SQL Server. Most often this is installed by some 3 rd party applications like backup applications or linked server providers. There are times when some custom...
Microsoft SQL Server Tips & Tricks
INF: Hey, my SQL Server Service is not starting – what do I do?
Posted
over 2 years ago
by
Balmukund
4
Comments
This is one of those challenging situations when customers call us at times. I can understand the gravity of the situation – your boss is behind your back, your business is down, your application is down, your website cannot accept orders or your phone...
Microsoft SQL Server Tips & Tricks
Errors Raised with Severity/Level 16 May Cause Transactions into Doomed State
Posted
over 2 years ago
by
Balmukund
0
Comments
Consider a scenario wherein you are doing some operation which is generating an error with Level\Severity 16 and is causing the entire transaction to fail with the following message: Msg 3998, Level 16, State 1, Line 1 Uncommittable transaction is detected...
Microsoft SQL Server Tips & Tricks
Presentation Material for Webcast on Performance Dashboard
Posted
over 2 years ago
by
Balmukund
3
Comments
On 4th May 2011 (Day 3), Amit Banerjee presented webcast on “ Understanding Performance Bottlenecks using Performance Dashboard ”. In this session Amit demonstrated how to troubleshoot a SQL Server performance issue using out-of-the-box features without...
Microsoft SQL Server Tips & Tricks
Presentation Material for Webcast on SQL Server Full Text Search
Posted
over 2 years ago
by
Balmukund
3
Comments
On 3rd May 2011 (Day 2), Sudarshan presented webcast on “Optimizing and Tuning Full Text Search for SQL Server”. This session covered all the key aspect of Full Text Search which is responsible for the scalable and secure but optimized full text search...
Microsoft SQL Server Tips & Tricks
Presentation Material for Webcast on SQL Server Resource Governor
Posted
over 2 years ago
by
Balmukund
3
Comments
On 2nd May 2011 (Day 1), I presented webcast on “Managing and Optimizing Resources for SQL Server”. This was a basic session to show capabilities of resource governor feature in SQL 2008. We have been asked about the slides, video and demo by participants...
Microsoft SQL Server Tips & Tricks
Service broker concepts and troubleshooting
Posted
over 2 years ago
by
Harsh Chawla
2
Comments
In this presentation you will learn about what's service broker and it's basic troubleshooting steps: Presented By: Vijay Rodrigues, Support enginner, Microsoft GTSC
Microsoft SQL Server Tips & Tricks
How to configure and monitor log shipping in sql server
Posted
over 2 years ago
by
Harsh Chawla
3
Comments
In this presentation, you will learn about how to configure and monitor logshipping. Presented by: Anmol Bhasin To download this video, please click on link
Page 1 of 1 (10 items)