|
|
-
|
|
Take a look at how SQL Server Import Export Wizard creates an SSIS Package to do the ETL. ...
|
|
-
|
|
How to Split a single row coming in input file to multiple rows when number of columns are not fixed in the input file....
|
|
-
|
|
Often developers use Import wizard from SSMS or SSIS to import data from a text file into a table. You may or may not import it successfully based on the nature of the data.
Create a text file named test.txt with the following data
id|name|address1|rame...
|
|
-
17
Liked
| 15
Learned
| 7
Comments
|
|
1) Transaction log are not recorded for table variables so they are transactional neutral or you can say that they are out of scope of transaction mechanism. Whereas temp tables participate in transactions just like normal tables
2) Table variables c......
|
|
-
|
|
A week ago, I posted for Insert, Update and Delete statement with TOP clause and Merge statement as individual post. If you not read those posts then read it before to move next. In this posts I used TOP clause with DML operations and Merge statement bu...
|
|
-
|
|
Did you know that table variables are stored in the tempdb database for execution scope only?. Ok. Let us run this code
declare @t table(i int)
select * from tempdb.INFORMATION_SCHEMA.TABLES
The result is
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
--------------------......
|
|
-
|
|
When you run the following codeselect name from sys.objects
having 1=1
you get the following error Msg 8120, Level 16, State 1, Line 2
Column 'sys.objects.name' is invalid in the select list because it is not contained in either an aggregate function or...
|
|
-
|
|
This post will explain how to build perspectives, partitions and aggregations for the SSAS project...
|
|
-
|
|
It will a lengthy and complex coding if we need to perform insert, update and delete statement individually. Instead of write separate statements for the insert, update and delete operation, we have one more option which can be very helpful in t......
|
|
-
|
|
This is common information which DBA required on daily basis for monitoring or reporting purpose. This is basic details which help us to get the database growth statistics on daily, weekly and monthly basis so we can have idea for the disk space managem...
|
|