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

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)

Database design - choosing required data type for numeric values

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

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

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

satya — Mon, 03 Mar 2008 12:35:00 GMT

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

Strategy with SQL Server and Sharepoint together

satya — Mon, 03 Mar 2008 08:40:00 GMT

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

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

satya — Sun, 03 Feb 2008 12:36:00 GMT

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