Learnng resources
Keywords
- Big data, Bigdata, Big-data, MongoDB, Mongo DB
- NoSql, No sql, No-sql
- Training, Train, Learning programming, learn,
- Programming languages
Relational DB / Big Data / OLAP
Category Archives: SSMS
SQL SERVER – ENABLE QUERIES THAT REQUIRE TABLE RECREATION
At Sql Server Management studio sometime We run queries that changes table properties or structure.
At this point We get an error message that says something like:
“Please drop and recreate table…”.
The solution for it is here:
Create and Map a Server Environment
How to automate cube processing with XMLA OR AMO
http://aniruddhathengadi.blogspot.co.il/2011/12/how-to-automate-cube-processing.html
BI SSRS / SSMS / SSAS / SSMS
BI SSRS / SSMS / SSAS / SSMS
Password: nayabi2015 https://www.dropbox.com/sh/qjawz1tn033f2qn/AACgZP17vaBk4as_HwGBr4IIa?dl=0
Step by step of executing SSIS 2012 package through stored procedure
Step by step of executing SSIS 2012 package through stored procedure
http://blogs.msdn.com/b/biblog/archive/2013/05/07/step-by-step-of-executing-ssis-2012-package-through-stored-procedure.aspx
Differences between Delete and Truncate
How to find Object ID by name at SQL Server
How to find Object ID by name at SQL Server
Example of how to find ID of tables at database according to tables name:
SELECT * FROM sys.columns WHERE object_id = Object_id('employees')