Search Results

return null in stored procedure

Thread by: LindaLi, Sep 19, 2005, 4 replies, in forum: Non-Transact SQL Developer Performance Tuning

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...

Dabase became very slow after installed personal

Thread by: LindaLi, Aug 11, 2005, 5 replies, in forum: General DBA Questions

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...

debug active script task in dts

Thread by: LindaLi, Aug 1, 2005, 2 replies, in forum: General Developer Questions

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 =...

SQL Server Access denied

Thread by: LindaLi, Jul 22, 2005, 4 replies, in forum: General Developer Questions

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...

get average weekly active provider

Thread by: LindaLi, Jul 12, 2005, 9 replies, in forum: T-SQL Performance Tuning for Developers

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....

How to speed up query with count function

Thread by: LindaLi, Jul 11, 2005, 6 replies, in forum: T-SQL Performance Tuning for Developers

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...