Is SQL Server an application that I should run within a VM? Can I monitor it while it is on a VM?
Yes, SQL Server is a great app to run within a VM, see: <a href=”http://blogs.technet.com/virtualization/”>blogs.technet.com/virtualization/</a> for more information. Also, with the Management Packs from OpsMgr, understanding how your SQL VM is running is a snap. ————- Yes you can run SQL within a VM, provided that the resources required by the SQL Server database can [...]
View Answer
| March 3, 2010 5:28 AM
SQL Server Virtualization, Virtual Machines, VM
Yes, SQL Server is a great app to run within a VM, see: <a href=”http://blogs.technet.com/virtualization/”>blogs.technet.com/virtualization/</a> for more information. Also, with the Management Packs from OpsMgr, understanding how your SQL VM is running is a snap. ————- Yes you can run SQL within a VM, provided that the resources required by the SQL Server database can [...]
View Answer
| March 3, 2010 5:28 AM
SQL Server Virtualization, Virtual Machines, VM
Encrytpion on SQL Server 2008
Use the WITH ENCRYPTION flag. Keep in mind that it takes all of about two seconds to decrypt stored procedures within SQL Server.
View Answer
| March 3, 2010 5:26 AM
SQL Profiler, SQL Server 2008, SQL Server encryption, SQL Server Service Packs
Use the WITH ENCRYPTION flag. Keep in mind that it takes all of about two seconds to decrypt stored procedures within SQL Server.
View Answer
| March 3, 2010 5:26 AM
SQL Profiler, SQL Server 2008, SQL Server encryption, SQL Server Service Packs
How to read data from a stored procedure in RPGLE
See <a href=”http://itknowledgeexchange.techtarget.com/itanswers/sqlrpgle-result-set/”>SQLRPGLE – Result Set</a> and any number of other links. Pay special attention to the statement “The interfaces that can work with stored procedure <b>result sets</b> include JDBC, CLI, and ODBC.” You can call stored procs from SQLRPG. But if you want to process a result set rather than accessing an updated parm [...]
View Answer
| March 2, 2010 7:45 PM
RPGLE, RPGLE Stored Procedures, Stored Procedures
See <a href=”http://itknowledgeexchange.techtarget.com/itanswers/sqlrpgle-result-set/”>SQLRPGLE – Result Set</a> and any number of other links. Pay special attention to the statement “The interfaces that can work with stored procedure <b>result sets</b> include JDBC, CLI, and ODBC.” You can call stored procs from SQLRPG. But if you want to process a result set rather than accessing an updated parm [...]
View Answer
| March 2, 2010 7:45 PM
RPGLE, RPGLE Stored Procedures, Stored Procedures
Loading a new database from an Old one
You are going to most likely have to right what you need in a VB..Net or C# script. I have one that inserts into table A, gets a value from an identity column and uses that to insert into table B. Sounds like that is what you are looking to do. –josef
View Answer
| March 2, 2010 6:24 PM
Database structure, SQL Server 2008, SSIS
You are going to most likely have to right what you need in a VB..Net or C# script. I have one that inserts into table A, gets a value from an identity column and uses that to insert into table B. Sounds like that is what you are looking to do. –josef
View Answer
| March 2, 2010 6:24 PM
Database structure, SQL Server 2008, SSIS
How can Systems Center help with uptime, availability and performance of SQL Server instances and Exchange mailbox servers?
Operations Manager is designed to monitor health and performance of operating systems (both physical and virtual) as well as workloads running on those systems (like SQL and Exchange). Operations management packs exist for the workloads you mention (including SQL 2000, 2005 and 2008, along with Exchange 2003, 2007 and 2010), as well as other workloads, [...]
View Answer
| March 2, 2010 4:19 PM
Exchange Mailboxes, Exchange Server, Microsoft System Center, SQL Server, System Center
Operations Manager is designed to monitor health and performance of operating systems (both physical and virtual) as well as workloads running on those systems (like SQL and Exchange). Operations management packs exist for the workloads you mention (including SQL 2000, 2005 and 2008, along with Exchange 2003, 2007 and 2010), as well as other workloads, [...]
View Answer
| March 2, 2010 4:19 PM
Exchange Mailboxes, Exchange Server, Microsoft System Center, SQL Server, System Center
Documenting column in SQL table in QADBIFLD (AS400)
Note that you shouldn’t care. QADBIFLD isn’t really for your consumption and you possibly should act as if it doesn’t exist. What you want to pay attention to are the VIEWs that are built over QADBIFLD (and over similar DDS PFs in QSYS). In your specific case, the VIEW that you’d be interested in would [...]
View Answer
| March 2, 2010 12:09 AM
AS/400 SQL, Documentation, QADBIFLD, SQL, SQL generated files, SQL tables
Note that you shouldn’t care. QADBIFLD isn’t really for your consumption and you possibly should act as if it doesn’t exist. What you want to pay attention to are the VIEWs that are built over QADBIFLD (and over similar DDS PFs in QSYS). In your specific case, the VIEW that you’d be interested in would [...]
View Answer
| March 2, 2010 12:09 AM
AS/400 SQL, Documentation, QADBIFLD, SQL, SQL generated files, SQL tables
Sql server 2005 – query
<pre>select top 1 salary from Emp where salary not in (select top 1 salary from Emp order by salary desc) order by salary desc</pre> I would recommend you <a href=”http://www.sql-ex.ru”>sql-ex.ru/</a>.
View Answer
| February 25, 2010 5:14 PM
SQL Server 2005, SQL Server Query
<pre>select top 1 salary from Emp where salary not in (select top 1 salary from Emp order by salary desc) order by salary desc</pre> I would recommend you <a href=”http://www.sql-ex.ru”>sql-ex.ru/</a>.
View Answer
| February 25, 2010 5:14 PM
SQL Server 2005, SQL Server Query
When submitting a procedure via CL program, i do not get any abnormal end message.
Are you looking for the error msg? The joblog will have the cause of the failure. On the SBMJOB command, change the log level to produce a joblog upon completion. Prompt SBMJOB, press F10, scroll down twice and you will see Message logging. Change the Level to 4, Severity to 0, and Text to *Seclvl. [...]
View Answer
| February 25, 2010 1:45 PM
CL programming, CL programs, CLP, Stored Procedures
Are you looking for the error msg? The joblog will have the cause of the failure. On the SBMJOB command, change the log level to produce a joblog upon completion. Prompt SBMJOB, press F10, scroll down twice and you will see Message logging. Change the Level to 4, Severity to 0, and Text to *Seclvl. [...]
View Answer
| February 25, 2010 1:45 PM
CL programming, CL programs, CLP, Stored Procedures
Free working space on primary hard disc
Disk and RAM (memory) are different things. When you open a remote file, it is opened using client’s <b>memory </b>(not disk), so in normal situations your free disk space is not affected. You can use the Windows Task Manager (Performance and Processes tabs) to see statistics about resources usage. The OS may use disk space [...]
View Answer
| February 24, 2010 11:32 PM
Hard disks, SQL Server, VS 2005 and .NET 2.0, Windows Server 2003, Windows XP
Disk and RAM (memory) are different things. When you open a remote file, it is opened using client’s <b>memory </b>(not disk), so in normal situations your free disk space is not affected. You can use the Windows Task Manager (Performance and Processes tabs) to see statistics about resources usage. The OS may use disk space [...]
View Answer
| February 24, 2010 11:32 PM
Hard disks, SQL Server, VS 2005 and .NET 2.0, Windows Server 2003, Windows XP
Switching from Bulk-Logged to Simple Recovery Model on SQL Server 2000
NEVER delete the log file. Simply change the database from bulk logged to simple. Then you can shrink the log file down. If you log file is growing simply being doing log backups on it and it won’t grow out of control any more.
View Answer
| February 24, 2010 10:48 PM
SQL Server 2000, SQL Server transaction logs, Transaction logs
NEVER delete the log file. Simply change the database from bulk logged to simple. Then you can shrink the log file down. If you log file is growing simply being doing log backups on it and it won’t grow out of control any more.
View Answer
| February 24, 2010 10:48 PM
SQL Server 2000, SQL Server transaction logs, Transaction logs
Merging MDF files on SQL databases after restoring from a backup
You would need to restore the Thursday backup then move the rows into the database. If you use identity values for your records you’ll need to change the identity values of the rows in the Thursday backup so that they don’t conflict with the new rows which have been inserted.
View Answer
| February 24, 2010 10:42 PM
MDF, SQL Server, SQL Server database
You would need to restore the Thursday backup then move the rows into the database. If you use identity values for your records you’ll need to change the identity values of the rows in the Thursday backup so that they don’t conflict with the new rows which have been inserted.
View Answer
| February 24, 2010 10:42 PM
MDF, SQL Server, SQL Server database
Removing and adding new space to databases.
To do this you’ll need to create a new LUN on the SAN and present it to SQL_SVR_A. Then stop the SQL Server, move the database files to the new smaller drive, keeping all the folder paths the same. Switch the drive letters on the two volumes. Then start the SQL Server Service again. All [...]
View Answer
| February 24, 2010 10:39 PM
SAN, SQL Server, SQL Server database
To do this you’ll need to create a new LUN on the SAN and present it to SQL_SVR_A. Then stop the SQL Server, move the database files to the new smaller drive, keeping all the folder paths the same. Switch the drive letters on the two volumes. Then start the SQL Server Service again. All [...]
View Answer
| February 24, 2010 10:39 PM
SAN, SQL Server, SQL Server database
Looping through a Database
If you are using SQL 2005 or newer you can next sp_MSforeachtable within sp_MSforeachdb. If you are using SQL 2000 or older you’ll need to use a cursor outside the sp_MSforeachtable. Something like this should do the trick. <pre>declare @db sysname, @sql varchar(4000) declare cur CURSOR FOR SELECT name from sysdatabases where name <> ‘tempdb’ [...]
View Answer
| February 24, 2010 10:34 PM
Looping, Servers, SQL Server
If you are using SQL 2005 or newer you can next sp_MSforeachtable within sp_MSforeachdb. If you are using SQL 2000 or older you’ll need to use a cursor outside the sp_MSforeachtable. Something like this should do the trick. <pre>declare @db sysname, @sql varchar(4000) declare cur CURSOR FOR SELECT name from sysdatabases where name <> ‘tempdb’ [...]
View Answer
| February 24, 2010 10:34 PM
Looping, Servers, SQL Server
Storing encrypted files on an SQL Server 2000
Doing this isn’t nativly suppoted in 2000. <a href=”http://windowsitpro.com/article/articleid/14035/how-do-i-encrypt-fields-in-sql-server.html”>Here</a> is an article about it. I have done it by using System.Security.Cryptography in .net and either binary, varbinary, or image data type in the database. You can also convert the bytes to a base64 encoded string in .net and save it in the database in a [...]
View Answer
| February 24, 2010 10:30 PM
Encryption, SQL Server, SQL Server 2000
Doing this isn’t nativly suppoted in 2000. <a href=”http://windowsitpro.com/article/articleid/14035/how-do-i-encrypt-fields-in-sql-server.html”>Here</a> is an article about it. I have done it by using System.Security.Cryptography in .net and either binary, varbinary, or image data type in the database. You can also convert the bytes to a base64 encoded string in .net and save it in the database in a [...]
View Answer
| February 24, 2010 10:30 PM
Encryption, SQL Server, SQL Server 2000
Upgrading a 2000 database beyond Service Pack 2
If your vendor says that it can’t be upgraded beyond SP2 I’d ask them why. SP3 is pretty much the standard SP to support as SP3 includes the code which prevents the SQL Slammer worm. I’d also ask them why they are forcing you to use tech that is two generations old and 7+ years [...]
View Answer
| February 24, 2010 10:28 PM
service pack 2, SQL Server, SQL Server Service Packs
If your vendor says that it can’t be upgraded beyond SP2 I’d ask them why. SP3 is pretty much the standard SP to support as SP3 includes the code which prevents the SQL Slammer worm. I’d also ask them why they are forcing you to use tech that is two generations old and 7+ years [...]
View Answer
| February 24, 2010 10:28 PM
service pack 2, SQL Server, SQL Server Service Packs
CPU and RAM recommendations for our data warehouse
A 64bit upgrade will definitely help. Pretty much as much RAM as you can afford is a good thing. RAM up to about 64 Gigs is pretty inexpensive. After that the price starts to go up a lot. How many cores does each CPU have? You’ll want at least 4 cores per CPU.
View Answer
| February 24, 2010 10:25 PM
RAM, SAN, SSIS Package
A 64bit upgrade will definitely help. Pretty much as much RAM as you can afford is a good thing. RAM up to about 64 Gigs is pretty inexpensive. After that the price starts to go up a lot. How many cores does each CPU have? You’ll want at least 4 cores per CPU.
View Answer
| February 24, 2010 10:25 PM
RAM, SAN, SSIS Package
MSDE for adminDB
If Diskeeper is trying to install MSDE then you’ll need to have them correct the installer so that it doesn’t cause the problem.
View Answer
| February 23, 2010 10:41 PM
BLANKSAPWD, Diskeeper, Diskeeper Administrator 2009, MSDE, MSDE for AdminDB, SA password
If Diskeeper is trying to install MSDE then you’ll need to have them correct the installer so that it doesn’t cause the problem.
View Answer
| February 23, 2010 10:41 PM
BLANKSAPWD, Diskeeper, Diskeeper Administrator 2009, MSDE, MSDE for AdminDB, SA password
Monitoring log files in a SQL Server 2000 database
Instead of truncating the log you need to either backup the log, or change the database to simple recovery. If you backup the log then you can restore the database to a specific point in time and the log will be cleared automatically. If you don’t need the ability to restore to a specific point [...]
View Answer
| February 23, 2010 10:38 PM
SQL Server 2000, SQL Server 2000 Database, SQL Server database, SQL Server logs
Instead of truncating the log you need to either backup the log, or change the database to simple recovery. If you backup the log then you can restore the database to a specific point in time and the log will be cleared automatically. If you don’t need the ability to restore to a specific point [...]
View Answer
| February 23, 2010 10:38 PM
SQL Server 2000, SQL Server 2000 Database, SQL Server database, SQL Server logs
Database management plan wizard
SQL Express doesn’t support maintenance plans so the Tools don’t include those options. To use Maintenance plans you’ll need to get the Workgroup or above edition of SQL Server 2008.
View Answer
| February 23, 2010 1:10 AM
Database management plan wizard, SQL Server 2008, SQL Server 2008 administration
SQL Express doesn’t support maintenance plans so the Tools don’t include those options. To use Maintenance plans you’ll need to get the Workgroup or above edition of SQL Server 2008.
View Answer
| February 23, 2010 1:10 AM
Database management plan wizard, SQL Server 2008, SQL Server 2008 administration
Accessing MS SQL Server database from the iSeries
I think we need some more detail. Do you have TCPIP set up on the AS/400? Can you ping the IP Address of the AS/400 from another server or PC? From which box are you getting the error message? When you go into the TCP/IP Settings do you see that IP you have configured as [...]
View Answer
| February 20, 2010 9:00 AM
AS/400, SQL Database, SQL Server
I think we need some more detail. Do you have TCPIP set up on the AS/400? Can you ping the IP Address of the AS/400 from another server or PC? From which box are you getting the error message? When you go into the TCP/IP Settings do you see that IP you have configured as [...]
View Answer
| February 20, 2010 9:00 AM
AS/400, SQL Database, SQL Server
