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

Re-configuring RAID on the server - a detailed approach and best practices

satya — Thu, 19 Feb 2009 10:58:00 GMT

Reconfiguring the hardware or software on the server is a big job and you wouldn't attempt to perform the task on day-to-day basis or even not in your life time. Here is the detailed steps that are involved in this mammoth task refer to this post...(read more)

Is there anyway to find out when a table was dropped, and by what user?

satya — Wed, 07 Jan 2009 08:25:00 GMT

Here is another Frequently Asked Question in the forum to find out the damage that has happened in your SQL Server environment. To find out more on what has been referred review this Forum_Post link....(read more)

Best Practices on Disk Defragmentation methods on a SQL Server - specific to data file and indexes drives?

satya — Tue, 23 Dec 2008 10:16:00 GMT

Fragmentation is dearest friend of database when you need to deal with Performance, so by using the DBCC statements and other methods here you can deal the database level fragmentation, what about the physical level fragmentation? So what is the best...(read more)

SQL Server stored procedure vulnerability heap buffer overrun in SQL Server, MSDE, and SQL Express

satya — Tue, 23 Dec 2008 10:14:00 GMT

You may have seen the sp_replwriterovarbin - New SQL Server Injection-Based Attack Found vulerability about the new public reports of a vulnerability that could allow remote code execution on systems with supported editions of SQL Server 2000, 2005, 2005...(read more)

How to deal: "The EXECUTE permission was denied on the object 'sp_executesql', database 'mssqlsystemresource', schema 'sys'." issue

satya — Mon, 11 Aug 2008 09:13:00 GMT

One of the TRUSTWORTHY features within SQL Server 2005 will be like when you are running a stored procedure with a dynamic execution query ( sp_executesql or EXECUTE), you may receive the following error message: Server Msg 229, Level 14, State 5, Line...(read more)

SQL Server 2008 RTM is released, its official now!

satya — Thu, 07 Aug 2008 06:11:00 GMT

Microsoft press announces that SQL Server 2008 is available for users and as per PressRelease : . ..announced the release to manufacturing of Microsoft SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence...(read more)

SQL Server - How to return string values?

satya — Tue, 29 Jul 2008 18:13:00 GMT

I found this interesting question within SSP forums: Is it possible to return only the upper case of a given string. For a string say, 'My name Is John Cramps' I should get the output as 'MIJC' I am using SQL Server 2005. Visit forum http...(read more)

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

satya — Sat, 31 May 2008 21:23:00 GMT

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...(read more)

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

satya — Sat, 31 May 2008 10:46:00 GMT

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...(read more)

Refactoring Stored procedures on a SQL Server database?

satya — Mon, 26 May 2008 08:00:00 GMT

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....(read more)

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

satya — Sun, 25 May 2008 01:56:00 GMT

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 ....(read more)

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

satya — Mon, 19 May 2008 07:42:00 GMT

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...(read more)

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

satya — Thu, 15 May 2008 08:57:00 GMT

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...(read more)

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

satya — Mon, 17 Mar 2008 10:28:00 GMT

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...(read more)

SQL Server multiple instances and resource utilization - best practices

satya — Fri, 14 Mar 2008 11:28:00 GMT

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...(read more)