thanks
I wrote a stored procedure. In this stored procedure, when no record is selected return 0. But when I execute the stored procedure, it returns null...
only one user. When I run the stored procedure in sql query analyzer, it became very slow. memory: 1GB cpu: 2.8Ghz windows xp professional service...
Hello, I Updated Statistics. But still very slow. Thanks
Hi, I removed MSDE on my computer and installed SQL server personal edition. After restored my database, it is very very slow now. how can I fix...
I got it! thanks. I put the script in to a html file to debug.
Hello, I write a vb script in active script task (DTS). But it has error. Hoe do I debug it? Function Main() strDate = DateAdd("d", -1, Now()) d =...
I set it to mixed mode(both windows and sql server). Thanks
Hi, Here is the error message Server Error in '/WebStats' Application....
Hi, My web application runs very well on my local machine. I use local SQl Server (MSDE). But after I deployed my application to web server it...
I've tried ITW but didn't set datefirst 1 thanks
One more question. According to the query, every week start from Sunday. I need to start from every Monday. Thanks
There are indexes on date and target column. Thanks
Hello, this is my new query. it takes 38 seconds to get the result. select date, avg(total)as average from (select...
Hello, The table is generated by IIS Log file. I am working on a web report project. I need to get average weekly avtive provider every month....
Thanks. The performance was approved.
Hi, I need to get some monthly, weekly report. But my query is very slow when it was run my local sql server. Anybody can help? below is my sql...
Separate names with a comma.
