Viewing 15 posts - 151 through 165 (of 360 total)
One of my best friends works in the banking industry, but not as a DBA, something to do with networking. I believe he's been a VP a...
Quand on parle du loup, on en voit la queue
November 13, 2003 at 7:43 am
Yes, that is bad news. Since I rarely worked on a data warehouse system having the Business Intelligence as a requirement could be a challenge.
But knowing...
Quand on parle du loup, on en voit la queue
November 12, 2003 at 12:37 pm
A data warehouse design would be different than a transactional design.
For me, the difference is how the data will be used. I think of a transactional database as one...
Quand on parle du loup, on en voit la queue
November 12, 2003 at 12:27 pm
You are right. You have deadlock issues.
It is specifying which thread has been chosen. SQL Server will terminate the chosen thread and any sub-threads to break the deadlock cycle.
Dr....
Quand on parle du loup, on en voit la queue
November 11, 2003 at 11:23 am
I meant to say that I don't know of any company that hires a DBA using the Microsoft Certification as the main requirement.
Dr. Peter Venkman: Generally you don't...
Quand on parle du loup, on en voit la queue
November 11, 2003 at 6:53 am
It depends. Yes, with the old MCDBA it was only 4 tests and there are many MCSE/MCDBAs out there.
For most companies that are Microsoft Partners it only...
Quand on parle du loup, on en voit la queue
November 10, 2003 at 1:03 pm
At $125 (today's price) the MCDBA has moved from something that might cost $400 (back in the day of 4 tests, $100 each) to $875.
I wonder...
Quand on parle du loup, on en voit la queue
November 7, 2003 at 10:14 am
I was lucky to have a mentor for almost two years. That helped because he would give me tasks and we would discuss db issues.
I'm with Frank....
Quand on parle du loup, on en voit la queue
November 6, 2003 at 6:39 am
BillyWilly, sorry, I forgot to say that I deal with international numbers most of the time.
As others have said, numeric will cut off the leading zeros...
Quand on parle du loup, on en voit la queue
November 5, 2003 at 1:13 pm
Ok - saving phone numbers as bigint is wasting a lot of space.
I use the varchar data type for phone numbers since I do not use...
Quand on parle du loup, on en voit la queue
November 4, 2003 at 10:48 am
Yes, they are right. On the forms that don't work, check the recordsouce (in Properties).
You might also verify that the queries were upsized correctly. Down the...
Quand on parle du loup, on en voit la queue
November 3, 2003 at 7:52 am
How big are your log files? Are the log files and data files on the same disk?
This could be indexing, server or network related. Something you might...
Quand on parle du loup, on en voit la queue
October 31, 2003 at 6:56 am
I know I read somewhere that date and time will be separate data types in the next version of SQL Server.
Dr. Peter Venkman: Generally you don't...
Quand on parle du loup, on en voit la queue
October 29, 2003 at 11:14 am
Naming conventions...no thanks.
I started as a C/C++ programmer and did not use the "conventions". I switched over to Visual Basic and Access where the prefix convention is...
Quand on parle du loup, on en voit la queue
October 29, 2003 at 11:12 am
Laughing, yes, Frank. We exist in several languages. Most of my servers are English (default) but I had a couple of my developers install the French version....
Quand on parle du loup, on en voit la queue
October 29, 2003 at 8:44 am
Viewing 15 posts - 151 through 165 (of 360 total)