SQL Server Knowledge Sharing Network (SqlServer-qa.net)

Browse by Tags

• 2000
• 2005
• 32 bit
• 3gb
• 64 bit
• 703
• authentication
• best practice
• bigint
• blogs
• business intelligence
• certifications
• cluster
• clustering
• codeplex
• configuration
• database
• database build
• database state
• dba
• design
• difference
• digital
• dmf
• dmv
• dynamic sql
• error
• experience
• faq
• find
• forums
• full scans
• gotchas
• hack
• indexes
• installation
• instances
• int
• integration services
• links
• management
• mcdba
• mcit
• mcts
• media
• memory
• microsoft
• monitoring
• msdtc
• multiple
• network services
• newsgroups
• next release
• numeric
• open source
• pae
• performance
• reference
• resources
• restart
• schema
• script
• search
• security
• server
• server state
• services
• sharepoint
• signature
• ssis
• stored procedure
• table
• tasks
• technet
• tempdb
• third party
• tool
• tsql
• uninstallation
• united nations
• upgarde
• upgrade
• usage
• version
• visual studio
• website
• windows 2003
• windows 2008

• SQL Injection attacks - don't forget to visit guidance information from Microsoft

  One of the biggest threats in IT industry & Database world is unprecedented attacks aka most commonly termed as 'SQL injection'. There is no doubt that biggest database vendors, one of them as Microsoft so far providing recommendations regarding... Posted Jun 01 2008, 12:23 AM by satya with | with no comments Filed under: security, best practice, sql server, microsoft, authentication

• 3GB Memory & Windows Server 2003 Standard Edition - Interesting question & Valueable insight on resolution

  This is the question: I am configuring a server with Windows Server 2003 Standard Edition and SQL Server 2000 Enterprise Edition. The server has 4GB memory. From what I have read the AWE/PAE switch only works with Advanced Server or Datacenter Editions... Posted May 31 2008, 01:46 PM by satya with | with 2 comment(s) Filed under: sql server, server, pae, windows 2003, configuration, 3gb

• Refactoring Stored procedures on a SQL Server database?

  I would like to refer this Interesting thread that talks about advantages you can take with Profile when you have a need of refactoring the database objects between old & new versions, useful tips on the post too. Posted May 26 2008, 11:00 AM by satya with | with no comments Filed under: sql server, schema, script, stored procedure

• Best practices/Gotcha's when migrating 2k DB's to 2K5 box? (also 2K->2K)

  Here is another interest forum post that will talk through the best practices, gotchas and FAQ when you are performing a database upgarde from SQL Server 2000 to 2005 version. Post link . Posted May 25 2008, 04:56 AM by satya with | with no comments Filed under: best practice, sql server, blogs, faq, gotchas, links, upgarde

• SQL Server installation error 703 : An INternal read error occurred on media <path>, unable to load the installation information...

  One of the forum user reported about an error they are getting when trying install SQL Server 2000. By default you need to have Administrator rights on the server where you are trying to install the SQL Server binaries, in this case the user has used... Posted May 19 2008, 10:42 AM by satya with | with no comments Filed under: media, sql server, installation, 703, error

• SQL Server Performance issue - high value for Full Scans/sec?

  One of the intersting post in forums and replies to them: I recently took a new position as the DBA for a web app company. Getting to understand the performance issues that are a major concern for the company I have started monitoring the servers. The... Posted May 15 2008, 11:57 AM by satya with | with 1 comment(s) Filed under: sql server, performance, forums, table, full scans, tempdb

• SQL Server 32 bit and 64 bit, what is the major difference?

  This is anothe FAQ within the forums about what is the major difference between 32 bit and 64 bit application, well the answer you get is Memory. I feel there is much more associated between them, follow this ForumDiscussion topic for more information... Posted Mar 17 2008, 01:28 PM by satya with | with no comments Filed under: sql server, 2005, performance, management, 2000, difference, 64 bit, memory, 32 bit

• SQL Server multiple instances and resource utilization - best practices

  A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Should you configure each of the instances to use specific portions of the available Operating System... Posted Mar 14 2008, 02:28 PM by satya with | with 2 comment(s) Filed under: best practice, sql server, indexes, performance, management, multiple, clustering, instances, monitoring

• Database design - choosing required data type for numeric values

  Here is the forum post I found interesting and suggestions to keepup when you have a data (numeric) in place in large scale, here is the Running-out-of-integer-space forum post. Posted Mar 10 2008, 12:28 PM by satya with | with no comments Filed under: sql server, schema, database, int, bigint, design, numeric

• Integration Services Package performance tuning - 5 tables betwenn 5000 and 15 million rows

  Wanted to stroll interested (best suggestions) posts on the forums here and recently this 25701 topic has very good tips & tricks in managing performance your Integration Services packages that will need to deal huge number of rows (such as in millions... Posted Mar 03 2008, 02:35 PM by satya with | with no comments Filed under: best practice, sql server, forums, ssis, blogs, integration services

• Strategy with SQL Server and Sharepoint together

  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... Posted Mar 03 2008, 10:40 AM by satya with | with 1 comment(s) Filed under: sql server, microsoft, management, resources, sharepoint

• SQL Server 2005 - Uninstalling cluster and nightmare of tasks you need to observe!

  One of the SSP member gujsa01 has posted his realtime experience about uninstalling cluster on SQL Server 2005, its worth going through this post that will guide you through such issues! Upon installing new 64bit iSCSI SQL Server 2005 EE Cluster, vendor... Posted Feb 03 2008, 02:36 PM by satya with | with no comments Filed under: best practice, sql server, 2005, cluster, tasks, uninstallation, installation

• All about SQL Server with 32bit to 64bit cluster migration - steps to take care

  Recently there has been few 'interesting' posts that will help most of the SQL Server users in this cyber world. Here is the basic question posted by the user: I have been tasked with migrating our SQL Server 05 Active/Passive cluster from 32bit... Posted Jan 14 2008, 10:41 PM by satya with | with 3 comment(s) Filed under: best practice, sql server, forums, reference, upgrade, cluster

• Database Build tool for SQL Server 2005

  In the current world of open source programming there are many tools out there that can provide help to you day-to-day tasks. But as a professional you will not be inclined to use each and every product that is available free/beta on the market. Similarly... Posted Jan 04 2008, 10:37 AM by satya with | with no comments Filed under: sql server, 2005, third party, open source, codeplex, database build, tool

• SQL Server 2008 launch event

  So here it is 2008 has arrived and new year brings new promises in the cyberworld, that I'm referring to next release of SQL Server version which is 2008. As you may be aware the official launch event from Microsoft announced that the release dates... Posted Jan 03 2008, 10:31 AM by satya with | with no comments Filed under: sql server, microsoft, version, visual studio, server, next release, windows 2008