RE: Consulting $$$ question
Based on the data at , I would say the going rate is $60 - $65 per hour. Of course, if you are an IC and setting up the engagement yourself, I would double those numbers.
2003-07-22
SQL Connections
RE: Overall Scorecard ?
quote: Yes, QOD is a great feature. I specially come to this section to enjoy QOD. This is cool; keep it going. But I am wondering what would happen to the points that once gathers and how to find out how many points has one gathered thus far? You can find out how many you […]
2003-07-15
RE: SQL 6.5 - Alias
user aliases are in table sysalternates. verify this table and chech the ids against the syslogins. You can use sp_dropalias to drop the user alias or manually deleting it from the sysalternates tables provided that the user does not own any objects
2003-07-14
1 reads
RE: migrate a text column
But the IMPORT/EXPORT wizard is on SQL 2000 ? there is not a IMPORT/EXPORT wizard in SQL 6.5, is it true ?
2003-06-26
RE: After Insert Trigger
The trigger fires within the transaction created by the Insert statement. If you do not want the trigger to rollback the Insert statement, you will have to drop the trigger. Must check why the trigger is failing the transaction.
2003-06-25
RE: migrate a text column
Do you have the original DB or a backup somewhere? If so try installing to another server and do an import using the IMPORT/EXPORT wizard. Sounds like something in your BCP broke the data incorrectly.
2003-06-25
RE: Security Methodology Using Roles
I don't think any of us are saying developers can't be trusted. I've been a developer, a DBA, a system admin, and now I basically do all three plus architecture. So I appreciate the developer's viewpoint, as I think most of the others who have responded do as well. However, we are saying apply the […]
2003-06-25
1 reads
RE: migrate a text column
I don'to know...but word documents saved in this column can not be opened; the error is "format not valid"; if i create a new doc (in word) and save it in the column (SQL 2000) there is no problem. The problem is only with imported rows with bcp in.
2003-06-25
RE: Date Function
Just noticed you said your date field actually stored time portion too. Change to this: SELECT * FROM MyTable WHERE DATEADD(D, 0, DATEDIFF(D, 0, MyDateField)) BETWEEN DATEADD(D, -1, DATEDIFF(D, 0, GETDATE())) AND DATEADD(D, 0, DATEDIFF(D, 0, GETDATE())) [/quote]
2003-06-24
RE: Date Function
Hi rmilford, quote: today -1. what about declare @mydate datetime set @mydate = getdate()-1 print @mydate ? Cheers, Frank
2003-06-24
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