Viewing 15 posts - 9,241 through 9,255 (of 9,728 total)
Well, gosh darnit! Now I have to go begging up to Corporate (who has outlawed new SQL 2000 installs) and see if they will give me a copy of...
November 29, 2007 at 7:32 am
Microsoft seems to have their documentation mixed up. Here's where I got my information:
Books Online - Index Search - pages [SQL Server], about pages
Page Types:
Data
Data rows with all...
November 29, 2007 at 7:30 am
I have to agree with Timothy. It depends on what your employer of choice is looking for.
I originally used the cert material as a method of learning the basics...
November 29, 2007 at 6:40 am
I just tried running through the installation of SQL Server 2000 Developer. I tried adding components to my existing install of the SQL Server. There was nothing there...
November 29, 2007 at 6:22 am
Well, the service is definitely installed on the server, but my client tools can't seem to access it. Do I need to install AS on my desktop to get...
November 29, 2007 at 5:09 am
You're correct there. The closest I got was when I started creating MS Access databases for various things while I worked for the records management firm. I was the...
November 29, 2007 at 4:59 am
Markus,
Thank you. That explains why I'm confused. I'm using the client tools on my desktop and should have gone straight to the source. @=)
Thanks again!
November 29, 2007 at 4:46 am
Loner,
I'm trying to figure out if it's already installed, though. How do I do that?
November 29, 2007 at 4:24 am
Clive, I didn't say I had no Real World experience. I said I had no professional experience. Professional = Paid official job title.
My father was a computer programmer,...
November 29, 2007 at 4:22 am
Ditto to Ed's reply with one clarification. @=)
The 2 byte overhead of VarXXXXX datatypes is basically a pointer (of sorts) that tells the data page that this field can grow...
November 29, 2007 at 4:07 am
I actually agree with getting everyone to sit down and contribute. The problem is that in practice it usually ends up being one person who sits down and creates...
November 29, 2007 at 4:05 am
Does SQL Server actually reserve the space on the disk for the field if it is varchar(8000) and only 100 characters are used?
Yes... Sort of. It doesn't actually...
November 28, 2007 at 12:37 pm
Heaven forbid that you should leave it up to the application developers. They'll design you a database that makes a DBA job a nightmare! And there are people...
November 28, 2007 at 12:24 pm
Clive,
They didn't introduce just one new cert. They introduced 4 of them. @=) All new SQL Server 2005 certification information can be found at the following link:
http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx
Hope this...
November 28, 2007 at 8:16 am
If you've been a DBA for 8 years already, go for the MCITP instead (SQL 2005 -and possibly 2008- certs). It'll look much better on your job history. ...
November 28, 2007 at 7:55 am
Viewing 15 posts - 9,241 through 9,255 (of 9,728 total)