SqlServer-QA.net

Hi Fais You haven't mentioned what kind of issues you are having with this script, see the blog posts here  http://sqlserver-qa.net/blogs/tools/archive/2008/04/29/sql-server-2005-adhoc-script-to-perform-backup-restore-and-integrity-checks-optimization-jobs-without-database-maintenance-plans.aspx that highlights the script you can ...

when i check the task manger , i see sqlserver is 150 meg but virtual memory goes up to 1.5g and never comes down Please help

OK - so this has been frustrating me for many months... when you create indexes with included columns (which was a new feature of SQL Server 2005), they're not shown by sp_helpindex or by DBCC SHOW_STATISTICS. I understand this not showing for statistics because included columns are not factored into the histogram (that's only the high ...

Hi, Context :  -I have a dimension ''MyDimension'' with a parent-child hierarchy ''MyHierarchy'' with 6 levels from ''Level 02'' to ''Level 07'' -I have a measure dimension ''MyMeasuresDimension'' with a measure ''MyMeasure'' Question : I would like to know how to return a table like this (the first line is the title bar, the second line ...

Fais Your list of steps are simple and clear to follow and I hope you have tested them already. If not for a simulation make sure to go through on a virtual server (non0clustered) to give you more in hand experience. This is required to get a feel of how you are going to manage the upgarde tasks, as it may not be as easy it said, and I would like ...

Microsoft Synchronization Services for ADO.NET provides the ability to synchronize data from disparate sources over two-tier, N-tier, and service-based architectures. Rather than simply replicating a database and its schema, the Synchronization Services application programming interface (API) provides a set of components to synchronize data ...

OK, I still have a way to go in learning about data compression in SQL Server 2008 but one thing that I do know is that nothing is free. So, the trade-off will be performance (i.e. CPU) v. space. And, that's not really a new trade-off wrt to compression. Sometimes that trade-off has other benefits that still minimize the ...

OK, have you ever been working on one thing...that led you to another (and another and another) and then you seem to have lost hours? OK, I know. That's our life [in the computer industry and I'm sure others!] - putting out fires and chasing strange behaviors that we eventually call ''gremlins'' when we really can't figure them ...

New Knowledge Base articles are added for SQL Server 2005, Here are the links  FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005FIX: You receive an incorrect result when you use a SQL Native Client provider to read the ...

Is your issue resolved!! If so share it with us here as it may help others as well.