Gentlemen, thanks again for some slick T-SQL. So I can determine the column, but now I need to determine the value. I can use something like: SELECT @sql = 'SELECT ' & @ColName & ' FROM ' & @TableName & ' WHERE ' & @TableName & '_id = ' & CAST(@Id AS VARCHAR) EXEC (@sql) […]
2003-07-28
1 reads
Hi Hans, quote: Well, don't get me wrong. I won't, your opinion is very welcome! What a nice coincidence, someone else replied to this article http://qa.sqlservercentral.com/columnists/awarren/worstpracticesnotusingprimarykeysandclusteredindex.asp today. I'm going to read this first, before going any further Cheers, Frank
2003-07-10
I am afraid this is not the case, because the tempdb itself is not growing. It started today from 300Mb for data and 500Mb for log. Now it has 300Mb for data AND 8Gb for log. Just in one working day! I am affraid it will eat the whole disk before the work time is […]
2003-07-07
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-03
I would love the developers to change the code so they use the @@Identity. This is a much better solution than using NOLOCK. Unforetunatly, for this move to SQL 2K, management wanted to not make any code changes. I ran the trace and found that the transaction isolation level is not being explicitly set. So […]
2003-07-01
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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