Browse by Tags
All Tags »
SQL Server (RSS)
Say you are one of those users who have been using SQL Server since 6.x days. And say you remember that in those versions there was the possibility to backup or restore a single table. Let's try hard to imagine your memory is good enough to be able to
Read More...
I had a customer who was receiving the "Cannot generate SSPI context error" when one, and only one, of his users with a specific domain account tried to log into a SQL Server 2005 using TCP network library and Windows Authentication. It ended
Read More...
It seems Cumulative Update 6 (due in mid Feb 08) for SQL Server 2005 Service Pack 2 will include a code change so that performance counters show current performance values while the service is running, no matter what the service state was when perfmon
Read More...
Let's imagine that your instance of MSDE cannot be brought online because of any reason, like when your master database became corrupted or the their files are unavailable. Under such circumstances, if you try to rebuild the master database with a command
Read More...
A colleague approached me yesterday because he was finding the following entry ( marked in red below ) in his ERRORLOG, and he was worried because he thought the recovery of the ABC database was taking longer because a CHECKDB was run on it during the
Read More...
This is the Spanish version of this other post. Esta vez sólo deseo anunciar que mi compañero Jorge "George" Pérez Campo y yo mismo tenemos planes para comenzar una serie de artículos con ejemplos simples que demuestren,
Read More...
Ésta es la versión en inglés de este otro artículo . This time I just wanted to announce that my colleague Jorge "George" Pérez Campo and myself have plans to start posting some simple examples to demonstrate, from a
Read More...
This is another problem I've been working on recently, whose resolution I felt could be interesting to share here. Let's first reproduce the errors, before trying to explain anything. So, please, connect to your instance of SQL Server 2005 and run this:
Read More...
Have you ever experienced this error in SQL Server 2005 and under the same circumstances, but using SQL Server 2000 instead, you never "suffered" this problem? This issue was recently raised to my attention. And its resolution I found it of general interest,
Read More...
A colleague reported to me what she considered a weird behavior, she was experiencing while trying to monitor her SQL Server 2005 instances' performance counters. Her main concern was this: Why do my SQL Server 2005 counters do not report actual values,
Read More...
I have been working on a case where a customer reported that, once he plugged in his custom assembly which implemented a set of SqlFunctions and he invoked those functions from T-SQL, SQL Server started eagerly eating all memory and performance dropped
Read More...
Even though the documentation doesn't explicitly explain the existence of this limitation, a failover clustered instance of SQL Server (whether it is 2000 or 2005) doesn't support loading data or log files of any database from disks other than those which
Read More...
Somebody told me today that he was using SQL Server Management Studio Database Properties (Files Page) to try to set the Initial Size property of a database file to a value lower than the one currently set for that file on the server. And even though
Read More...
After a long time, I had the opportunity to meet again my colleague and friend Eladio , who is a well recognized Mentor working at Solid Quality Mentors . He was delivering some training sessions to Microsoft customers in our premises today. In one of
Read More...
One colleague recently asked me, is the information in this article 914278 (How SQL Server 2005 Express Edition determines the CPU count and uses the CPUs during processing) was also applicable to the Standard Edition of SQL Server 2005? And following
Read More...
