hardware requirement for sql 2005.
Get a couple of dual core or quad core CPUs and as much RAM as you can afford. I would get no less than 4-8 Gigs.
Get a couple of dual core or quad core CPUs and as much RAM as you can afford. I would get no less than 4-8 Gigs.
46765 pts.
How do I confirm all the data moved from Source to target for different tables
With SQL. use the Select COUNT(*) option for each of the tables in both the source and target system. That will tell you if your record count is correct. * If you want to get to the record level, you can do a EXCEPTION JOIN
With SQL. use the Select COUNT(*) option for each of the tables in both the source and target system. That will tell you if your record count is correct. * If you want to get to the record level, you can do a EXCEPTION JOIN
Rename Sheet when report exported to excel
Hi Rachitha It is not possible to do this with SSRS out of the box. http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/4876ffe0-f0c0-413e-9890-0c85615b3edf/ But there is an work around by creating XSLT and attaching it to SSRS. Refer below link. ...
Hi Rachitha It is not possible to do this with SSRS out of the box. http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/4876ffe0-f0c0-413e-9890-0c85615b3edf/ But there is an work around by creating XSLT and attaching it to SSRS. Refer below link. ...
sql help
The way you cited, update table/detail set condition = 'r' where condition = ' ' and number_d = (select number_h from table/header where date between 050101 and 051231) is one way to do it. Here's a more efficient way, especially if number_h is indexed: UPDATE...
The way you cited, update table/detail set condition = 'r' where condition = ' ' and number_d = (select number_h from table/header where date between 050101 and 051231) is one way to do it. Here's a more efficient way, especially if number_h is indexed: UPDATE...
What is correct syntax for SQL for Maxrecords in OS400/DB2?
I don't believe that MAXRECORDS is part of the "SQL Standard". I know a few databases (big ones included) have implemented it, but it's not a part of DB2. I believe it can be set as a property on OLE and ADO DB providers. sorry :-( =================================================== Your...
I don't believe that MAXRECORDS is part of the "SQL Standard". I know a few databases (big ones included) have implemented it, but it's not a part of DB2. I believe it can be set as a property on OLE and ADO DB providers. sorry :-( =================================================== Your...
Msg 102, level 15, State 1, Line 14
Remove all the 'GO's that are inside the stored procedure body, and it should work.
Remove all the 'GO's that are inside the stored procedure body, and it should work.
Will defragmenting hard disks improve SQL Server performance?
Yes it can, however the benefit will probably be minimal. It will be a great amount of help for a data warehouse, but for OLTP applications the data will be so fragmented throughout the file, that defragmenting the file on the drive will only provide a minimal amount of assistance. More is gained...
Yes it can, however the benefit will probably be minimal. It will be a great amount of help for a data warehouse, but for OLTP applications the data will be so fragmented throughout the file, that defragmenting the file on the drive will only provide a minimal amount of assistance. More is gained...
How to encrypt a big list of sp's at once
No there isn't. You have to do an ALTER PROCEDURE specifying the WITH ENCRYPTION option. Do keep in mind that this encryption is very easy to undo. There are plenty of freeware software packages out there to decrypt the procedures. It also makes things look very unfriendly to the DBA when you...
No there isn't. You have to do an ALTER PROCEDURE specifying the WITH ENCRYPTION option. Do keep in mind that this encryption is very easy to undo. There are plenty of freeware software packages out there to decrypt the procedures. It also makes things look very unfriendly to the DBA when you...
MS SQL Server to Oracle Applications
Sounds like a perfect job for a SQL Server Integration Services package.
Sounds like a perfect job for a SQL Server Integration Services package.
Community Announcement: Cash in your Knowledge Points for an Amazon gift card
Ok for redeem my points now
Ok for redeem my points now
"map drive" IFS
So if I understand correctly... - You have created "shares" using iSeries Navigator? (i.e. a share named "root" for the / directory, a share named "test" for /home/jdoe/test, and so on) - And using "net use X: \QS6555A8Aroot" or "net use Z: \QS6555A8Atest" in a DOS box on a client PC doesn't work? ...
So if I understand correctly... - You have created "shares" using iSeries Navigator? (i.e. a share named "root" for the / directory, a share named "test" for /home/jdoe/test, and so on) - And using "net use X: \QS6555A8Aroot" or "net use Z: \QS6555A8Atest" in a DOS box on a client PC doesn't work? ...
SA Password change for SQL
Password changes are done via the sp_password system stored procedure. exec sp_password 'sa', 'YourNewPassword'
Password changes are done via the sp_password system stored procedure. exec sp_password 'sa', 'YourNewPassword'
Passing data between two SQL Server databases
I've had to do stuff like this in the past. In my case it was a loan processing system, so the master number to work off of was the Account Id. So I created a table, and loaded up 10% of the Account Ids into the table. Then used the records in the table to decide which records to transfer from...
I've had to do stuff like this in the past. In my case it was a loan processing system, so the master number to work off of was the Account Id. So I created a table, and loaded up 10% of the Account Ids into the table. Then used the records in the table to decide which records to transfer from...
SQL Server 2005 on Windows 2008 64 bit SP2. Installation issue
Hello I am having the same issue! Has anyone come up with an answer yet? I'm quite frustrated by this and am also only finding discussions of the Web edition on-line. What's the deal?
View Answer
| Nov 13 2009 0:14 AM GMT
SQL Server 2005 (64-bit), SQL Server 2005, SQL Server installation
Hello I am having the same issue! Has anyone come up with an answer yet? I'm quite frustrated by this and am also only finding discussions of the Web edition on-line. What's the deal?
View Answer
| Nov 13 2009 0:14 AM GMTSQL Server 2005 (64-bit), SQL Server 2005, SQL Server installation
pl/slq procedures - POSITIVE and POSITIVEN as IN OUT parameters
The POSITIVEN type is allowed for IN paramaters only, as the initial value of an OUT parameter is NULL by definition. You should use POSITIVE for the out paramter instead.
The POSITIVEN type is allowed for IN paramaters only, as the initial value of an OUT parameter is NULL by definition. You should use POSITIVE for the out paramter instead.
Can we get sql server authenticated logins and passwords?
sp_help_revlogin can be used to export the logins and the encrypted passwords. Go can google for it and get the code from Microsoft's site.
sp_help_revlogin can be used to export the logins and the encrypted passwords. Go can google for it and get the code from Microsoft's site.
VB.NET code to search if a record already exists or not
If you are getting errors with the code you posted, please provide the exact error messages or tell us what the problem with that code is. If this code is working but you want to add the necessary logic to check if the record already exists before inserting it, you could put the insert into a...
If you are getting errors with the code you posted, please provide the exact error messages or tell us what the problem with that code is. If this code is working but you want to add the necessary logic to check if the record already exists before inserting it, you could put the insert into a...
SQl Server Replication Internals
The basic process is that the row is inserted into the table. When this happens the transaction is logged into the transaction log. The log reader reads the log and gets the information from the transaction log and writes it to the distribution database. From there the distribution agent (or...
The basic process is that the row is inserted into the table. When this happens the transaction is logged into the transaction log. The log reader reads the log and gets the information from the transaction log and writes it to the distribution database. From there the distribution agent (or...
