Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tim
Starting Member
392 Posts |
 Posted - 2003-06-20 : 01:22:28
|
| [url]http://www.wibsite.com/wiblog/dull/[/url]imagine a dull SQL blog..."I wrote a stored procedure today. It had four parameters, none were OUTPUT so it only processed input values""An index in my database had a fill factor of 80%. This is the default value." |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-06-20 : 03:00:30
|
http://www.sqlblogs.com/quote:
Got a good question today. A developer I work with asked if we should use locking hints using WITH, or not...For example:SELECT name FROM table1 WITH (NOLOCK)works the same as:SELECT name FROM table1 (NOLOCK)
Damian |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-20 : 09:44:04
|
http://www.sqlblogs.com/quote:
In this market, there are generally two types of SQL Server professionals - the sysadmin DBA, or the developer DBA. Sysadmin DBAs usually work on pager rotations, support several SQL Server instances, clustering, and troubleshooting of all sorts. For sysadmin DBAs, the top skills are:Backups, Restores, Disaster Recovery planning Security Installation of SQL Server, service packs Database integrity and optimization Operating System basics Transact-SQLFor developer DBAs - you are usually part of a project or projects, developing the database backend on behalf of programmers. The priority for a new SQL Server professional in this case would be:Transact-SQL Performance tuning, indexing Depending on the project, Analysis Services.I recommend in either case learning Transact-SQL first - you cannot go wrong with this.
YA THINK?Brett8-)EDIT: And how is Tim a "starting member"? Is that a "custom" title?Edited by - x002548 on 06/20/2003 09:45:14 |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-06-20 : 09:51:05
|
| Tim once was foolish enough to ask Graz if he could always be "Starting Member" so that nobody could ever blame him for giving bad advice.You know what they say, "Careful what you wish for"Damian |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-20 : 09:58:22
|
| Good advice....As far as that blog goes...I can't figure out how to join...I was going to post one our more obscure posts and see what the response was...uh...uh..uh....Brett8-) |
|
|
|
Tim
Starting Member
392 Posts |
Posted - 2003-06-22 : 18:57:25
|
| it's a little known secret, but if you click enough banners graz will give you a custom title. |
|
|
|
|
|
|
|
|
dull