Query timeout expired – State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0] on production server
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

upgrade SQL Server 2008 32-bit to 64-bit
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

Ensuring the Data security by hosting the server @cloud?
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

Database for OLTP
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

Effective ways for retrieving millions of records from a table?
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

Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB
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

Why should I use SSAS for Predictive Analytics?
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

Does something similar to Oracle’s optimizer hints exist in SQL Server ?
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

How to schedule SQL query to run in Microsoft SQL Server
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