Crystal Reports 8.5 iMIS 10.6 database
I am using Crystal 8.5 with iMIS 10.6. In the database we collect Annual Fund gift information. Each Annual Fund year is a discrete value (AF_2011, AF_2010, AF_2009 etc. I am having difficulty writing a formula that will give me new (AF_2011 only) gifts. I want to show those who only gave to AF_2011 after [...]
Answer Question
| January 24, 2011 3:11 PM
Crystal Reports 8, Crystal Reports 8.5, iMIS, SQL Server
I am using Crystal 8.5 with iMIS 10.6. In the database we collect Annual Fund gift information. Each Annual Fund year is a discrete value (AF_2011, AF_2010, AF_2009 etc. I am having difficulty writing a formula that will give me new (AF_2011 only) gifts. I want to show those who only gave to AF_2011 after [...]
Answer Question
| January 24, 2011 3:11 PM
Crystal Reports 8, Crystal Reports 8.5, iMIS, SQL Server
Application Upgrade and Data migration
Hello Sir/Mam We have a web application that has an intensive usage of Database operations. This application of course has some sort of sophisticated Database (tables, indexes, …) structure according to Database engine used. My question now is , what is the best practice to migrate old database structure to new one “including data of [...]
Answer Question
| January 24, 2011 11:29 AM
Database, Development, Oracle, SQL Server, Web application development
Hello Sir/Mam We have a web application that has an intensive usage of Database operations. This application of course has some sort of sophisticated Database (tables, indexes, …) structure according to Database engine used. My question now is , what is the best practice to migrate old database structure to new one “including data of [...]
Answer Question
| January 24, 2011 11:29 AM
Database, Development, Oracle, SQL Server, Web application development
DBCCShrinkDatabase as Security Cleanup Measure?
Recently a private document wasposted to a publicly accessible SharePoint site. The file was deleted and removed from the search index by running an intermediate crawl of the content database. Now the client wants to shrink the database, which is just under a 1Tb in size and sits on a SAN, claiming that this will [...]
Answer Question
| January 24, 2011 9:38 PM
Database file security, SQL Server 2005, SQL Server security, SQL Server Shrink Database
Recently a private document wasposted to a publicly accessible SharePoint site. The file was deleted and removed from the search index by running an intermediate crawl of the content database. Now the client wants to shrink the database, which is just under a 1Tb in size and sits on a SAN, claiming that this will [...]
Answer Question
| January 24, 2011 9:38 PM
Database file security, SQL Server 2005, SQL Server security, SQL Server Shrink Database
SQL command question
I have three tables as below: Table 1: attributes fields: attID, att_CategoryID, name Table 2: att_Category fields: att_CategoryID, name Table 3: prodcutAttributes fields: ID, productID, attID, I desigining this tables to be able to add multiple prodcut attributes for ecommerce site. I don’t know how good this design is. Anyways I need to find out [...]
Answer Question
| January 27, 2011 4:20 PM
SQL commands, SQL Server, SQL Server tables, SQL tables
I have three tables as below: Table 1: attributes fields: attID, att_CategoryID, name Table 2: att_Category fields: att_CategoryID, name Table 3: prodcutAttributes fields: ID, productID, attID, I desigining this tables to be able to add multiple prodcut attributes for ecommerce site. I don’t know how good this design is. Anyways I need to find out [...]
Answer Question
| January 27, 2011 4:20 PM
SQL commands, SQL Server, SQL Server tables, SQL tables
SQL and Dates
Can someone date a look at this SQL and recommend a cleaner way to go about this? [BMDTOR is a date field in the file stored as CCYYMMDD] SELECT (DAYS(CURRENT DATE)-DAYS(SUBSTR(BMDTOR,5,2)||’/'||SUBSTR(BMDTOR,7,2)||’/'||SUBSTR(BMDTOR,3,2)))/30 AGE, SUBSTR(BMDTOR,5,2)||’/'||SUBSTR(BMDTOR,7,2)||’/'||SUBSTR(BMDTOR,3,2), (CURRENT DATE) FROM XXXXDATA/FILEXX
Answer Question
| January 25, 2011 5:31 PM
SQL, SQL Query, SQL Server
Can someone date a look at this SQL and recommend a cleaner way to go about this? [BMDTOR is a date field in the file stored as CCYYMMDD] SELECT (DAYS(CURRENT DATE)-DAYS(SUBSTR(BMDTOR,5,2)||’/'||SUBSTR(BMDTOR,7,2)||’/'||SUBSTR(BMDTOR,3,2)))/30 AGE, SUBSTR(BMDTOR,5,2)||’/'||SUBSTR(BMDTOR,7,2)||’/'||SUBSTR(BMDTOR,3,2), (CURRENT DATE) FROM XXXXDATA/FILEXX
Answer Question
| January 25, 2011 5:31 PM
SQL, SQL Query, SQL Server
Server Timeout on initial web connection to SQLServer
We run a couple of websites (hosted on different webservers) that connect to an SQL Server. The data was recently moved to another SQL Server (called SQLCLUSTER) and now the first time the site is accessed, it takes over 20 seconds to bring up the page. If I don’t set the Connection Timeout in the [...]
Answer Question
| January 20, 2011 3:21 AM
SQL Express 2008, SQL Server, SQL Server Enterprise Edition, Web Server, Web server administration
We run a couple of websites (hosted on different webservers) that connect to an SQL Server. The data was recently moved to another SQL Server (called SQLCLUSTER) and now the first time the site is accessed, it takes over 20 seconds to bring up the page. If I don’t set the Connection Timeout in the [...]
Answer Question
| January 20, 2011 3:21 AM
SQL Express 2008, SQL Server, SQL Server Enterprise Edition, Web Server, Web server administration
how to use databases made in access or excel in sql
how to use databases made in access or excel in sql importing readymade databases in sql
Answer Question
| January 21, 2011 1:34 PM
Access, C#, excel, Import external data, SQL Server, SQL Server database
how to use databases made in access or excel in sql importing readymade databases in sql
Answer Question
| January 21, 2011 1:34 PM
Access, C#, excel, Import external data, SQL Server, SQL Server database
SQL Server 2000 Log Shipping
Hi I have an issue with my logship server (SQL 2000). I logship every 10 mins from production to backup server, all has been working fine, until today when a network issue caused a logfile which i use to restore was corrupted. I need to make the Logship DB Live to retrieve some data I run “RESTORE [...]
Answer Question
| January 19, 2011 10:41 AM
Log Shipping, Log Shipping failure, SQL 2000, SQL Server 2000, SQL Server 2000 Log Shipping
Hi I have an issue with my logship server (SQL 2000). I logship every 10 mins from production to backup server, all has been working fine, until today when a network issue caused a logfile which i use to restore was corrupted. I need to make the Logship DB Live to retrieve some data I run “RESTORE [...]
Answer Question
| January 19, 2011 10:41 AM
Log Shipping, Log Shipping failure, SQL 2000, SQL Server 2000, SQL Server 2000 Log Shipping
Storage Area Network Configuration IOPS
I have a SAN with a RAID 10 (16 Drives) and a stripe size of 512. I want to align the disks for better SQL Server performance, the problem is that the OS is already installed on a non-aligned drive and SQL Server is running in production using non-aligned drives. My current 8 drives starting [...]
Answer Question
| January 17, 2011 11:10 PM
IOPS, SQL 2005, SQL Server 2005, SQL Server 2005 performance, Storage Area Networks
I have a SAN with a RAID 10 (16 Drives) and a stripe size of 512. I want to align the disks for better SQL Server performance, the problem is that the OS is already installed on a non-aligned drive and SQL Server is running in production using non-aligned drives. My current 8 drives starting [...]
Answer Question
| January 17, 2011 11:10 PM
IOPS, SQL 2005, SQL Server 2005, SQL Server 2005 performance, Storage Area Networks
Stored Procedures in SQL Server 2005
Will you please explain me about Stored Procedures in Sql server 2005
Answer Question
| January 13, 2011 4:53 AM
SQL Server, SQL Server 2005, SQL Server stored procedures, SQL stored procedures, Stored Procedures
Will you please explain me about Stored Procedures in Sql server 2005
Answer Question
| January 13, 2011 4:53 AM
SQL Server, SQL Server 2005, SQL Server stored procedures, SQL stored procedures, Stored Procedures
How do you set a SQL Server job step status?
I am running SQL Server 2005. I have a job that has six steps to load a database table from an external source. The external source is required to send the file nightly. In system testing I found this is not always the case. I created a batch ‘step’ (Step 3) to check if the [...]
Answer Question
| January 17, 2011 11:28 PM
SQL Jobs, SQL Server 2005, SQL Server 2005 SP3, SQL Server database
I am running SQL Server 2005. I have a job that has six steps to load a database table from an external source. The external source is required to send the file nightly. In system testing I found this is not always the case. I created a batch ‘step’ (Step 3) to check if the [...]
Answer Question
| January 17, 2011 11:28 PM
SQL Jobs, SQL Server 2005, SQL Server 2005 SP3, SQL Server database
SQL Server Disk Alignment
What size should I set the Starting Partition Offset on the disks when running sql server 2005 32-bit enterprise edition, shuld it be 1024KB or 64KB?
Answer Question
| January 12, 2011 5:55 PM
SQL 2005, SQL Server, SQL Server 2005, Windows Server 2003, Windows Server 2003 32-bit
What size should I set the Starting Partition Offset on the disks when running sql server 2005 32-bit enterprise edition, shuld it be 1024KB or 64KB?
Answer Question
| January 12, 2011 5:55 PM
SQL 2005, SQL Server, SQL Server 2005, Windows Server 2003, Windows Server 2003 32-bit
IT Knowledge Exchange’s iPad Contest Starts Today!
Today marks a new contest around IT Knowledge Exchange. The Lowdown (i.e. The Rules**) Every member who earns 500 knowledge points in the next 4 weeks (between today and Wednesday, February 16th) will be entered into a drawing for 5 names. You must have a completed profile including a photo or avatar to be eligible [...]
Answer Question
| January 20, 2011 4:55 PM
AS/400, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, iPads, ITKE Contests, Linux, Lotus Domino, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows, Windows Server
Today marks a new contest around IT Knowledge Exchange. The Lowdown (i.e. The Rules**) Every member who earns 500 knowledge points in the next 4 weeks (between today and Wednesday, February 16th) will be entered into a drawing for 5 names. You must have a completed profile including a photo or avatar to be eligible [...]
Answer Question
| January 20, 2011 4:55 PM
AS/400, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, iPads, ITKE Contests, Linux, Lotus Domino, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows, Windows Server
SQL SERVER 2005 Storage Performance
We have an IBM server xSeries 460 with a QLogic FC HBA card 4gb on the server with a PCI-X 266MHz bus speed (16 CPU 667MHz FSB, 32GB RAM). The HBA card connects to a Brocade 5000 switch then to the SAN Controller then to a Cisco 9124 Switch then to SAN Drives all through FC. [...]
Answer Question
| January 18, 2011 6:30 PM
SQL Server, SQL Server 2005, SQL Server 2005 performance, SQL Server performance, Windows Server 2003, Xiotech
We have an IBM server xSeries 460 with a QLogic FC HBA card 4gb on the server with a PCI-X 266MHz bus speed (16 CPU 667MHz FSB, 32GB RAM). The HBA card connects to a Brocade 5000 switch then to the SAN Controller then to a Cisco 9124 Switch then to SAN Drives all through FC. [...]
Answer Question
| January 18, 2011 6:30 PM
SQL Server, SQL Server 2005, SQL Server 2005 performance, SQL Server performance, Windows Server 2003, Xiotech
SRS 2005 Export to EXCEL
Is there anyway to turn off Wrap Text formating on report rows/colimns as it is exported to EXCEL from Reporting Services 2005
Answer Question
| January 11, 2011 1:20 PM
SQL Export to Excel, SQL Server 2005, SQL Server Reporting Services, SSRS 2005
Is there anyway to turn off Wrap Text formating on report rows/colimns as it is exported to EXCEL from Reporting Services 2005
Answer Question
| January 11, 2011 1:20 PM
SQL Export to Excel, SQL Server 2005, SQL Server Reporting Services, SSRS 2005
Database file in Novell GroupWise
what is a data base file in novell groupwise.Is it associated with each novell file or there is only 1 which contains info for all other file
Answer Question
| March 16, 2012 10:39 AM
C#, Database Files, Novell, Novell GroupWise
what is a data base file in novell groupwise.Is it associated with each novell file or there is only 1 which contains info for all other file
Answer Question
| March 16, 2012 10:39 AM
C#, Database Files, Novell, Novell GroupWise
Running Multiple SQL statements through JCL
I need to run multiple sql statements seperatd by ‘;’. I want the execution to continue for all the SQL statements even if any of the SQLs throws out error. Is it possible?
Answer Question
| January 13, 2011 11:05 PM
DB2 SQL, JCL, SQL error messages, SQL Server, SQL statements
I need to run multiple sql statements seperatd by ‘;’. I want the execution to continue for all the SQL statements even if any of the SQLs throws out error. Is it possible?
Answer Question
| January 13, 2011 11:05 PM
DB2 SQL, JCL, SQL error messages, SQL Server, SQL statements
Alter proc to fetch a table structure from SQL Server 2005 database
hi please segest me… what is the problem in this proc. CREATE Procedure sp_tab @tablename nvarchar(517), @flags int = 0, @orderby nvarchar(10) = null, @flags2 int = 0 As if @flags is null select @flags = 0 if (@tablename = N’?') begin print N” print N’Usage: sp_table_struct @tablename, @flags int = 0′ print N’ where [...]
Answer Question
| January 7, 2011 9:59 AM
FETCH statement, SQL 2005, SQL 2005 Database, SQL Server 2005, SQL Server tables
hi please segest me… what is the problem in this proc. CREATE Procedure sp_tab @tablename nvarchar(517), @flags int = 0, @orderby nvarchar(10) = null, @flags2 int = 0 As if @flags is null select @flags = 0 if (@tablename = N’?') begin print N” print N’Usage: sp_table_struct @tablename, @flags int = 0′ print N’ where [...]
Answer Question
| January 7, 2011 9:59 AM
FETCH statement, SQL 2005, SQL 2005 Database, SQL Server 2005, SQL Server tables
Best tool for SQL Server 2000 – like golden is for oracle
what db tools are there to query ms sqlserver 2000 database? i’m used to using benthic’s golden for oracle databases – and would like a similar tool to use with sqlserver databases.
Answer Question
| January 10, 2011 10:08 PM
SQL 2000, SQL Database, SQL Server 2000, SQL Server database
what db tools are there to query ms sqlserver 2000 database? i’m used to using benthic’s golden for oracle databases – and would like a similar tool to use with sqlserver databases.
Answer Question
| January 10, 2011 10:08 PM
SQL 2000, SQL Database, SQL Server 2000, SQL Server database
SQLCMD does not create a log file
I have several SQL update/delete statements I run during a payroll cycle. When I run a SQL that does not have any records that meet the selection criteria, I do not get a log created. I can run the same SQL in SQLServer, and it shows (0 records updated).
Answer Question
| January 21, 2011 5:52 PM
SQL Log Files, SQL Records, SQL Server, SQLCMD
I have several SQL update/delete statements I run during a payroll cycle. When I run a SQL that does not have any records that meet the selection criteria, I do not get a log created. I can run the same SQL in SQLServer, and it shows (0 records updated).
Answer Question
| January 21, 2011 5:52 PM
SQL Log Files, SQL Records, SQL Server, SQLCMD
