Viewing 15 posts - 4,666 through 4,680 (of 7,429 total)
One thing I just oayed attention to is you stated pop-up menu???? which I have not seen in QA. Where are you doing this, what is the full test of...
October 12, 2002 at 3:27 pm
The only thing that sometiomes occurrs, is that it bloats the DB during the upgrade, not usually much but it is noticeable. It is best to run sp_updatestats, DBCC REINDEX...
October 12, 2002 at 3:23 pm
Simon,
Just curious to see if it something I missed, but what types of problems are you refering to about Temp Tables. I am aware of the SELECT...INTO causing blocking, improper...
October 12, 2002 at 10:46 am
To get around this you can use a single EXEC for the entire set of dynamic strings, works like any batch and will keep the table in scope for the...
October 12, 2002 at 9:28 am
Is TABLE A abd TABLE B both owned by DBO or is it possible they are owned by a user name. The best ways is to check in EM and...
October 12, 2002 at 7:15 am
TSQL I expect to remain a key part for a long time to come anyway, why else would we bother with a RDBMS standard anyway. MS is just proposing to...
October 11, 2002 at 2:18 pm
Couple ideas that might be affecting as well. 1 how many times did you run the query that took 4x as long, initially the data will be on the drives...
October 11, 2002 at 2:13 pm
Always glad to help.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
October 11, 2002 at 2:00 pm
Don't knwo for sure and cannot trouble shoot today but may still contain something unsupported, try the connection the SQL PLUS and see if you get the data or an...
October 11, 2002 at 11:43 am
I am afraid doing is null will not do exactly what you stated since the column will still be in the output. I don't have an example as I don't...
October 11, 2002 at 11:40 am
Alright, will you email to remind me to take a look at work whe I get back on Tuesday, I am home now and don't have time to retrieve as...
October 11, 2002 at 11:23 am
Then like I said, you need to parse them and put them together in a format that will make versions the same lenght in proper notation order before you try...
October 11, 2002 at 11:20 am
To elaborate on Allen's you can do
CONVERT(CHAR,GETDATE(),101) and it will return the date without the time as ytou requested.
Steve's works great and actually doesn't do one read that is...
October 11, 2002 at 11:16 am
quote:
I had considered this, but not in quite this regard. And I didn't think that you could UNION the recordset results of...
October 11, 2002 at 11:05 am
No only, DELETE, INSERT, and UPDATE. You can however create a trace to watch for selects but it does add a bit to the server load (not a lot just...
October 11, 2002 at 7:24 am
Viewing 15 posts - 4,666 through 4,680 (of 7,429 total)