NEWSEQUENTIALID() defect in SSMS. Wasn’t it fixed already in SQL 2012 RTM?

I have recently received this question from different sources, so I think it’s worth documenting why some people still see validation error for the default value of a column when it’s defined as a NEWSEQUENTIALID() built-in. The tracking defect on Connect (https://connect.microsoft.com/SQLServer/feedback/details/472092/newsequentialid-bug-in-management-studio) keeps receiving complains about the observed, undesired behavior. It’s been fixed in Denali…

0

What OLEDB providers should you expect to show up under the Providers node in SSMS?

  The short answer is: Those returned by master.dbo.xp_enum_oledb_providers. But let’s dig deeper and try to give you the detailed description you deserve. The triggering reason why I’m writing about this is because a colleague described the following situation in one of our internal lists: I designed a OLE DB Provider, and want to register…

0

Even if some client tools in SQL seem to be forward compatible with later versions, you may be missing something important

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 marks?       Here goes my explanation to this problem: New execution…

0

Inaccurate values for “Currently allocated space” and “Available free space” in the Shrink File dialog for TEMPDB only

Last week I went to a customer who showed me the following weird information.   He opened SSMS (SQL Server Management Studio) 2008 R2 and connected to one particular instance of SQL Server 2008 R2 in which he observed this behavior we wasn’t able to reproduce with any other.   From the Object Explorer window,…

2

Glitch in SMO causes an error when you attempt to create an FTS Catalog/Table Population Schedule under very specific circumstances

If you connect from SQL Server Management Studio (SSMS) to an instance of SQL Server, whether it is named or default, and rather than using the proper machine name (or machine name followed by the instance name, separated by the backslash) you use either an alias (created using SQL Server Configuration Manager, through the corresponding…

0

Clicking on the XML link containing a query plan doesn’t display the graphical plan but opens the XML editor instead

Recent Note: SQL Server 2008 R2 Service Pack 1 Cumulative Update 4 (10.50.2796.0) is the first build servicing showplanxml.xsd with the updated version. So, install that CU to get rid of this problem. Last week, while working with a customer in the optimization of some of his queries, he raised to my attention that his…

1

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

SQL Server Import and Export Wizard blowing up due to an unexpected error

  Somebody was trying to run the SQL Server Import and Export Wizard (DTSWizard.exe) in one of his machines, but when he clicked Next on the first (welcome) dialog, it showed the following error:     =================================== This wizard will close because it encountered the following error: (Microsoft SQL Server) —————————— For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476…

2