Archives for Database Technology

Converting from hex string to varbinary and vice versa

Converting hexadecimal values to varbinary and vice versa is now easier using the XQuery functionality available from SQL Server 2005. The code samples below show how to perform the conversion(s): – Convert hexstring value in a variable to varbinary: declare @hexstring varchar(max); set @hexstring = ‘abcedf012439′; select cast(” as xml).value(‘xs:hexBinary( substring(sql:variable("@hexstring"), sql:column("t.pos")) )’, ‘varbinary(max)’) from […]

Converting from Base64 to varbinary and vice versa

Converting Base64 values to varbinary and vice versa is now easier using the XQuery functionality available from SQL Server 2005 onwards. The code samples below show how to perform the conversion: – Convert Base64 value in a variable to varbinary: declare @str varchar(20); set @str = ‘3qAAAA=='; select cast(N” as xml).value(‘xs:base64Binary(sql:variable("@str"))’, ‘varbinary(20)’); – Convert binary […]

SQL Server 2005 Performance Dashboard Reports

The SQL Server 2005 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature introduced in the SQL Server 2005 SP2 release of SQL Server Management Studio. The reports allow a database administrator to quickly identify whether there is a current bottleneck on their system, and if a […]

SQL Server 2005 SP2 has been released…

SQL Server 2005 Service Pack 2 has been released. You can find more information from the service pack 2 page. This service pack extends the functionality of SQL Server in many ways. The What’s New document highlights the major changes in the Database Engine, Analysis Services, Integration Services and others. The service pack also has […]

New trace flag for deadlock output and profiler deadlock event enhancement

Did you know that SQL Server 2005 adds a new trace flag (-T1222) for deadlock trace output? This deadlock output has numerous improvements over older versions of SQL Server. For example, some of the enhancements of the new grace flag are:   1. XML like output for the deadlock 2. Execution stack at the time of […]

New whitepapers on physical database storage and tempdb…

Below are links to two new whitepapers from the storage engine team. Please check it out to get better understanding of the new features in SQL Server 2005 and enhancements.   Working with TempDBhttp://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/WorkingWithTempDB.doc Physical Database Storagehttp://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/PhysDBStor.doc Read full article…

Using catalog views in SQL Server 2005

Did you know that the catalog views in SQL Server 2005 exposes metadata for various objects in a database and at the server-level? This is the preferred method of accessing metadata. It is a much richer mechanism that doesn’t require access to system tables or undocumented columns or status bits. If you want standard and portable […]

Download SQL Server 2005 SP2 CTP

SQL Server 2005 Service Pack 2 (SP2) CTP has been released. You can provide feedback on the CTP release via http://connect.microsoft.com/sqlserver. The link for the various downloads is: http://www.microsoft.com/sql/ctp.mspx SQL Server 2005 SP2 CTP contains some new features in the database engine (vardecimal data types, object_name function enhancement, logon triggers, Common Criteria Compliance, sys.dm_exec_text_query_plan DMV, […]

SQL Server 2005 SP2 December CTP is available for download

SQL Server 2005 Service Pack 2 December CTP is available now for download. You can download it from: http://www.microsoft.com/downloads/details.aspx?FamilyID=d2da6579-d49c-4b25-8f8a-79d14145500d&DisplayLang=en Note that the December CTP has been published to the same location as the November CTP so if you come from the SQL Server 2005 CTP Home Page and get to December CTP don’t be confused. […]

Database Applications Profile Survey in http://connect.microsoft.com/sqlserver

My team (Data & SQL Storage Performance Team) is conducting a survey on http://connect.microsoft.com/sqlserver to better understand SQL Server workloads. The connect link below will take you directly to the survey:   https://connect.microsoft.com/SQLServer/Survey/Survey.aspx?SurveyID=2226   Please consider providing your workload characteristics and hardware configuration to help us better understand the workloads that run on SQL Server. […]

Page 1 of 2:1 2 »