Browse by Tags

Whats with 64 bit computing on SQL Server

Published 4 August 7 9:41 AM | SSQA.net

What advantages we took when deployed the 64-bit computing within SQL Server As you aware 64 bit computing with 64-bit processors have become the standard for systems ranging from the most scalable servers to desktop PCs. The way to take full advantage...

Filed under: sql server, performance, management, ssis, security, ssas, ssms, ssrs, x64, computing

Anti-virus tool on SQL Server

Published 18 May 7 9:33 AM | SSQA.net

Another common question in the forums asking about what are the best practices for using antivirus software on servers running SQL Server. In my experience if your SQL Server is not a internet-faced one then no need to have one installed on a SQL Server...

Filed under: sql server, management, microsoft, ssis, security, ssas, ssms, ssrs, search, anti-virus, kba

DBCC CHECKDB flusing the cache!

Published 15 May 7 9:54 AM | SqlServer-QA.net (SSQA)

Well another cache related blog in a row since last few days! I have had weird issues on one of the SQL Server 2005 SP1 instance that, whenever DBCC CHECKDB is executed the performance of particular stored procedure ( complexed calculations ) has gone...

Filed under: sql server, management, ssis, security, ssms, perfmance, cache, flush, checkdb

Get to know new and enhanced business intelligence features in SQL Server 2005

Published 1 May 7 3:19 AM | SqlServer-QA.net (SSQA)

Microsoft is investing a lot to help the Business Intelligence (BI) platform users with the content and get acquaintance to the platform. You are aware BI includes SQL Server Analysis Services, Integration Services and Reporting Services, you can get...

Filed under: sql server, management, microsoft, integration, ssis, ssas, ssms, ssrs, services