Viewing 15 posts - 3,436 through 3,450 (of 3,738 total)
Having SQL Server and your Web Applications is a big security risk...
Is this the production environment?
Why are you returning 59K records?
Are you calling the Web Application from your local PC?...
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/
March 5, 2010 at 12:55 pm
Are you only having this problem with this query (datasource)?
What happens if you export the results of a small table from one of the sample databases?
What happens if you simplify...
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/
March 5, 2010 at 12:28 pm
Is this an internal or external Web Application?
It is recommended to have separate DB & Web Servers.
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/
March 5, 2010 at 12:22 pm
I assume that you examined your project in BIDS?
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/
March 5, 2010 at 12:14 pm
Have you tried creating a log file?
You mentioned that you went into debug mode, I assume that you set breakpoints?
Double check the properties on your flat file connection manager...
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/
March 5, 2010 at 12:10 pm
What OS's are used on the DB Server and Web Server?
How many hops is it taking to go from the Web Server to SQL Server?
What protocol are you using?
Are you...
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/
March 5, 2010 at 11:57 am
Thank you Lutz, please accept my apology for not asking for complete information...
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/
March 5, 2010 at 8:36 am
It would appear that you answered your own question, way to go bro!
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/
March 5, 2010 at 7:53 am
Very well stated Lynn.
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/
March 5, 2010 at 7:40 am
Do you have a SAN?
Can you back up to the SAN or local Disk storage. THen you can perform tape backups./
Backing up across the network is going to be extemly...
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/
March 5, 2010 at 6:47 am
Go into Single User Mode.
Run the DBCC INPUT BUFFER Command an run a SQL Trace, etc.
Check your DMV's, etc
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/
March 5, 2010 at 6:41 am
Regardless, you have exceptional skills and I respect you very much!
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/
March 5, 2010 at 6:29 am
Thank you for your feedback.
I will accept the advice of anyone on this issue.
But if you perform a backup to a disk that is not on the same Network Segment...
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/
March 5, 2010 at 6:25 am
Gail,
btw, that was an awesome catch on the cluster.
You are exceptional and you amaze me. You are a great asset to this forum.
But I guess that I should tell you...
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/
March 5, 2010 at 5:59 am
I completely understand what you are through and I feel for you
Your are fighting a loosing battle.
I try to win over the user base but that puts you at ...
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/
March 4, 2010 at 3:35 pm
Viewing 15 posts - 3,436 through 3,450 (of 3,738 total)