Obviously America is the king of the acronymn world. I seem to remember that one of the US Navy commander in chiefs has an acronymn for his title of USINCUS. For all the non-US subscribers do we invent any acronymns or do we just inherrit American ones?
2003-05-30
2 reads
House keeping, updating of system tables in master! Hopefully someone else can shed a bit more light on details what MS SQL Server does internally / behind the scene when detaching a database.
2003-05-28
1 reads
If I understand your wishes, it seems like you want to use a subquery... SELECT col1, col2, ( SELECT min(col3) from othertable where condition ) as col3 FROM maintable WHERE condition Is that what you are asking? Guarddata-
2003-05-23
1 reads
Sounds like for whatever reason it can't enumerate the groups. Unless someone else has an idea, this sounds like a PSS call to Microsoft. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-05-20
Overall the performance should be the same but you are wasting 3 bytes per row of data so always use the simplest value. If you think you may expand the value beyond ture and false then consider using tinyint (can be 0-255) but otherwise use simplest whichs is bit. Also, keep in mind, do not […]
2003-05-20
1 reads
Can you post some data examples. Your explanation seems confusing. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-05-14
You can use an identity field as mentioned or add a date column to your client briefcase - which you could then use for extra functionality like finding 'dead' briefcases or assessing briefcase take-up after a publicity drive. SQL Server isn't a flat file system so there is no dirty way TIKO to assess the […]
2003-05-12
use an if statement to determine whether the field is not null or not empty: if !isNull(objRS("faxnr")) or objRS("faxnr") > "" then Response.write "Your fax number: " & <objRS("faxnr")> end if NB Have not checked the sytax but I trust you get the idea. Jeremy
2003-05-09
Thanks! Did some tests here and this is the solution i've implemented. I have a dedicated table I lock exclusively. The other tables in the procedure are only locked when necessary, so I don't block our production system while the procedure is running (it's an ETL procedure). When executing this proc twice, you'll notice the […]
2003-05-07
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