Viewing 15 posts - 991 through 1,005 (of 1,219 total)
Eugene Elutin (7/31/2013)
July 31, 2013 at 12:46 pm
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...
July 31, 2013 at 6:45 am
HowardW (7/31/2013)
my point was just that it's not all just T-SQL behind the scenes.
And my point is that that's exactly what it is - even if there is SMO in...
July 31, 2013 at 6:23 am
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...
July 31, 2013 at 6:09 am
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,...
July 31, 2013 at 1:57 am
Phil Parkin (7/31/2013)
Presumably you mean a global temp table.
No. Broccoli appears to be talking about a single script, divided into multiple batches. Thus a local temp table would do fine.
Although...
July 31, 2013 at 1:34 am
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...
July 31, 2013 at 1:29 am
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,...
July 31, 2013 at 1:11 am
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...
July 30, 2013 at 4:13 pm
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...
July 30, 2013 at 4:06 pm
You could use a single row temp table for your "global variables".
July 30, 2013 at 4:02 pm
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...
July 30, 2013 at 4:00 pm
Jeff Moden (7/30/2013)
July 30, 2013 at 3:56 pm
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...
July 30, 2013 at 3:51 pm
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...
July 30, 2013 at 3:44 pm
Viewing 15 posts - 991 through 1,005 (of 1,219 total)