Eugene Elutin (7/31/2013)

---

Do you mean Sybase? I have worked with SQL server since their rebranded version of Sybase. Some people might called them as they used to in Sybase, but...

HowardW (2013-07-31)

---

I seem to remember there are some properties of objects that are literally inaccessible through system tables/DMVs and are only accessible through SMO, struggling to find an example at...

HowardW (7/31/2013)

---

And my point is that that's exactly what it is - even if there is SMO in...

HowardW (7/31/2013)

---

Well, mostly. Not that it's secret, but it does also use DMO/SMO for lots of the scripting capability

It is correct that SSMS uses SMO, but guess how SMO speaks...

Phil Parkin (7/31/2013)

---

If this stuff is worth storing in a table and is going to be referenced by multiple scripts or procs, it should be held in a permanent table,...

Although...

A float value consists of a 53-bit manitssa and an exponent. This format permits a wide range of value - from 1E310 to 1E-310 at the price of exactness. Decimal...

I forgot to mention: the AdventureWorks2008DW is a regular relational database, so you attach it to the Database Engine like any other database.

As for how to get started with SSAS,...

The behaviour you see is perfectly normal. For instance, running SQLCMD, I see:

1> SELECT convert(float, 3.56)

2> go

------------------------

3.5600000000000001

(1 rows affected)

In SSMS, the value is displayed...

Which edition of SQL Server 2008 R2 did you install? There is no Analysis Services in Express Edition. If you have Developer, Standard, Enterprise or Evaluation Edition, you can run...

You could use a single row temp table for your "global variables".

Linked servers uses OLE DB and not ODBC. While you can use the MSDASQL provider to do OLE DB over ODBC, I think it is better to use an OLE...

Jeff Moden (7/30/2013)

---

Use Bulk Insert to read just the first line of a file into a single column temp table. Split that column on the delimiter to extract the...

In SSMS, use the Script button to see what command that SSMS generates. Keep in mind that SSMS has no secret interface to SQL Server, but it uses T-SQL just...

You could probably add triggers on the appropriate tables in tempdb, but I think it is better to deprive him of his membership in that role, and have him to...