Slow response with SQL server over a network.
Hi, We do a simple select 1 million record over a client server setup with SQL server 2008 and it take 10 times more time to get the results that doing the same request with Microsoft access db. Exactly the same setup for the network. Any special setup in SQL server we are missing. thank [...]
Answer Question
| April 5, 2011 5:46 PM
Java, SQL Server 2008, SQL Server administration, SQL Server installation, SQL Server performance
Hi, We do a simple select 1 million record over a client server setup with SQL server 2008 and it take 10 times more time to get the results that doing the same request with Microsoft access db. Exactly the same setup for the network. Any special setup in SQL server we are missing. thank [...]
Answer Question
| April 5, 2011 5:46 PM
Java, SQL Server 2008, SQL Server administration, SQL Server installation, SQL Server performance
Win Drupal’s Building Blocks!
Are you a developer? Today’s free IT book is an essential addition to your library: Drupal’s Building Blocks. Learn how to quickly build web sites with CCK, Views, and Panels after you win this great resource. There are two ways to win this book: Answer one of five questions and post the link to your [...]
Answer Question
| April 12, 2011 3:29 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Drupal, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Storage virtualization, Virtualization, VoIP, Windows Server
Are you a developer? Today’s free IT book is an essential addition to your library: Drupal’s Building Blocks. Learn how to quickly build web sites with CCK, Views, and Panels after you win this great resource. There are two ways to win this book: Answer one of five questions and post the link to your [...]
Answer Question
| April 12, 2011 3:29 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Drupal, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Storage virtualization, Virtualization, VoIP, Windows Server
How to move sql server clustered instance to a separate stand alone server
We are in the process of moving our Production instance and databases. Would be of nice help if anyone could shed their thoughts on How to move sql server clustered instance to a seperate stand alone server (along with system and user databases). We are stopping the cluster, moving the drives to a seperate server [...]
Answer Question
| April 2, 2011 1:12 PM
SQL 2008, SQL Server, SQL Server 2008, SQL Server clustering
We are in the process of moving our Production instance and databases. Would be of nice help if anyone could shed their thoughts on How to move sql server clustered instance to a seperate stand alone server (along with system and user databases). We are stopping the cluster, moving the drives to a seperate server [...]
Answer Question
| April 2, 2011 1:12 PM
SQL 2008, SQL Server, SQL Server 2008, SQL Server clustering
How to handle record lock using embedded SQL?
I am using SQLRPGLE program,need to handle record lock in sql statement ..plz suggest?
Answer Question
| March 31, 2011 2:05 PM
AS/400 SQL, Embedded SQL, Embedded SQL in AS/400, SQL Server, SQLRPGLE
I am using SQLRPGLE program,need to handle record lock in sql statement ..plz suggest?
Answer Question
| March 31, 2011 2:05 PM
AS/400 SQL, Embedded SQL, Embedded SQL in AS/400, SQL Server, SQLRPGLE
Recovering lost data from SQL Server 2005
Running SQL Server 2005. I found that I had lost about 2000 records the Assets table and more records in the associated tables Timeassets and AssetBillingrates. Each of the tables uses an Id field as the Primary Key. I was able to identify the key records that had been lost and tried inserting them From [...]
Answer Question
| April 2, 2011 6:19 PM
INSERT statement, SQL Server 2005, SQL Server 2005 backup, SQL Server backup
Running SQL Server 2005. I found that I had lost about 2000 records the Assets table and more records in the associated tables Timeassets and AssetBillingrates. Each of the tables uses an Id field as the Primary Key. I was able to identify the key records that had been lost and tried inserting them From [...]
Answer Question
| April 2, 2011 6:19 PM
INSERT statement, SQL Server 2005, SQL Server 2005 backup, SQL Server backup
CPF5032 and SQL RPG
How do I unlock the data file to avoid halt ? CL used to sort file and call an RPG that cleared a field (followed by further processing). When I switch to an SQLRPG to clear the field, I get CPF5032 in the next program. Yes, I tried the UNLOCK op code in the SQLRPG [...]
Answer Question
| March 31, 2011 7:34 PM
AS/400, AS/400 SQL, CPF5032, SQL Server, SQLRPGLE
How do I unlock the data file to avoid halt ? CL used to sort file and call an RPG that cleared a field (followed by further processing). When I switch to an SQLRPG to clear the field, I get CPF5032 in the next program. Yes, I tried the UNLOCK op code in the SQLRPG [...]
Answer Question
| March 31, 2011 7:34 PM
AS/400, AS/400 SQL, CPF5032, SQL Server, SQLRPGLE
Free IT Book: Securing SQL Server by Mrdenny!
This week’s free IT book is especially exciting because it was written by Denny Cherry, who you may know better as mrdenny. He’s always providing quality and thoughtful answers, and we’re excited to share a whole compilation of his knowledge in Securing SQL Server: Protecting Your Database from Attackers. Denny is a Microsoft SQL Server [...]
Answer Question
| February 21, 2012 8:31 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, SQL Server security, Storage, Virtualization, VoIP, Windows Server
This week’s free IT book is especially exciting because it was written by Denny Cherry, who you may know better as mrdenny. He’s always providing quality and thoughtful answers, and we’re excited to share a whole compilation of his knowledge in Securing SQL Server: Protecting Your Database from Attackers. Denny is a Microsoft SQL Server [...]
Answer Question
| February 21, 2012 8:31 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, SQL Server security, Storage, Virtualization, VoIP, Windows Server
Create linked server from sql 2000 to sql 2005
Does anyone knows how to create a linked server in Sql 2000 regarding a database to Sql 2005. All I want to do is a selection from a table in sql 2005 and insert into a table in Sql 2000 Thanks in Advance
Answer Question
| March 27, 2011 7:41 AM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration
Does anyone knows how to create a linked server in Sql 2000 regarding a database to Sql 2005. All I want to do is a selection from a table in sql 2005 and insert into a table in Sql 2000 Thanks in Advance
Answer Question
| March 27, 2011 7:41 AM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2005, SQL Server migration
SQL Server 2008 Insert Into vs Insert Statement Recompile
I have a stored procedure that executes a t-sql statement using sp_executesql. This t-sql code recompiles everytime it runs using “INSERT INTO” but when I use “INSERT” only it will not recompile. What is going on here? sample: create table #test (id int) Recompile: insert into #test select id from mytable Not Recompile: insert #test [...]
Answer Question
| March 24, 2011 7:34 PM
SQL, SQL Server, SQL Server 2008, T-SQL
I have a stored procedure that executes a t-sql statement using sp_executesql. This t-sql code recompiles everytime it runs using “INSERT INTO” but when I use “INSERT” only it will not recompile. What is going on here? sample: create table #test (id int) Recompile: insert into #test select id from mytable Not Recompile: insert #test [...]
Answer Question
| March 24, 2011 7:34 PM
SQL, SQL Server, SQL Server 2008, T-SQL
Can two separate cursors update the same SQL table when executed together?
I have three tables. Table One is a master table which contains rows which need to be updated with data from the other two tables (I’ll call them Table Two and Table Three). I have created a cursor which updates existing rows in Table One with data from Table Two. This works fine, and following [...]
Answer Question
| March 23, 2011 10:57 AM
SQL Cursors, SQL Server 2005, SQL Server 2005 administration, SQL tables
I have three tables. Table One is a master table which contains rows which need to be updated with data from the other two tables (I’ll call them Table Two and Table Three). I have created a cursor which updates existing rows in Table One with data from Table Two. This works fine, and following [...]
Answer Question
| March 23, 2011 10:57 AM
SQL Cursors, SQL Server 2005, SQL Server 2005 administration, SQL tables
Trigger or Stored for lock and unlock database for 15 minute
Dear Sir, I create a login form in which if you insert password 3 times wrong then u r account is locked for next 15 minute. and we send a random password on referenced emailid which is sent after 15 minute. For these 15 minute the account isactive=’false’. So can u please help me to [...]
Answer Question
| March 23, 2011 8:49 AM
SQL Database, SQL Server 2005, SQL Server database, SQL Server triggers
Dear Sir, I create a login form in which if you insert password 3 times wrong then u r account is locked for next 15 minute. and we send a random password on referenced emailid which is sent after 15 minute. For these 15 minute the account isactive=’false’. So can u please help me to [...]
Answer Question
| March 23, 2011 8:49 AM
SQL Database, SQL Server 2005, SQL Server database, SQL Server triggers
Networking solution
I have a senario of SMB requiring a win2008 server, Apache web server, Sql database server, Exchange 2010. How many servers do I realistically have to get. 24 hosts with view to expand. And future interstate branches. Voip is a consideration also. VPN…….. The site is 2 floors. No infrastructure. Can anyone help with equipment [...]
Answer Question
| March 28, 2011 5:16 AM
Exchange 2010, LAN, Networking, SQL Database, WAN, Windows Server 2008
I have a senario of SMB requiring a win2008 server, Apache web server, Sql database server, Exchange 2010. How many servers do I realistically have to get. 24 hosts with view to expand. And future interstate branches. Voip is a consideration also. VPN…….. The site is 2 floors. No infrastructure. Can anyone help with equipment [...]
Answer Question
| March 28, 2011 5:16 AM
Exchange 2010, LAN, Networking, SQL Database, WAN, Windows Server 2008
Declaring the same file twice with two OPENID and reading the same file twice in CL Program
Is it posssible read a db file while declaring twice with openID and reading the same file twice
Answer Question
| March 24, 2011 3:32 AM
AS/400 Database File, CL programming, Database Files
Is it posssible read a db file while declaring twice with openID and reading the same file twice
Answer Question
| March 24, 2011 3:32 AM
AS/400 Database File, CL programming, Database Files
Reading a file in Reverse Order in CL Program
) In CL program how can we read a data base file in reverse order.
Answer Question
| March 26, 2011 3:28 AM
AS/400 Database File, CL Program, Database Files
) In CL program how can we read a data base file in reverse order.
Answer Question
| March 26, 2011 3:28 AM
AS/400 Database File, CL Program, Database Files
What is Broker EventHandler Wait Event?
I keep seeing this wait stat “Broker_EventHandler” in the SQL Server wait stats with high duration times. What is Broker_Eventhandler? Why does it have high wait times?
Answer Question
| March 23, 2011 7:13 PM
Event handlers, Service Broker, SQL, SQL Server, SQL Server 2008
I keep seeing this wait stat “Broker_EventHandler” in the SQL Server wait stats with high duration times. What is Broker_Eventhandler? Why does it have high wait times?
Answer Question
| March 23, 2011 7:13 PM
Event handlers, Service Broker, SQL, SQL Server, SQL Server 2008
Should I enable service broker on SQL Server 2008?
I am not too familiar with service broker, should I enable it on all databases on my production server? If yes why?
Answer Question
| March 23, 2011 7:05 PM
Service Broker, SQL, SQL Server, SQL Server 2008, SQL Server Enterprise Edition
I am not too familiar with service broker, should I enable it on all databases on my production server? If yes why?
Answer Question
| March 23, 2011 7:05 PM
Service Broker, SQL, SQL Server, SQL Server 2008, SQL Server Enterprise Edition
In a single CL Program, can we read a database file more than once?
In a single CL Program, can we read a database file more than once
Answer Question
| March 22, 2011 8:03 AM
AS/400 Database File, CL Program, CLLE, Database Files
In a single CL Program, can we read a database file more than once
Answer Question
| March 22, 2011 8:03 AM
AS/400 Database File, CL Program, CLLE, Database Files
I want to delete records from a PF outside a PGM
I need to either setup a SQL that lets me pass a variable so that I can delete records based on a moving date. Or, I want to setup a CPYF command that will allow me to copy records that are *LT a variable (date). I’m not sure how to pass variable to either idea.
Answer Question
| March 22, 2011 3:25 PM
CPYF, PGM, SQL, SQL commands, SQL Server
I need to either setup a SQL that lets me pass a variable so that I can delete records based on a moving date. Or, I want to setup a CPYF command that will allow me to copy records that are *LT a variable (date). I’m not sure how to pass variable to either idea.
Answer Question
| March 22, 2011 3:25 PM
CPYF, PGM, SQL, SQL commands, SQL Server
Free IT Book: The Accidental Administrator: Cisco ASA Security Appliance
This week’s free IT book comes with a bonus interview with the author, Don Crawley! Check out what he has to say about the book, the process, and the joys of being an IT-type personality. Then answer one of the questions below and post the link to your answer in the discussion section for your [...]
Answer Question
| March 24, 2011 2:29 PM
AS/400, Channel, CIO, Cisco ASA, CRM, Database, DataCenter, Development, Don Crawley, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week’s free IT book comes with a bonus interview with the author, Don Crawley! Check out what he has to say about the book, the process, and the joys of being an IT-type personality. Then answer one of the questions below and post the link to your answer in the discussion section for your [...]
Answer Question
| March 24, 2011 2:29 PM
AS/400, Channel, CIO, Cisco ASA, CRM, Database, DataCenter, Development, Don Crawley, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
What wiki software do you recommend?
Just as the title suggests, what wiki software (DokuWiki, MediaWiki, etc…) do you suggest to run? The purpose of this is nothing more than to make a remote note-taking sort of scenario, so it’s not something for anyone but me to be used. I know I could do my own thing and stuff, but I’d [...]
Answer Question
| March 19, 2011 3:02 AM
Linux, MongoDB, MySQL, MySQL 5.0, PHP, Wikis
Just as the title suggests, what wiki software (DokuWiki, MediaWiki, etc…) do you suggest to run? The purpose of this is nothing more than to make a remote note-taking sort of scenario, so it’s not something for anyone but me to be used. I know I could do my own thing and stuff, but I’d [...]
Answer Question
| March 19, 2011 3:02 AM
Linux, MongoDB, MySQL, MySQL 5.0, PHP, Wikis
