SQL Server 2005 Performance
SQL Server doesn’t track the number of changes to the database is a counter you can grab. The best way to figure this out is to work with the application developer and see how many database calls there are, and how many of those are read and how many of those are writes. Then work [...]

View Answer   |  August 10, 2010  7:22 PM
SQL 2005 Database, SQL Server, SQL Server 2005, SQL Server 2005 performance, SQL Server performance

How to migrate a database from SQL Server 2000 to SQL Server 2005
If you mean moving the DB to another server with SQL2005 it’s one thing; if instead you need to upgrade the existing SQL2000 it’s a “next, next, continue” process. please be more specific. This is Md.Aves You need to take backup of ur database from SQL 2000 for that you have to write this query [...]

View Answer   |  August 10, 2010  7:26 AM
SQL Server 2000, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration

Connecting to SQL Server 2005 after installing PowerBuilder
<pre></pre>

View Answer   |  August 10, 2010  5:53 AM
PowerBuilder, SQL Native Client, SQL Server 2005, SQL Server errors

Upgrade SQL 2005 Cluster to SQL 2008
Yes you can do an in place upgrade of the SQL Server on the cluster. Take a look at the February 2010 issue of <a href=”http://www.sqlmag.com/article/clustering/upgrading-a-sql-server-2005-cluster-to-a-sql-server-2008.aspx”>SQL Server magazine</a>, in it I’ve got an article which covers how to go the upgrade step by step.

View Answer   |  August 9, 2010  1:51 PM
Active/Passive SQL Server 2005 Cluster, SQL Server 2005, SQL Server 2008, SQL Server clustering

AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database.
Access to SQL Server from a different platform is done the same way almost all databases are accessed cross-platform. Download the driver from the vendor for the platform you’re running on. The only driver that I’m aware of that Microsoft currently makes available that will run on your AS/400 is the <a href=”http://www.microsoft.com/downloads/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707&displaylang=en”>Microsoft SQL Server [...]

View Answer   |  August 7, 2010  4:03 AM
API, AS/400, COBOL, iSeries, SQL Server, V5R4

Database Log File sql server 2005
Well your problem is that you have all the data stored on the same physical disks so you are causing all sorts of contention on the disks. If you are using 8 drives in a RAID 10, then you actually only get to use 4 as the other 4 are a mirror of the first [...]

View Answer   |  August 5, 2010  7:12 PM
RAID, SQL Server 2005, SQL Server 2005 performance, SQL Server logs, SQL Server performance

New Contest: You Could Win a New Xbox 360
Thanks to everyone who participated in the Xbox 360/Amazon contest. And a big congratulations to our winners: <a href=”http://itknowledgeexchange.techtarget.com/profile/Mattmather/”>Mattmather</a> and <a href=”http://itknowledgeexchange.techtarget.com/profile/RichS/”>RichS</a> take home the Xbox 360s and <a href=”http://itknowledgeexchange.techtarget.com/profile/Carlosdl/”>Carlosdl</a>, <a href=”http://itknowledgeexchange.techtarget.com/profile/Technochic/”>Technochic</a>, and <a href=”http://itknowledgeexchange.techtarget.com/profile/Mrdenny/”>Mrdenny</a> take home the Amazon gift cards. Everyone else, keep earning points by <a href=”http://itknowledgeexchange.techtarget.com/itanswers/ask_question/”>asking</a> and <a href=”http://itknowledgeexchange.techtarget.com/itanswers/?tab=unanswered#questions”>answering</a> questions and taking [...]

View Answer   |  August 5, 2010  12:47 PM
DataCenter, DataManagement, Development, Exchange, ITKE Community, ITKE Contests, ITKE Feedback, ITKnowledgeExchange, Linux, Lotus Domino, Microsoft Windows, Mobile, SQL Server, VoIP

Oracle DECODE and SSMA
I don’t think such a function exists. The <a href=”http://download.microsoft.com/download/e/c/8/ec8d5025-7ef7-4dcc-a9f3-9c297cf5350e/SSMAOracle.docx”>Guide to Migrating from Oracle to SQL Server 2005</a> specifies that the Oracle’s DECODE function is converted using standard T-SQL mapping (using a CASE-WHEN construct). That is also the case when migrating to SQL Server 2008.

View Answer   |  August 4, 2010  7:10 PM
DECODE, Oracle 9i, Oracle migration, SQL Server 2005, SSMA for Oracle

