Browse by Tags

All Tags » sql server » data (RSS)
SQL Server 2005 - How to compare content of tables without using third party tools?
Published 4 July 8 3:36 AM | SSQA.net
You may be aware about using Third party tools to compare the data between 2 tables. Using SQL Server 2005 you need not entirely dependant on such requirement, TABLEDIFF utility is the new addition to the SQL Server. This utility enables you to compare...
Filed under: , , , ,
SQL Server Data Services - get to know more about it!
Published 17 June 8 3:2 AM | SSQA.net
One of the best learning during Tech-Ed week was to know about SQL Server Data Services which might be suitable for the web-based platforms, type of what we have and 2 interesting features for me were 'Business ready SLA & Application Agility'...
Filed under: , , , , , ,
SQL Server 2005: What percentage of changes happened within the database after the last successful backup?
Published 21 April 8 3:1 AM | SSQA.net
No doubt that the blog subject will be a most wanted requirement on their databases, that is most responsible for a SQL Server database then arguably the most critical task that you absolutely MUST get right is your database backup procedures. Where the...
Filed under: , , , , , , , ,
SQL Server configuration disk layout - best practices from field
Published 3 April 8 3:17 AM | SSQA.net
Configuration of server such as disk and memory is an important factor for SQL Server Performance, there is all about questions within newsgroups and forums that how do I setup the disk layout for a SQL Server database (say, 2005 version). Not only this...
Filed under: , , , , , , , , ,
Strategy with SQL Server and Sharepoint together
Published 25 March 8 4:50 AM | SSQA.net
Managing SharePoint is about more than just backup, recovery, administration, or migration. An effective SharePoint strategy means being proactive, scrutinizing the entire platform (including SQL Server), and reducing your vulnerability. This white paper...
Filed under: , , , , ,
SQL Server 2005 Partitioned Tables and Indexes - learning curve
Published 12 March 8 3:1 AM | SSQA.net
When do you need data partitioning? The data you see in relational database may need such a strategy if the volume is huge, for instance the data to store event-log information having the schema such as: [Id] INT (make this primary key clustered), [Unit_Id...
Filed under: , , , , , , , , , , ,
Real-time replication with SQL Server reporting, strategies and resolution to the problems?
Published 30 January 8 12:23 PM | SSQA.net
Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always have a primary focus in providing protection for the data assets stored in SQL Server. Protection that...
Filed under: , , , , , , , , ,
10 Best Practices for Data Archiving - all platforms
Published 31 December 7 6:44 AM | SSQA.net
When you think about effective data management, archiving will also play important role to manage your data. In this regard Windows Magazine has included best practices for your data management. Data privacy and identity theft have a higher profile in...
Filed under: , , , , , , , ,
How to find subscriber is not getting upto date data?
Published 14 December 7 7:18 PM | SSQA.net
Run the following TSQL to get details of troubled subscribers that are not getting upto date data: select agent_id from msdistribution_status group by agent_id having sum(undelivCmdsInDistDB) >1000 order by sum(undelivCmdsInDistDB) desc...( read more...
Filed under: , , , ,
Best practices for Data Importing using SQL Server native methods
Published 26 October 7 6:8 PM | SSQA.net
Ever wondered SQL Server Data Importing Do's and Don'ts, with a set of best practices. Import of data is a common task in any database platform and when it becomes regular you have to take care lot of incompatibilities. In particular SQL Server...
Filed under: , , , , , , ,
No budget data appears in Microsoft Dynamics GP when you run the budget master package in Analysis Cubes for Microsoft SQL Server 2005
Published 18 October 7 1:41 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Analysis Cubes for Microsoft SQL Server 2005 Notification Contents: New and All Modifications No budget data appears in Microsoft Dynamics GP when you run the budget master package...
Filed under: , , , , ,
DBCC EXTENTINFO - unused pages in these extents (undocumented)
Published 4 September 7 7:45 AM | SSQA.net
When it comes to resolving table fragmentation, the basic checkout you perform is to run DBCC INDEXDEFRAG or even run DBCC DBREINDEX statements. As per the default configuraiton SQL Database Engine allocates a new extent to an allocation unit only when...
Filed under: , , , , , , , , , ,
FIX: Error message when you try to edit a SQL Server Agent job or a maintenance plan by using SQL Server Management Studio in SQL Server 2005: "String or binary data would be truncated"
Published 23 August 7 3:17 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 & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...
Filed under: , , , , , , ,
Table schema comparison and sometimes data too!
Published 9 July 7 5:11 AM | SSQA.net
Comparing data and/or schema within your SQL Server environment is a common task when you have to port the data from Development to Production environment. To compare the schema (tables) between the 2 SQL instances is very easy and you can accomplish...
Filed under: , , , , , , ,
Transaction Log Guidelines
Published 19 June 7 4:9 AM | SSQA.net
I always see many posts in the forums asking about transaction log backups and their importance. For the point in time recovery they are must in order to provide the data upto date or atleast that are committed. Yet I have seen many articles out there...
Filed under: , , ,
Building a Simple Recommendation Engine with SQL Server 2005 Data Mining
Published 6 May 7 4:59 AM | SqlServer-QA.net (SSQA)
When: Tuesday, May 15, 2007. 10:00 A.M.–11:00 A.M. Pacific Time The powerful recommendation engines that major e-commerce sites use to tempt customers into new and additional sales are one of the most visible uses of data mining. This technology often...
Filed under: , , , , ,