Joe, your point is quite applicable when handling more complex functionality like vectors.But, sometimes there is only one question with one yes/no answer. The only way I know to explicitely enforce this in SQL is to use a non-nullable bit datatype. As you say, though, it's not portable. But, honestly, I'd have to re-learn SQL to make […]
2004-10-07
This may help you but not that much. Try use LogPI or Entegra dbcc log(mydatabase_name, 2)
2004-08-04
Hi, I have chnaged this to the following to make it compile, however, There is value in the Return Parameter apart from '''. This Stored Procedure is now working in SQL Server. This is SQL Server 7. Could that be an issue? RegardsDave
2004-08-02
I'd convert the 3 dates to YYYYMM format: SELECT * FROM table_name WHERE CONVERT(char(6), some_field,112) BETWEEN CONVERT(char(6), lower_date_field,112) AND CONVERT(char(6), upper_date_field,112)
2004-06-23
I forgot to mention that I really can not use a temp table to store a second copy of TABLE1. There are several DTS jobs that are doing something similar. Each of these DB2 tables contains millions of records that can be up to 30GB. I can not afford to have these DTS jobs creating and […]
2004-06-11
If you want speed, you should use nolock. If you absolutely must have the most up to date data, don't use nolock. The difference being that a Select without nolock will wait for any uncommmited transactions to clear before selecting the data. With nolock it will give you whatever is commited to the database.cl
2004-03-19
If your users are connecting through an application server you can put the SQL Server behind a firewall and just allow access through the firewall to the app server IP address, thus denying enyone else access.
2004-03-04
net stop mssqlservernet start mssqlserverand schedule it at windows level (at command).
2004-03-04
No, not me! But I know a friend who knows someone who has heard, that there might be some people... Actually I only thought about why always reinvent the wheel when someone else has done similar before.
2004-03-03
- keep sql-injection in mind ! Check http://qa.sqlservercentral.com/columnists/chedgate/sqlinjection.asp- just define your variables as sp-parameters and handle your statement in your sp. You will soon discover it's best to work with known predicates.- check http://www.sommarskog.se/dynamic_sql.html and http://www.sommarskog.se/dyn-search.html
2004-03-03
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