Viewing 15 posts - 151 through 165 (of 359 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...
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...
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...
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....
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...
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...
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...
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....
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...
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...
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...
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...
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...
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...
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....
October 29, 2003 at 8:44 am
Viewing 15 posts - 151 through 165 (of 359 total)