Viewing 15 posts - 9,241 through 9,255 (of 9,720 total)
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
The best thing you can do for yourself, Jigisha, is practice, practice, practice.
There are still a lot of shops which use SQL Server 2000, which might make it worth your...
November 28, 2007 at 4:08 am
Chethan,
I doubt it's an appended backup issue. Media families usually refer to the media the backup is stored on. I.E., tape, UNC disk drive, local disk drive.
Unless you've...
November 27, 2007 at 7:37 am
HTTP Endpoints are much more secure. You can actually dictate the type of traffic you get and, I believe, the network protocol used to access it.
Not to mention you...
November 27, 2007 at 6:39 am
I had originally heard February, but that was like 6 months ago, so I'm not surprised my info is out of date. @=)
November 27, 2007 at 5:00 am
I don't know about demos. Some are good, some are bad. But most of them are canned. Which means the demonstrator is going to show you all...
November 27, 2007 at 4:58 am
In addition to Security (and the auditing available with DDL triggers), the main reasons I would add are SSIS, Solution Explorer, Database Mirroring and Snapshots.
DM & Snapshots are wonderful...
November 27, 2007 at 4:44 am
Are you working in 2000 or 2005?
You posted to the 2k5 forum, but EM is a 2000 tool and in 2k5 you not supposed to be able to...
November 27, 2007 at 4:32 am
Viewing 15 posts - 9,241 through 9,255 (of 9,720 total)