TMP/TEMP/USERPROFILE environment variables: the closer they point to, the better

One recent discovery I wanted to eventually share here. Many more programs than you would expect, store information in temporary files. If you configure your environment so that those temporary files get created in a remote location, you will suffer the painful performance effect. I had no idea this worked this way behind the scenes….

1

Next week (Tue 26th/Wed 27th), you cannot miss it! See you at Microsoft TechDays {The Evolution Show} in Madrid

I’ll be there, morning to evening, both days (26th and 27th) responsible for an area we have called "Rincón técnico de SQL Server" (SQL Server Technical Corner) where "Ask The Expert" sessions will be running virtually non-stop. I’ll also be participating in a few sessions. One of them (26th @ 12:30 AM in the Expo…

1

What does it mean that BACKUP TABLE / RESTORE TABLE are not "yet" implemented?

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 recall the exact syntax you used…

2

I just had to re-publish a previous post because I had made an important mistake

In red I highlighted the changes I’ve introduced to explain what was wrong in the original version of A tale about solving "Cannot generate SSPI context" and later "[DBNETLIB][ConnectionRead(recv()).] General network error. Check your network documentation" in a shot Sorry for any inconveniences this mistake could have caused.

0

A tale about solving "Cannot generate SSPI context" and later "[DBNETLIB][ConnectionRead(recv()).] General network error. Check your network documentation" in a shot

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 up being caused by the fact that the default MaxTokenSize of 12,000…

1

How an apparently innocent antivirus could kill your SSIS package performance?

Interesting story this one. I’ve been working with a customer who had a very simple package which consisted of a Sequence Container including an Execute SQL Task (which truncates the destination table) followed by a Data Flow Task. The Data Flow Task contained an OLE DB Source (a SQL Server 2000) and an OLE DB…

3

SQL Server performance counters’ library improvement

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 was initially started up. The effect of that original design I…

1

Good News!

I’ve just discovered that Cumulative Update 6 (due in mid Feb 08) for SQL Server 2005 Service Pack 2 will include a fix for the Analysis Services Redirector reliability issue I explained in my previous post.

1

How to rebuild your master database in MSDE when it became corrupted?

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 line similar to this one setup INSTANCENAME="MYINSTANCE" SAPWD="mySAPWd" REINSTALL=ALL REINSTALLMODE=a /I Setup\SqlRun01.msi /L*v…

1

Scared because SQL Server seems to be running a DBCC CHECKDB on some of your databases on every startup?

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 recovery process:   2008-01-15 13:13:04.97 Server      Microsoft SQL Server 2005 –…

0