Other SQL Server Blogs around the Web

The above error was returned on a SQL Server 32 bit system that is used for an inventory application, the initial though on out of memory was to see what is the resource usage at that moment as the SQL Server memory settings are set to DYNAMIC and all necessary AWE settings are enabled. As you may be aware that a 32-bit SQL Server, the ONLY thing that can use memory above the 4GB line is the buffer cache. Say if you have the /3GB switch set, then SQL Server with any other applications on the server...(read more)

What is the most required task when a DBA required to perform upgrade from previous versions? Complete understanding of the databases that are required to upgrade. Technical reference of upgrade path from previous version to the current one. Testing of all aspects of that upgrade tasks. Documented information of upgrade path and processes. 2 of the above tasks are totally dependant on individual preferences such as understanding and documentation about their platform and procedures. It is obvious...(read more)

This is the new tagline for Microsoft TechEd 2009 conference - potential lives here! As you may be aware that this year's 2008 in Orlando has been conducted in 2 weeks by dividing Dev & IT-PRO, now upcoming Tech·Ed North America 2009 is moving back to a single week covering both audiences. This change in format was based on feedback from developer and IT professional communities, I feel this is best to keep it all in one-week and also Microsoft announces 2009 one as Seventeenth year. No doubt...(read more)

What Makes a DBA is a real Database Administrator Indeed? This looks like a small question but it requires a big answer to complete the definition of what makes a real DBA! Another question arises for the DBAs that how many servers/databases you manage? Not only that many forget that there are 2 different types of DBAs, Development & Production. A development DBA typically must be an enterprise's creative DBA in order to reasonably fulfill an obvious creative role. A development DBA should begin...(read more)

SQL Server 64 bit edition, a primer to address the requirements surrounding applications and data are growing in complexity and size. Many applications running on 32-bit platforms today are approaching or have exceeded the limits of the platform, specifically regarding the number of processors and addressable memory. Not only for data explode there is a particular are where the scalability & performance for architecture has become prime responsibility to keep up the high availablity, not to mention...(read more)

Row_number() function is used to generate row number to rows based on the column which is ordered What if you want to generate row number without ordering any column Here is the method (Consider Suppliers table from northwind database) 1 Assign dummy column with literal 0 and order it by that column select row_number () over ( order by order_col ), companyname , address from ( select companyname , address , 0 as order_col from northwind .. Suppliers ) as t 2 Assign dummy column with literal 0 directly...(read more)

SQL Server 2008 is on full-fledge now and I haven't had a chance to look at Analysis Services part of it, recently had an opportunity to go through to convene a proof of concept project at work place. As the documentation refers this version of Analysis Services, special emphasis was taken to improve the performance in the execution of MDX calculations. Also the engine architecture has been enhanced for better performance with a chance to optimize your MDX code. To give more information on these...(read more)

The SQL Server 2008 Technical Reference Guide has just been released, covering the essential steps and best practices to upgrade existing 2000 and 2005 instances to 2008. There is also a list of other upgrade resources available at http://msdn.microsoft.com/en-us/library/cc936623.aspx These guides are intended to suppliment the information already available in SQL Server 2008 Books Online....(read more)

With reference to the subject line: [UK Government Helps You] as stated its a SPAM email that you might get in this Credit Crunch season that SPAMMERs are targeting the vulnerable users to obtain their personal details. Here I would like to present the email that you may get: ----- Original Message ----- From: Uk Government [ mailto:Helps@directgov.gov ] Sent: Saturday, November 22, 2008 5:11 AM Subject: UK Government Helps You Hello , UK Government has decided to help you .Ministry of Finance has...(read more)

Its the last day of SQLPASS Summit 2008 and in few hours time I will be presenting my talk (first time in US SQLPASS) on " Effective Usage of SQL Server 2005 Database Mirroring, what's new in SQL 2008 " topic which is an enhanced version of what I have presented before in SQLBIts UK during September 2007. Just a highlights on the session: High Availability solution from SQL Server, since version 2005 your SQL Server database availability and high performance solution can be delivered using Database...(read more)

The News is out for next SQL Server release!! During the Keynote presentation by Ted Kummert at PASS conference, Microsoft announced future capabilities for application and multi-server management as part of the SQL Server code-name “Kilimanjaro” release. This release is concentrated on multi-server management to reduce the complexity and ambiguity around developing, deploying, and managing applications across the application lifecycle. A new application model and management point development within...(read more)

Cumulative Update package 2 has now been released for SQL Server 2008. See the following KB article for full details: http://support.microsoft.com/kb/958186/en-us...(read more)

Another set of Cumulative Update package is ready for review on SQL Server 2008 - this package contains hotfixes for the issues that have been fixed since the release of SQL Server 2008. Earlier posting on Cumulative Update Package 1 for SQL 2008 one of the user asked me how to find out how many update packages were released after SQL Server 2008 RTM is released, the answer is refer to this KBA956909 for more information. As per the notes on the KBA958156 : A supported cumulative update package is...(read more)

PERFMON and Resource Governor - two great tools in hand for a DBA to monitor/resolve the performance problems, agreee! Back in olden days you may remember about SQLDiag and PSSDiag, the utility used as a general purpose diagnostics collection utility that can be run as a console application or as a service. Both of these Diag tools are helpful to collect logs and data files from SQL Server and other types of servers, and use it to monitor your servers over time or troubleshoot specific problems with...(read more)

In Forums sometimes I read questions on how to find out the difference between two times which are stored as float Here are some possible answers declare @t1 char ( 5 ), @t2 char ( 5 ), @sum float select @t1 = '12.56' , @t2 = '7.58' set @sum = cast ( @t1 as float )- cast ( @t2 as float ) --Method 1 : Convert to Datetime select convert ( varchar ( 5 ), dateadd ( day , 0 , replace ( @t1 , '.' , ':' ))- dateadd ( day , 0 , replace ( @t2 , '.' , ':' )), 108 ) --Method 2 : Number caculation1 select case...(read more)