Viewing 15 posts - 2,731 through 2,745 (of 3,738 total)
How much physical Memory do you have on the machine and what is the MaxServerMem Set to?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 8, 2011 at 4:59 pm
ravi01031986 (7/8/2011)
I need to import Access db to SQL server using SSIS packages.Could some one tell me how to do these in the best possible way.I am having like 3...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 8, 2011 at 12:55 pm
Are you sure that qry_Reports and qry_PI_Reports referenced are not queries?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 8, 2011 at 12:37 pm
Thank you Gail. 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 7, 2011 at 4:41 pm
master.dbo (7/7/2011)
I remember reading functions in WHERE clauses aren't sargable or something like that.
Take a look at the following for an explanation.
http://stackoverflow.com/questions/799584/what-makes-a-sql-statement-sargable
http://www.sql-server-performance.com/2007/t-sql-where/2/
http://msmvps.com/blogs/robfarley/archive/2010/01/22/sargable-functions-in-sql-server.aspx
I hope this helps! 🙂
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 7, 2011 at 4:23 pm
The maximum size for SQL express 2008 R2 is 10240 MB for each DB.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 7, 2011 at 3:34 pm
sqlquest2575 (7/7/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 7, 2011 at 2:17 pm
Given the naming convention, the qry_Reports and qry_PI_Reports Tables seem like ad-hoc temporary tables, a.k.a. garbage. 😉
If you can't find them, ask as was sugested and if nobody ones what...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 7, 2011 at 1:46 pm
If the table is missing then recreate it in SQL Server and the populate it.
You should tweak the indexes and remove reserved words and spaces in column names, etc so...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 7, 2011 at 1:40 pm
toddasd (7/6/2011)
sqlquest2575 (7/6/2011)
Hi Todd..As suggested, I ran below statement in the database but the result came out empty
So, if this returned nothing
select * from information_schema.tables where table_name = 'qry_Reports'
then...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 7, 2011 at 9:56 am
I see that you are still trying to use a "SELECT DISTINCTROW".
Did you every try what I suggested?
Edit then copy & paste.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 7, 2011 at 7:22 am
sqlquest2575 (7/6/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 6, 2011 at 4:25 pm
sqlquest2575 (7/6/2011)
Hi Todd..As suggested, I ran below statement in the database but the result came out empty
Is there a different schema?
What happens if you query on the table directly?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 6, 2011 at 3:49 pm
sqlquest2575 (7/6/2011)
Hi Todd..As suggested, I ran below statement in the database but the result came out empty
What are you talking about? :hehe:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 6, 2011 at 3:33 pm
Welsh Corgi (7/1/2011)
sqlquest2575 (7/1/2011)
(Is that a problem as...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 6, 2011 at 2:56 pm
Viewing 15 posts - 2,731 through 2,745 (of 3,738 total)