Ken Stoker
kens.programming at verizon.net
Tue Sep 21 19:40:18 CDT 2004
Use CASE statements. If you lookup CASE in BOL, it will tell you how to work with them. Ken -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Tuesday, September 21, 2004 5:34 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Iif in SQL Server I have a situation where I need to have an iif construct that returns the contents of one field if it exists, else return the other field. How do you do something like that in SQL Server? Do I use a stored procedure? I need this to run on potentially large datasets in something approaching real time. John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Sunday, September 19, 2004 3:39 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] LiteSpeed cost I did not time the backup but the file size for the backup is 31 gb for a backup of 260 gb which is a pretty hefty savings. John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Sunday, September 19, 2004 2:11 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] LiteSpeed cost I did download the evaluation ad am testing it now. No restrictions are mentioned anywhere either on their site nor in the software as it runs. I am interested for the simple reason that the nVLDB I am dealing with is already way to big to backup in the normal manner and takes way to long as well. The web site says that huge space savings are available because they use compression and that the software also performs backups much faster, 2 to 3 times faster (or more). My database is already 260 gbytes and will grow as I add indexes to the table. I definitely need this kind of speed / size help if I am going to get the database backup happening automatically. I am currently manually zipping the files but that is not a good long term solution. John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence (AccessD) Sent: Sunday, September 19, 2004 1:53 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] test Hi John: Here is their web site: http://www.imceda.com/litespeed.asp?page=1. There is no price on their web site but I believe the cost is about $600.00. (Very pricey IMHO) You can download an evaluation copy but I am not sure whether it has been crippled or not. HTH Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of John W. Colby Sent: Sunday, September 19, 2004 10:14 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] test Does anyone know the cost of LiteSpeed backup widget? John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Sunday, September 19, 2004 1:58 AM To: 'Access Developers discussion and problem solving'; dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] test Nothing today from any of our lists. Just a quiet day? John W. Colby www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com