Hello, I am getting the below error on customer production error, Query timeout expired – State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] The queries are forming on the fly using MFC’s record sets. if I try to run that queries on SSMS directly I am not getting that error. How to identify exactly which query leads this [...]
Answer Question | August 20, 2012 8:38 AM
Microsoft SQL Server, SSMS
We have a new SQL STANDARD SERVER 2008 R2 x64, and an existing SQL STandard Server 2008 R2 x32. I want to migrate the database from the old x32 bit to the new x64 bit machine. Has anyone got any information regarding this, or resource to research read up on. Thank you
Answer Question | January 1, 2012 11:54 AM
Microsoft SQL Server
How you are ensuring the Data security by hosting the server @cloud?
Answer Question | May 3, 2010 9:28 PM
Microsoft SQL Server, SQL Server, SQL Server 2008 R2
Which database is most suited for OLTP? Is it Oracle or Microsoft SQL?
Answer Question | April 22, 2010 11:26 AM
Microsoft SQL Server, OLTP, Oracle SQL
I have two tables – [em]Users[/em] and [em]UserAddress[/em] — with 30 million records in each.
Answer Question | November 4, 2009 8:48 PM
Data Tables, Microsoft SQL Server, SQL tables
I have a need to push data from the AS/400 to an SQL DB on an SQL 2008 server. I was wondering if there was a way to do this natively within RPG on the AS/400 without purchasing something. Was thinking embedded SQL or stored procedures might be able to accomplish this. Has anyone done [...]
Answer Question | September 24, 2009 3:35 PM
AS/400, Embedded SQL, Microsoft SQL Server
We are considering tools for Predictive Analytics in Law Enforcement, and I have been asked to find the advantages of SSAS, especially in SQL 2008. What are your thoughts on the product and what can it do for us?
Answer Question | September 8, 2009 2:30 PM
Microsoft SQL Server, SQL Server 2008, SSAS 2008
In Oracle, one can alter execution plans for SQL statements manipulating the optimizer with the help of hints. Hints can be used to alter access paths, join orders, etc… Does something similar exist in Microsoft Sql Server ?
Answer Question | April 19, 2009 8:59 PM
Microsoft SQL Server, Optimizer, Oracle, SQL, SQL Server, SQL tuning
I have a query that I want to automatically schedule to run daily. How do I do this?
Answer Question | September 17, 2012 4:19 PM
Automated SQL Query, Microsoft SQL Server, Scheduled Tasks, SQL Query