November 2007 - Posts

Select columns from (EXEC Procedure_name) - Is this possible?
Published 26 November 7 6:54 AM | SSQA.net
Well.I see many users asking this question in forums. "I have a procedure that returns single resultset. How do I filter the result returned from the procedure? There are, at least, two ways to acheive this Let us create this procedure create procedure...
Filed under: , ,
How to get a list of SQL Server 2005 builds that were released after Service Pack 2 was released?
Published 23 November 7 8:51 AM | SSQA.net
Since the release of SQL Server 2005 Service Pack 2, Microsoft development team has released various builds that are classed as Cumulative Updates. Also we blogged on this site - CumulativeUpdate4 & http://sqlserver-qa.net/blogs/tools/archive/2007...
Filed under: , , , , , , , , ,
Tuning options for SQL Server 2005 that is running in high performance workloads
Published 22 November 7 4:28 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Filed under: , , , ,
Error message when you try to replicate a table from SQL Server 2005 to SQL Server 2005 Mobile Edition: "HRESULT 0x80004005 (0)"
Published 21 November 7 4:25 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Error message when you try to replicate...
Filed under: , , , , ,
FIX: All later commands are ignored after the SQLDescribeParam function returns an error message in a SQL Server 2005-based application that uses the SQL Native Client ODBC provider
Published 21 November 7 3:12 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Filed under: , , , , , ,
You may receive an error message when a SQL Server 2005 client requests encryption and connects to 127.0.0.1 on a Windows XP-based computer
Published 20 November 7 3:9 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Filed under: , , , , , , ,
Random Password Generator
Published 20 November 7 7:29 AM | SSQA.net
This is one of the methods to generate 8 chracters password randomly (combination of alphabets,numbers and special characters) declare @password varchar(8) set @password='' select @password=@password+char(n) from ( select top 8 number as n from...
Filed under: ,
SQL Server 2008 November CTP 5 - next instalment is available
Published 20 November 7 2:49 AM | SSQA.net
Here comes another instalment of SQL Server 2008 for the CTP fans. The SQL Server 2008 November CTP has been released to the connect.microsoft.com website and is available for download here . One of the improvements in this build is the ability to persist...
Filed under: , , , , , , , , ,
Installing SQL Server Integration Services on 64-bit Computers
Published 19 November 7 8:29 AM | SSQA.net
I had tough time working with Integration Services (SSIS) on one of the 64 bit machine that will be used for a 24/7 based application. So here goes my ranting and things you need to take care when having installation of SQL Server 2005 on 64 bit platform...
Filed under: , , , , , , , , , ,
You may receive an error message when you try to export a table by using the SQL Server Import and Export Wizard
Published 18 November 7 3:15 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
Filed under: , , , , , , ,
FIX: Message when you click the Back button in Internet Explorer 7 to return to a SQL Server 2005 Reporting Services report that contains one or more DateTime parameters: "Report is being generated"
Published 17 November 7 3:16 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: Message when you click the Back button in Internet Explorer 7 to return...
Filed under: , , , , , ,
List of modified Knowledge Base articles in SQL Server 2005 Enterprise X64 Edition
Published 16 November 7 5:14 PM | SSQA.net
The following pages were recently modified, rather than posting each as a blog post I have included them here: Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: A gradual...
Filed under: , , , , , , ,
FIX: An empty string is replicated as a NULL value when you synchronize a table to a SQL Server 2005 Compact Edition subscriber
Published 16 November 7 3:5 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: An empty string is replicated as...
Filed under: , , , , , ,
SQL Server: How do I identify the queries that are worth tuning?
Published 16 November 7 7:2 AM | SSQA.net
Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible...
Filed under: , , , , , , , , ,
Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?
Published 16 November 7 4:53 AM | SSQA.net
I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out...
Filed under: , , , , , , , , , , , , ,
Error message when you connect to a named instance of SQL Server on a client computer that is running Windows Vista or Windows Server 2008: "Specified SQL server not found" or "Error Locating Server/Instance Specified"
Published 16 November 7 12:18 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Error message when you connect to a named...
Filed under: , , , , , , ,
FIX: You receive an error message when you use Microsoft OLE DB Provider for Visual FoxPro in SQL Server
Published 15 November 7 3:2 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: You receive an error message when you use Microsoft OLE DB Provider for Visual...
Filed under: , , , , ,
If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?
Published 15 November 7 9:41 AM | SSQA.net
Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must...
Filed under: , , , , , , , , , , ,
Identifying top 20 most expensive queries in terms of read I/O (referred from Technet Magazine)
Published 15 November 7 7:16 AM | SSQA.net
It is worth mentioning the valueable query I have been through when referring to Technet Magazine, the following query has given me useful information in finding out what are my top 20 most expensive queries that are consuming most of disk I/O (read &...
Filed under: , , , , , , , , , , ,
CHECKDB From Every Angle: How long will CHECKDB take to run?
Published 14 November 7 10:22 PM | SSQA.net
This is a subject I posted about last year on my old blog but it came up at SQL Connections last week several times so I want to repost it for those who’ve just started following my blog. There's only one time when you should be trying to work out...
Filed under: , , , , ,
More Posts Next page »