Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Changing Taxonomy Expand / Collapse
Author
Message
Posted Saturday, December 27, 2008 7:03 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Wednesday, October 22, 2014 12:34 PM
Points: 31,181, Visits: 15,626
Comments posted to this topic are about the item Changing Taxonomy






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #626227
Posted Saturday, December 27, 2008 7:18 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 22, 2014 2:32 AM
Points: 1,260, Visits: 3,423
Why not to see the forum more simple organized...I agree...not bad idea!?
;)


============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #626228
Posted Saturday, December 27, 2008 11:26 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:17 AM
Points: 20,739, Visits: 32,524
Just using the ideas you have mentioned in your editorial, I see one problem, most posters don't mention what version of SQL Server they are using when asking for help. OP's have posted questions in the SQL Server 2005 forums, get SQL Server 2005 answers, and then complained because they are using SQL Server 2000 and the code provided uses SQL Server 2005 features.

I think there should still be some breakdown between SQL Server 2000 and earlier versions and SQL Server 2005/2008. It is quite possible that many organizations may continue to use at least SQL Server 2000 for several more years as internal systems may not be migrated as long as they continue to provide service to the business. As some would say, why fix something that isn't broken.

My previous employer used Paradox to support remote offices, and the only reason we dropped the system was that Borland was not going to make Paradox Y2K compliant forcing use of that system. The same (or similiar) may happen with existing SQL Server 2000 applications.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #626241
Posted Sunday, December 28, 2008 6:23 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 22, 2014 2:32 AM
Points: 1,260, Visits: 3,423
I agree with you Lynn Petis ...but better will be like this:

SQL Server 2000
Administration
General
Backup & Recovery (backup, restore...)
Security and Auditing (logins, users, roles, schemas)
High Availability (Mirroring, Clustering, Log Shipping)
Performance and Tuning
Replication
Development
T-SQL - Any questions on the T-SQL language or code issues
.NET programming - With regards to querying SQL Servrs
SQL CLR - Assemblies

SQL Server 2005
Administration
General
Backup & Recovery (backup, restore...)
Security and Auditing (logins, users, roles, schemas)
High Availability (Mirroring, Clustering, Log Shipping)
Performance and Tuning
Replication
Development
T-SQL - Any questions on the T-SQL language or code issues
.NET programming - With regards to querying SQL Servrs
SQL CLR - Assemblies

SQL Server 2008
Administration
General
Backup & Recovery (backup, restore...)
Security and Auditing (logins, users, roles, schemas)
High Availability (Mirroring, Clustering, Log Shipping)
Performance and Tuning
Replication
Development
T-SQL - Any questions on the T-SQL language or code issues
.NET programming - With regards to querying SQL Servrs
SQL CLR - Assemblies





============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #626260
Posted Sunday, December 28, 2008 9:05 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 10:14 AM
Points: 35,371, Visits: 31,915
That's a pretty good layout... I like that. Especially when you make them all have the same layout. And, although it hasn't been mentioned, there is no need for a "newbies" section. It just dilutes the subjects.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #626289
Posted Sunday, December 28, 2008 9:21 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Wednesday, October 22, 2014 12:34 PM
Points: 31,181, Visits: 15,626
I really don't want to go 2 levels deep, and I really question how complicated things have gotten. Plus, what's a newbie? They don't necessarily know to post there, at least lots don't, and then when do they stop being a newbie?

I'd like to get down to 4-8 forums in each version if we go that way. And then how much of an issue is it if there are posts in the wrong place? We have lots of that now, and the idea would be to reduce this by having less forums.

Is it better to ask the OP for the version or hope they posted in the right spot?







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #626291
Posted Sunday, December 28, 2008 9:33 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 22, 2014 2:32 AM
Points: 1,260, Visits: 3,423
Steve I think you need more moderators to clean the posts in wrong sections!

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #626293
Posted Sunday, December 28, 2008 10:08 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, October 2, 2014 12:09 PM
Points: 4,358, Visits: 9,538
I would recommend that you don't get rid of the data corruption forum. It should be one that stands by itself for those cases where someone is really in need of recovering a corrupted databases.

Other than that, I agree with consolidating the groups as much as possible. Even to the point of consolidating the 2005/2008 forums instead of separate forums. Most of the functionality has not changed between the two - and, where a solution exists in 2008 only, the poster providing the solution can easily state that it is only valid in 2008.



Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #626298
Posted Sunday, December 28, 2008 10:45 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 9:35 AM
Points: 2,223, Visits: 3,649
Hmmmm. I dont know if this will be of any use. but what i feel is the structure be divided into two parts. a) Version b) Section.

A combo drop down for Version containing various versions
6.0
6.5
7
2000
2005
2008
with a default value of 2005 as major questions would be from this version at this time. Also, a striking header asking user to select proper version.

Second part contains section as mentioned in the editorial.

Administration
General
Backup and Recovery (backup, restore, detach, attach)
Security and auditing (logins, users, roles, schemas)
High Availability (Mirroring, Clustering, Log Shipping)
Performance and Tuning
Replication

Development
T-SQL - Any questions on the T-SQL language or code issues
.NET programming - With regards to querying SQL Servrs
SQL CLR - Assemblies

Miscellaneous
Anything not about SQL!
Humor
.....
.....


This will keep the page simple so users can scan through available sections quickly and post their queries in the most appropriate section.
This may ask for some major changes in that page and relevent backend but will make it simpler to use..... good for future... The column Forums in the detailed forum section could contain details like..
(2000) Replication, (2008) Backup and Recovery, (7.0) General etc....

Also, I've not taken into consideration another important aspect... ... that is various editions... like standard, enterprise.... I've seen users mentioning the editions if they're using lower editions.... syntaxes are almost same... only there is quantity of features that is different in various editions...






Pradeep Singh
Post #626304
Posted Sunday, December 28, 2008 11:11 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 5:50 AM
Points: 40,209, Visits: 36,618
Jeffrey Williams (12/28/2008)
I would recommend that you don't get rid of the data corruption forum. It should be one that stands by itself for those cases where someone is really in need of recovering a corrupted databases.


Indeed. We're not CSS, but we do get a fair few posts in there. If those were in the general admin, they'd be much, much harder to find and they probably wouldn't get the assistance they currently do.

Even to the point of consolidating the 2005/2008 forums instead of separate forums. Most of the functionality has not changed between the two


I was thinking much the same thing. There aren't that many differences between the two. New features, sure, but most of the existing stuff behaves very similar. It was 2000-2005 that saw a major engine rewrite.

I admit, I don't use the forum home page at all, but maybe something like this would work...

SQL 2005/2008
General admin (for stuff that doesn't belong in any of the more specific admin sections)
Backup/Restore
Replication
Security/auditing
Data corruption
T-SQL
CLR Development
Performance Tuning

SQL 2000/7
General admin
Backup/Restore
Replication
Security
Data corruption
T-SQL
Performance Tuning

Business Intelligence
Analysis Services
Reporting Services
Integration Services
DTS

Design and Strategy (for discussions of the theoretical concepts or planning)
High Availability
Database Design
Relational Theory
Hardware
General Strategies (for stuff that doesn't belong in the more specific forums)

Outside of SQL
Other database platforms (for problems interacting with Oracle, DB2, MySQL, Progress, etc)
SMO/RMO/DMO
Powershell


If you could hide the editorial, QotD and article discussions forums completely (ie make them not browsable via the forum home page) it would reduce the clutter, reduce the size of all the pages (anyone checked to see how many kb the drop down box at the bottom of each page is?) and stop people posting irrelevance stuff in them



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #626307
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse