RE: Paramerized queries -OK in Access, but not SQLS2k?
Frank's friend Erland has written a fine essay on this problem:http://www.sommarskog.se/dyn-search.html
2004-02-03
events
RE: Can you write out multiple views automatically?
Bill, I'm glad we all could help, even if we like to get off topic once in a while. Usually Frank's replies are right on the mark and helpfull. They will likely lead you down a path of resolution you will not regret. That is the case in this thread also. If / When Frank does make a […]
2004-01-30
1 reads
RE: Need HELP on data cleaning query - simple really, just forgot syntax
CAST(REPLACE(qtyavail,',','') as numeric(9,2)) + CAST(REPLACE(qtyavail and qtyatbranchavail) as numeric(9,2))
2004-01-30
RE: Restoring system databases to different SQL Edition
I haven't tried this either, but if the SP levels are the same I'd guess it would work. I have had issues restoring an SP3 master to a lower level server.Good reason to know what SP level your backups are on.
2004-01-29
RE: Restoring system databases to different SQL Edition
I haven't tried this either, but if the SP levels are the same I'd guess it would work. I have had issues restoring an SP3 master to a lower level server.Good reason to know what SP level your backups are on.
2004-01-29
2004-01-28
RE: Running packages held in structured storage files
I have done both. They seem to work quite nicely either way.In a structured storage file, there are multiple versions of a package in a single storage file. And there may be multiple logical packages in a single storage file. I learned this recently at a job I finished recently. I am considering using this […]
2004-01-28
1 reads
RE: Bulk Insert And Table Data Type
Sorry, I do not know "off the top", but i know BULK INSERT #TempTB .... works. Can you use a #TempTB instead of a @Table variable?
2004-01-28
1 reads
RE: Problem with "Ingore duplicates" index option
"I could insert a batch of records into with the hope that SQLSvr would insert records that didn't already exist in Table1 and ingore (not insert) any that already did exist in Table1."I don't think it is good to enable 'Ignore duplicates' in unique key. In your case, you can achieve it by try INSERT INTO […]
2004-01-28
1 reads
RE: SQL database backups and recovery using Legato
What are you lokking to restore? Just a single database or one of the system DB's?If it is just regular database, assuming you have the correct BSM for SQL Server installed, you can perform the restore on the active node with no issues. Just make sure all active sessions are disconnected and start the restore […]
2004-01-27
1 reads
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