I process a lot of data that belongs to other companies. Much of this data has to first be acquired from various ftp sites. So, I want to ftp in information and then process it, so I use DTS to do the whole shabang. I use the built-in Windows FTP program, FTP.exe, to ftp in […]
2003-04-24
1 reads
Why don't you run a profiler trace on the stored procedures that the web app is executing , maybe you will find something there . Also look at your stored proc's if they have the with recompile option enables - if so ...disable it , let sql use the buffer manager to read execution plans […]
2003-04-24
Another little thing, you will have to play/read up on all the possible values for type, xtype etc to ensure you have the correct "text" type fields. Here's a useful view that I use to get table and column lists, that I wack through an access report. SELECT TOP 100 PERCENT dbo.sysobjects.name AS table_name, dbo.syscolumns.name […]
2003-04-24
1 reads
A weird request, but one that could be solved writing some dynamic SQL. 1. Iterate through the list of tables in the database that contain "text" type fields. Probably best declaring a cursor on 'sysobjects' selecting name and id where the xtype = 'U'. You could do it all in one by linking across to […]
2003-04-24
1 reads
On a similar note, if my SQL 7 database is set up to be case insensitive, how would I go about checking whether a column is all upper case or not? If I did just a where address1 = upper(address1) I get everything back TIA Andre
2003-04-23
2 reads
Can't speak to the view through EM but, to get the formula I would GUESS that you could script out the table and see the computation associated with that column. Curious if that works so, let me know. Thanks. David
2003-04-23
1 reads
If you can run sp_who2 and sp_lock, I would start there. When you run sp_who2 look at the BlkBy column to see what process is blocking the others. Check that process out in the sp_lock results and start your troubleshooting there. BOL has some good information on the results from sp_lock that will help you […]
2003-04-23
2 reads
Can you capture both execution plans in text form and post so we can see the differences. I use them myself a lot and have gotten used to reading them. Maybe someone here will see in them a why. Just need the plan text and the query if possible that is being run.
2003-04-23
You will find specific instructions for doing this in the help that comes with SP3 I can't remember what the document is called, but if you unpack the service pack, I believe it's fairly obvious.
2003-04-23
We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.
2005-08-26 (first published: 2003-04-23)
48,016 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
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