Sign in
MSDN Blogs
Microsoft Blog Images
More ...
Search
Common Tasks
About
RSS for posts
Atom
Archives
Archives
January 2013
(1)
December 2012
(1)
November 2012
(4)
October 2012
(5)
September 2012
(4)
July 2012
(13)
June 2012
(7)
May 2012
(3)
April 2012
(2)
March 2012
(2)
February 2012
(8)
January 2012
(8)
December 2011
(14)
November 2011
(7)
October 2011
(5)
September 2011
(3)
August 2010
(1)
July 2010
(3)
June 2010
(4)
May 2010
(4)
May 2008
(1)
February 2008
(6)
January 2008
(3)
December 2007
(25)
November 2007
(14)
Visitors log
Where you folks come from?
MSDN Blogs
>
La bodeguita de Nacho
>
November, 2012
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
La bodeguita de Nacho
How to set the default transaction isolation level server wide?
Posted
5 months ago
by
Nacho Alonso Portillo
0
Comments
Last week I was involved in a discussion about the default transaction isolation level used by the transaction objects in WCF’s services (Serializable) versus the one used by the transaction objects in Entity Framework for SQL Server (ReadCommitted) whose...
La bodeguita de Nacho
Even if some client tools in SQL seem to be forward compatible with later versions, you may be missing something important
Posted
6 months ago
by
Nacho Alonso Portillo
0
Comments
Today, a colleague exposed the following case: In the execution plan I do see some exclamatory marks on Sort, Hash Joins operators but there is no warning information available. I am using SQL Server 2012. How do I interpret the exclamatory...
La bodeguita de Nacho
Does larger TEMPDB log file affect the performance of startup of SQL Server?
Posted
6 months ago
by
Nacho Alonso Portillo
2
Comments
I invested some time today investigating what SQL Server does with the initialization of TEMPDB’s log file, because a question was raised last week during Robert Davis session on TEMPDB at SQL PASS Summit in Seattle, and I wasn’t sure about what the answer...
La bodeguita de Nacho
Are you one of those rare birds whom, while running batches that involve distributed queries, have encountered any of the following errors?
Posted
6 months ago
by
Nacho Alonso Portillo
0
Comments
3988 - New transaction is not allowed because there are other threads running in the session. 3930 - The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction. If so, I would...
Page 1 of 1 (4 items)