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

2008-08-11T09:13:00Z

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 1 'permission' permission denied on object 'object', database 'database', owner 'owner'. As a Developer or DBA you wouldn't get confusion when trying to execute the above piece of code 'sp_executesql' as...(read more)

SQL Server 2008 RTM is released, its official now!

2008-08-07T06:11:00Z

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 platform. This version of SQL Server provides powerful new capabilities such as support for policy-based management, auditing, large-scale data warehousing, geospatial data, and advanced reporting and analysis services. SQL Server 2008 provides the...(read more)

SQL Server - How to return string values?

2008-07-29T18:13:00Z

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://sql-server-performance.com/Community/forums/t/27634.aspx post for more information & excellent code references....(read more)

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

2008-05-31T21:23:00Z

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 security-related configuration settings since the good & bad times of SQL Server version 2000, not in particular to point DBA or Developer and whole as in Application database, remember ' Slammer Worm '!. Here it is best to refer the...(read more)

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

2008-05-31T10:46:00Z

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, which are not an option for me. What is needed for SQL Server to use 3GB of the memory for 2003 SE? Solution: Refer to the forum post - http://sql-server-performance.com/Community/forums/t/14372.aspx in this regard....(read more)

Refactoring Stored procedures on a SQL Server database?

2008-05-26T08:00:00Z

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)

2008-05-25T01:56:00Z

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...

2008-05-19T07:42:00Z

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 the login with Domain Admin and local admin rights, still the error persists. For resolution refer to the RelevantForum post itself....(read more)

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

2008-05-15T08:57:00Z

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 DB server so far does seem to be a little bit overloaded and I am working on reducing the workload. One of the counter (Full Scan/Sec for SQL Server Access Methods) is running way above that it should be. I am recording averages of 150-200 Full Scans...(read more)

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

2008-03-17T10:28:00Z

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

2008-03-14T11:28:00Z

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 resources then best to leave the default settings, for instance dynamic memory settings on SQL Server. As per the configuration of SQL Server you can easily mix versions of SQL Server (both 2000 and 2005) on the same machine running Windows server, such...(read more)

Database design - choosing required data type for numeric values

2008-03-10T09:28:00Z

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

2008-03-03T12:35:00Z

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

2008-03-03T08:40:00Z

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 offers best practices to help you understand the role and importance of SharePoint in your organization and offers these four steps to lay the groundwork for effective, long-term SharePoint management: Understand how SharePoint is used today and...(read more)

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

2008-02-03T12:36:00Z

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 suggested ( wasn't documented in their readme file) I should change the NTFS block size on the partition to 64K. The following article helped with understanding the defaults: http://technet.microsoft.com/en-us/library/bb457112.aspx Steps involved...(read more)