RE: Update Join taking an unreasonable time to complete?
So if it takes 3 minutes to Update 1000000 Records, then it would take 69 Minutes to Update 23000000 records if you were to do it 1000000 records at a time!Right?
2004-02-22
DDL trigger
RE: OPENXML and non-ascii characters
Answered my own questions after a bit of rtfm (sorry for being so lazy). Didn't know a SP could have ntext as a parameter!!
2004-02-10
2 reads
RE: Stored Procedure Use Results from another?
If you are using SQL 2K you may want to examine using a table returning or inline user-defined function. You can almost look at these like a parameterized view. It can get messy when nesting sp's.
2004-02-06
RE: Index on concatenated text or different columns
Our calendar table has a generated key as the primary key. The records in our data warehouse then contain the date key that corresponds to the date. The rest of the columns in the table contain are just multiple representations of the date. This scenario allows for queried to search by multiple different date representations […]
2003-12-23
1 reads
RE: Comments and Bugs on New Design
quote: I just modified the homepage slightly to trim it down a bit and add some more functionality. Could you let me know what you think? I've added most recent 5 threads (real time) and QOD and scripts. Nice goodie, although I still prefer the Active topics page. What about moving the 'Logout' link one […]
2003-11-26
1 reads
2003-11-18
RE: BACKUPS FAIL
Sounds like the backup routine can't read pages form the DB. Like Allen said, I'd check your disks first. Run a consistency check or a CHKDSK. Also, run a DBCC CHECKDB to make sure you don't have any corruptions.
2003-08-06
RE: QOD 30/07/2003 Incompetent Inc
Very good!! You forgot the HR director Mr Pay_Peanuts_Get_Monkeys
2003-07-30
2003-07-15
1 reads
RE: Option to see threads that I'm involved in?
Steve, That's fine and it was just a suggestion from me. I've only see the option on one other site that I go to. If you want, check out www.tek-tips.com it's free to join. One of the links on the left is My Threads. It's come in handy for me, especially when I want to […]
2003-07-10
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
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