|
|
-
|
|
Hi folks, Following are some useful query Shrinks the size of the data files in the specified database use : DBCC SHRINKDATABASE Shrinks the size of the specified data file or log file for the related database use : DBCC SHRINKFILE Closes the cu...
|
|
-
|
|
Hi friends Today I just come across this !! Following are steps to increase recent file option Go to Any any Plan SSMS,BIDS or VSD Click on Tools Select Option from Tools After Clicking on above link you will have following option in which ...
|
|
-
|
|
I must be apologize to my readers for this because of my non regularities. I will not let you down again for sure and will start boost posting again !! Just for an excuse I was busy in Lots of interview , Business Trip in Goa so I didn’t get time for b...
|
|
-
|
|
Hi friends Today just off the track I m posting some Stored Procedure Optimization Tips Following is Summery of Stored Procedure optimization Include SET NOCOUNT ON Use of sp_executesql instead of EXECUTE Naming Convention should b...
|
|
-
|
|
Hi friends After a week I am blogging on SQL Server Blog. I have already provided blogs on time as follows BISQL # 3 :Time and Date Query code and Analysis Part –I Hope I will be regular from onwards !! In this article we will just see few conversat...
|
|
-
|
|
Hi folks One Good news for you !! There is lots of opening in my company in many streams (Almost All ) We are organizing off campus in association with Times Job !! Click on Add for more details !! If your Interested Directly visit @ Venue ...
|
|
-
|
|
Hi folks ,
I just apologize to my reader for not posting from last week !!
Rather than throwing lots of reason I will just say I am lazy
.
So here onwards I will try to be regular !!
Continuing from my last post on SSIS Data Flow Task
MSBI # 38 – SSIS ......
|
|
-
|
|
Hi friends , As I have started random but in series blogging with different topics on Business Intelligence I have taken decision to go ahead with SQL server as well. In this random thoughts I am going to cover lots of out focused topics !! In this pos...
|
|
-
|
|
Hi friends , As I have already started some basic explanation of Data Flow Task on my last post: MSBI # 36 – SSIS # 15 – Control Flow Tasks # 8 – Data Flow Task # 1 « (B)usiness (I)ntelligence Mentalist In this post we will look further in base of Data Flow Task as follows : Basic......
|
|
-
|
|
Hi friends , Continuing from my last post on various Denali features in following post BISQL # 51 : SQL Server Denali Feature # 2 – Sequence number –All Explanation !! BISQL # 50 : SQL Server Denali Feature # 1- FileTables # 2 – Demo and Scriptin...
|
|