Scheduled job for Oracle 9 returning ORA-01858
Is the Scheduler passing parameters into the stored procedures? Are any values defined differently depending on the execution steps? If so, I would start with checking those values. Since the two do not error in stand alone mode, I would think the errors are not initiated from a database query. But, do not eliminate any [...]

View Answer   |  August 4, 2010  5:20 AM
ORA-01858, Oracle 9, Oracle Scheduler, Stored Procedures

Creating Alert/Email when Automatic Failover Occurs In Sql-Server 2005 and 2000
Create a SQL Agent job that is configured to run at startup. Every time the agent starts it will send out an email. Every time failover happens the SQL Agent will be restarted.

View Answer   |  August 3, 2010  3:23 AM
Automatic failover, SQL Server, SQL Server 2000, SQL Server 2005

Transactional Replication: Publisher & Subscriber size mismatch
This is normal and isn’t something to worry about. The tables on the subscriber are written in a different order than the tables were on the publisher, and the tables on the publisher probably have a lot more white space hidden through out the database file than the subscriber does.

View Answer   |  August 2, 2010  5:50 PM
Hard drive space, SQL 2005, SQL Database, SQL Server, SQL Server 2005, SQL Server 2005 Database

AS/400 SQL Procedure call from CL program
have you tried it as *DEC (n n) where n n is the length and number of decimal places? ========================================================= A QM query can’t return a value to CL. CL can’t call stored procs. Some different process needs to be developed. Actually, it seems to be a very long way around what should be simple. [...]

View Answer   |  July 31, 2010  9:16 AM
CL, SQL stored procedures, STRQMQRY

ORA-06502: Character string buffer too small
A function with return type VARCHAR2 will produce this error when used in a query if it returns more than 4000 bytes, because that is the max size of a database’s varchar2 type (as opposed to the pl/sql varchar2 type which can hold up to 32737 bytes). You might probably avoid that error by changing [...]

View Answer   |  April 19, 2013  6:32 PM
Oracle, SQL Scripting, SQL Server, String manipulation

SQL query How to select nth row from a table if they are not in any order
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]

View Answer   |  May 15, 2013  9:36 AM
SQL, SQL Data Set, SQL Query, SQL tables

How to display values in one table by referring and checking values in another table?
<pre>SELECT a.column_x, a.column_y FROM table1 a JOIN table2 b ON a.column_z = b.column_z WHERE b.column_w = <something> AND …</pre> If you need a more specific answer, please provide more details.

View Answer   |  July 28, 2010  4:01 PM
SQL Database, SQL Server, SQL Server database, SQL Server tables, SQL tables

Master Data Services – Confused by mdm.tblStgMember
The mdm.tblStgMember table is basically the schema that the data will be stored in. Where mdm.tblStgMemberAttribute is the values. The whole MDM thing is very complex. I’m glad you liked the articles.

View Answer   |  July 27, 2010  9:44 PM
Master data management, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2008 R2 Training

Duplicate SQL Server 2005 database
There are multiple ways. You can use a 3rd party product like XoSoft or DoubleTake. Another option could be to nightly dump your database within SQL to a centralized location where the spare server can nightly copy to a local volume for “future” use. +++++++++++++++++++++++++++++++++++ Another option via <a href=”http://sqldump.sourceforge.net/ “>Open Source</a> ++++++++++++ You can [...]

View Answer   |  July 26, 2010  11:25 PM
Backup, Backup and restore, SQL Server 2005, SQL Server 2005 backup, SQL Server 2005 Database

Does Forefront Endpoint Protection support SQL Server 2008?
Yes it will. Forefront Endpoint Protection is built on System Center Configuration Manager (it will require Config Manager 2007 R2 and above). So it provides a unified management infrastructure for systems management and client security. So all the platforms supported by Configuration Manager 2007 R2 can be used for FEP 2010.

View Answer   |  July 26, 2010  8:11 PM
Endpoint security, forefront endpoint protection, forefront endpoint protection support, Microsoft Forefront Endpoint Protection, SQL Server 2008

SQL SERVER 2005 Security use Kerberos instead of NTLM
You’ll need to setup an SPN for the service using the SETSPN command on a domain controller.

View Answer   |  July 24, 2010  7:43 PM
Kerberos, SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server authentication

sql 2008 export to txt for backup and incremental backup
You’ll want to use the BACKUP DATABASE command to backup the database to a .BAK file. You can them backup this file up to tape as needed. You can use the SQL Agent to create a job to backup the database every day. If you need point in time recovery you’ll need to also schedule [...]

View Answer   |  July 23, 2010  7:39 PM
Backup, SQL 2008, SQL database replication, SQL Server, SQL Server 2008, SQL Server database