RE: orphaned spids
I believe they altered: KeepAliveInterval KeepAliveTime SessionKeepAlive K. Brian Kelley bkelley@sqlservercentral.com http://qa.sqlservercentral.com/columnists/bkelley/
2002-04-02
1 reads
Lock and Connection Management
RE: Writing to a file from T-Sql
there is Bulk Copy. You can also use xp_cmdshell and isql to do this. Use the -Q and -o options with isql. Steve Jones steve@dkranch.net
2002-04-01
RE: hash matching
To my knowledge no. Is this code in a stored procedure? If so it could be a cached plan causing this, try recompiling. Also can you post the test version of the execution plans if this is not the case so I can understand the differences between the cases you discuss? "Don't roll your eyes […]
2002-04-01
RE: Cursors or not
I'd like to see a real test done on this issue. Im not a big fan of cursors, but they do have their place - usually more in an admin/maint role for scrolling through dbs, tables, etc, but sometimes they are the right tool. The while loop technique doesn't thrill me - it's barely set […]
2002-03-29
1 reads
RE: how track objects changes. . .
The best way is to run a trace and log it to a file that you can later import to a table. Andy
2002-03-29
RE: What is the script to use ODBC from oracle?
The version is Oracle v8.1.5, what i am trying to do is query the database for specific information and send it out again. I am not putting this into another database it will not be saved, just pulled in then pushed right back out. What is the best way to accomplish this? And is there […]
2002-03-28
1 reads
2002-03-28
1 reads
RE: can use variable in the from clause
Do you mean to use exec() function? Yes, it works, but how can I get the result from the dynamic sql, like select @result=max(id) from @tablename. Could you give me an example on how to do that? quote: not directly. You can, however, use dynamic sql for this. Steve Jones steve@dkranch.net Cheers Dev
2002-03-28
RE: Slow 1st Insert in ## table
seems like the procedure might be being recompiled every time its run..can you post the SQL
2002-03-28
RE: Slow 1st Insert in ## table
you could always just do the inserts into a regular table or table variable and then do a select into ##Adjust. Depending on the amount of inserts you are doing on ##Adjust, you could see a performance benefit - less traffic to the tempdb.
2002-03-27
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers