| HTH |
Hope This Helps |
Used by answerers to sign
off, while posting an answer.
Sometimes, HTH also means, Hell This Hurts. Could be
used while posting a frustrating problem
;-) |
| TIA |
Thanks In Advance |
Used
by askers, who don't have time to thank
the answerer, after receiving a solution
;-) |
| IMO |
In My Opinion |
Example: IMO, you should
have a clustered index on this table. |
| IMHO |
In My Humble Opinion |
Example:
IMHO,
the next version of SQL Server will beat
the hell out of Oracle. |
| IMNSHO |
In My Not So Humble Opinion |
Example: IMNSHO, all tables in
a production db should be owned by dbo. |
| RTFM |
Read The Fucking Manual |
Expect
this kind of answer (from rude Gurus),
when you ask a question, for which the
solution is very much available in the
documentation. |
| AFAIK |
As Far As I Know |
Example: AFAIK, this
functionality is available in Oracle, not
in SQL Server. |
| EM |
Enterprise Manager |
|
| SEM |
SQL Enterprise Manager |
|
| BOL |
Books Online |
|
| QA |
Query Analyzer |
|
| SS7, SS2k |
SQL Server 7.0, SQL Server 2000, |
|
| MS |
Microsoft |
|
| Doc'ed/Docs |
Documented/Documentation |
Example:
This is by design and is doc'ed in BOL.
Example: Refer to the docs. |
| RTM |
Release To Manufacturing |
RTM refers to the
first version of a product that is
released to market. RTM is also called
Golden release.
Example: This problem is seen in Beta 3
and can't be reproduced in the RTM version. |
| Repro |
Reproduction |
Example:
Give me the steps to repro this problem.
Example: This problem can't be repro'ed on Windows
2000. |
| PRB |
Problem |
It's a keyword used in
the titles of Microsoft knowledge base
articles that talk about problems. |
| INF |
Information |
It's a
keyword used in the titles of Microsoft
knowledge base articles that provide
additional information about a particular
topic. |
| PSS |
Product Support Services |
It's the technical
support division of Microsoft (http://support.microsoft.com).
Example: This is an access violation in
the sqlserver.exe. It's better to contact
MS PSS, than waiting for a solution in
the newsgroups. |
| SP |
Service Pack |
Example:
Install the latest SP and try again.
SP also means Stored Procedure. |
| KB/KBA/MSKB |
Knowledge Base/Knowledge Base Article/Microsoft Knowledge Base |
Knowledge Base articles can
be searched at: http://support.microsoft.com
Example: Search KB before posting
your problems in the newsgroup.
Example: Please see KBA Q134233
Example: Lookup MSKB |
| Q article |
Knowledge
Base article |
All
Microsoft knowledge base articles have a
unique ID that starts with Q. So, people
(including Microsoft support personnel)
refer to these articles as Q articles. |
| PK,
FK |
Primary Key, Foreign Key |
|
| tlog/tran log |
Transaction
Log |
|
| OT |
Off Topic |
Example: I know this is a
little OT, but I thought
someone in this newsgroup would be able
to answer my DB2 question. |
| ng |
News Group |
|
| DRP |
Disaster Recovery Plan/Planning |
|
| FYI |
For Your Information |
Example:
FYI, this query also works
in SQL Server 6.5 |
| ASAP |
As Soon As Possible |
Example: I want a
solution to this problem ASAP |
| BTW |
By The Way |
Example:
Btw, I already tried the
solution provided by John, but it didn't
help! |
| DDL |
Data Definition Language |
Basically refers to the
structure of database objects like tables
and views.
Example: Please post the DDL, so that I can
reproduce your problem. |
| DML |
Data Manipulation Language |
Refers
to queries.
Example: Please post your DDL and DML, so that we can
reproduce your problem. |
| OTOH |
On The Other Hand |
Example: Reduce the
number of indexes on an OLTP table, OTOH, create as many
indexes as you need on a DSS (read-only)
table. |
| OS |
Operating System |
Example:
What OS are you running
on? |
| YMMV |
Your Mileage May Vary |
Example: I see a 15%
improvement in query response times after
running this command, but YMMV. |
| WRT |
With Respect To |
Example: WRT your other
problem... |
| IOW |
In Other Words |
Example: IOW, it's just not
possible... |
| IIRC |
If I
Recall
Correctly |
Example:
IIRC, Microsoft already
provided a hotfix for this problem. |
| OLAP |
Online Analytical Processing |
OLAP is the technology that
enables client applications and analysts
to efficiently access the data. For more
information, see SQL Server Books Online. |
| OLTP |
Online Transaction Processing |
Systems
that process transactions in real time as
opposed to batch processing are known as OLTP systems. |
| DSS |
Decision Support Systems |
DSS support the decision
making process my analysing existing
data, as well as by predicting based on
existing data. |
| GUI |
Graphical User
Interface |
GUI is a user interface
based on graphics (icons, pictures and
menus) instead of text. |
