|
|
NEW! - Remote Monitoring & DBA Services
Front Page News
-
|
To followup from The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure blog post, here are few findings that I would like to share. When you see that SQL Server instance...
|
-
|
Government of India has started the process & project of implementing the Unique Identification (UID) project for whole of India. For those who don’t know what it is find more about this initiative and see this PDF attachment too. Another face and...
|
-
|
Here is the information about Windows Operating System support life cycle that you need to concentrate: With the end of support (EOS) coming for several products, moving to Windows 7 and utilizing the many features built into the product can help you...
|
-
|
A typical error occurred when a simple SSIS package has been executed to export 500 rows to another SQL instance, not once atleast 3 times! More information on error text from event viewer that has been generated by the 'service; The buffer manager failed...
|
-
|
SQL Server has a wealth of Dynamic Management Views (DMVs) to get you health status of the platform. All the data will be extracted with a query, set of transactions and many more ways, in this case you had to be careful with transactions, because whenever...
|
-
|
Every now and then I see this big question from SQL Server users that when to use a stored procedure? Well there is a second part to this question as well, think about caching of such stored procedures There is no such database management software that...
|
-
|
Every database object will have a sort of dependency between them, such as a stored procedure to run few queries against a table. Similar to this whenever a SP or query is executed then a compiled plan will be generated by the SQL query optimizer, to...
|
-
|
Do you work with or use SharePoint © ? If so, we would love to hear how you use it! Your valuable input will help make the next version of SharePoint. Also, by completing the survey you will be entered into a sweepstakes giveaway for a Zune 8 GB (choice...
|
-
|
Product: Microsoft SQL Server 2008 Standard & Microsoft SQL Server 2008 Enterprise Editions Notification Contents: New and Major Modifications A Java application crashes when it connects to SQL Server 2008 by using Java Database Connectivity Driver...
|
-
|
Here is the advisory guidelines email from Microsoft Security that I would like to share: Microsoft is aware of public exploit code released that impacts customers using Internet Explorer 6. Customers using Internet Explorer 8 are not affected by currently...
|
-
|
Here is an exciting news for SQL Server 2008 R2 CTP users, DataPlatform-Insider blog confirms that .. will be listed on Microsoft’s May price list, and will be available by May 2010 . Before we conclude on few points I believe there is a need to get another...
|
-
|
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications FIX: The LogReader agent unexpectedly consumes all CPU resources when the agent handles...
|
-
|
Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications FIX: Connector 1.0 for SAP BI throws an exception when data is being loaded in parallel in a SSIS 2008 package http://support.microsoft.com/kb/975058/en-US...
|
-
|
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications SQL Server 2008 setup may fail with "Setup Failure in SetupActionName: <action name>"...
|
-
|
I believe most of the Enterprises are interested to deploy a software when the service packs are associated with it to fix most of the bugs from RTM release, SQL Server is no excuse for that reason. Its an interesting campaign to see and now it is time...
|
-
|
I believe most of the Enterprises are interested to deploy a software when the service packs are associated with it to fix most of the bugs from RTM release, SQL Server is no excuse for that reason. Its an interesting campaign to see and now it is time...
|
-
|
It is a common criteria that using Dynamic Management Views (DMVs) you can easily obtain the system & database state on a SQL instance. It may not be easy for a starter DBA to ensure what kind of DMV is used to obtain information on Recent Expensive...
|
-
|
My co-worker had a task of finding minimum alternate week day as of today for a given date and day Consider these data Date : 2009-12-22 day : 5 (it denotes Thursday) It means the event was scheduled on 2009-12-22 which should run on every alternate Thursday...
|
-
|
Its the time again that you should re-visit your database platform to ensure none of the SQL instances fall within SQL Server 2005 Service Pack2 or SQL Server 2008 RTM editions! It is quite common scenario that few of Enterprises may not ...read more...
|
-
|
Its the time again that you should re-visit your database platform to ensure none of the SQL instances fall within SQL Server 2005 Service Pack2 or SQL Server 2008 RTM editions! It is quite common scenario that few of Enterprises may not have gone to...
|
-
|
SQL Server Migration Assistant is one of best used tool when there is a huge effort required to migrate the database from other data sources such as MS Access, Oracle & MySQL. As a part of Microsoft Partner network communication I have received this...
|
-
|
No doubt that the error on subject line will get no where! This is presented when trying to open a Database Properties using SQL Server Managment Studio, going back to history on the SQL instance where this is presented is an upgraded database instance...
|
-
|
One of the questions asked in a forum was about replacing data of one table by the data of another table The solution that the questioner used was having cursor by looping through the source table and replace particular words by other words from another...
|
-
|
Its a old story that Oracle agreed to acquire Sun Microsystems, which means popular Open Source database application will be affected aka MySQL. As Sun already acquired MySQL in the previous year and a recent marriage of closed source database would get...
|
-
|
In the Query Analyser, set the Result mode to Text (Press CTRL+T) and run the following code set nocount on select space ( 17 - len ( replicate ( char ( 94 ), no )))+ replicate ( char ( 94 ), no * 2 - 1 ) from ( select top 10 row_number () over ( order...
|
|
|
|