Browse by Tags
All Tags »
MS Sql server (
RSS)
We all take a database backup as a first resort to recover from a damage occur during the disaster / server crash / for any other reason if require to recover or restore our data back to its previous stat as it was before the database server was crashed...
There will be a web cast on SQL Server 2008 Capabilities for Meeting PCI Compliance Needs at 1 PM Pacific Time, get register http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032404173&EventCategory=4&culture=en-US&CountryCode...
Hi, We have formed a Technical Community User Group. The aim of this User Group is to share/exchange what all we have in terms of the knowledge. We have two separate forums for MS SQL and for Dot Net technology to avoid confusion. You may post all your...
It would be a good time again.... Microsoft Virtual Techday (VTD) is back; below is an agenda http://www.virtualtechdays.com/agendaday1.aspx Get registered!! SQL Server from my Eye - Hemantgiri S. Goswami Read More...
SQL Server 2008 November CTP is available for download, click here to grab your copy of SQL Server 2008 Here are some more resources on SQL Server 2008 SQL Server 20008 Product Overview SQL Server 2008 Videos SQL Server 2008 White Papers SQL Server 2008...
Since some times their is a discussion on what's new in SQL Server 2008 , when the reference material will be available!! Here is an answer to this, Microsoft has introduce a course at its E-Learning, the course aims to educate IT Professional who...
* SQLAgent service should run under same domain account, which has local admin privilege and “Log in as a service” permission. This requires on both the server. In case, if SQL Server is not part of any Domain. We can use the user account which has identical...
Many time it happens we were wrong with the Estimation of Table Size, wrong estimation of Row Size can trouble us with the growth of the database and ultimately we are ending up with the space crunch, and all this because of wrong Estimation of Table...
Most of the time I come accross the thread wherein user has requested to get started with stored procedure performance tunning , so here are some good reference material for tunning stored procedure http://www.sql-server-performance.com/tips/stored_procedures_p1...
Most of the time I come accross the thread wherein user has requested to get started with stored procedure performance tuning , so here are some good reference material for tuning stored procedure and optimize stored procedure for performance http://www...
The question I recently come accorss on SQL Server Performance, the OP was asking on "How to automate profiler trace" , their are system stroed procedure that can be used to automate profiler trace. The system stored procedure you can use are...
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 2005 FIX...