Viewing 15 posts - 8,926 through 8,940 (of 9,720 total)
TheSQLGuru said:
Brandie, you are totally off the mark. Do whatever you can to make the most money so you can live a better life and do/enjoy the things...
March 7, 2008 at 9:30 am
Roy,
Have you ever thought about talking to your boss about this? Ask him why you've stopped getting recognition?
It could be he has higher expectations of you since that moment...
March 7, 2008 at 8:35 am
BTW, the OP mentioned he applied for this job because he has to pay the mortgage. I notice, however, he didn't mention at all whether or not he's actually...
March 7, 2008 at 7:51 am
Lynn Pettis said:
I just wish the computer would do want I want, not what I tell it to do. It would be sooo much easier.
Amen to that!
I...
March 7, 2008 at 7:31 am
Mark said:
Dear Ms. Gila Monster,
NO, I am not being honest about my lack of knowledge of SQL Server! Think about it!! If my resume is junior level, nobody will even...
March 7, 2008 at 7:17 am
FYI, I know I need to reverse the BeginDate in the above code with the DateAdd. But it was when I got to the AND part of the WHERE...
February 29, 2008 at 12:15 pm
Okay, but we're still running under the assumption that @StartDate and @EndDate are constants set by the coder/end user. What if they're dynamic?
I have a situation where I actually...
February 29, 2008 at 12:13 pm
That's what I'm wondering, Ruben. I asked that in an earlier post and haven't seen a response yet.
I can't think of a good way to optimize that one. ...
February 29, 2008 at 11:11 am
If you want to go with Jeremy's suggestion, you can also throw an index on the Temp table to speed your searching. Though, it might not be worth it.
Regardless,...
February 29, 2008 at 9:00 am
Matt,
You actually have a separate DB to do the scrubbing?
Hmmm. I didn't think about that idea. Originally I was going to use staging tables in the DW, but...
February 29, 2008 at 4:53 am
The most common function I use in a WHERE clause is a convert. Usually "WHERE Convert(char(10),ModifiedOn,101) = Convert(char(10),GetDate(),101)". Usually because I'm in the middle of a data update...
February 28, 2008 at 11:54 am
Hmm. The flaw with the variable idea is if there are no records yet, even if you use an isnull(max(customerkey),0), it will fail the task as unable to set...
February 28, 2008 at 8:26 am
The mainframe data for customer names is close. Firstname is 10 characters, LastName is 15 characters and they keep middle initials (1 character) that we don't track in SQL....
February 28, 2008 at 8:08 am
You've hit the nail pretty much on the head.
We have two OLTP systems where from our SQL Server we export the data to the mainframe. The mainframe system has...
February 27, 2008 at 6:45 am
Have you looked into transactional replication?
There's also database mirroring that might help you.
February 27, 2008 at 5:56 am
Viewing 15 posts - 8,926 through 8,940 (of 9,720 total)