Check with profiler that the SQL code you think is being passed to SQL Server is the code that is actually being sent to SQL Server from the asp page. Also, think about using stored procs and parameters for these kind of affairs. Will definitely simplfy matters.
2003-06-12
Have alook at using the DBCC ShrinkFile statement, rather that trying to shrink the entire database with a wizard. DBCC ShrinkFile works on a size parameter, rather than a a post shrink percentage of free space, so is both easier for yourself, and more efficient for sql server.
2003-06-12
2 reads
quote: Not to labour the point too much but if the intention of the question was to elicit an answer to 'why can't Enterprise Manager see the local drives' then I reckon the answer was phrased wrong It's good to see that also native english speaker have problems with these questions. For me, understanding the […]
2003-06-12
1 reads
Your understanding is correct, because the dynamic sql will be executing in a differenc scope to your main procedure you will have to include the WHOLE cursor operation (declare, open, fetch, close, deallocate) within your dynamic code.
2003-06-12
2 reads
We use ColdFusion and a ColdFusion based content management system by PaperThin called CommonSpot. I encourage my developers to avoid direct access to tables and to use stored procedures for just about everything. We gained a huge performance boost by using this method. If I understand the process, to run a direct query on a […]
2003-06-12
1 reads
Got this from someone on this site. I cannot take credit for it. I cannot remember who it was... ALTER TABLE TableWithDuplicates ADD EliminateDuplicates_RowID int NOT NULL IDENTITY(1, 1) DELETE FROM t1 FROM TableWithDuplicates t1 JOIN( SELECT EliminateDuplicates_RowID=MAX(EliminateDuplicates_RowID), Field1, Field2, Field3, Field4 FROM TableWithDuplicates GROUP BY Field1, Field2, Field3, Field4 HAVING COUNT(*) >= 2 ) […]
2003-06-11
2003-06-11
1 reads
Try changing your client Net Lib to Named Pipes MW Edited by - mworku on 06/11/2003 8:34:40 PM
2003-06-11
2003-06-11
1 reads
http://support.microsoft.com/default.aspx?scid=kb;en-us;290991#4
2003-06-11
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Please, let me reiterate: The only valid test of a backup is a restore....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers